List of releaseSavepoint() Examples

Examples of releaseSavepoint()

com.alibaba.druid.pool.DruidPooledConnection.releaseSavepoint()
java.sql.Connection.releaseSavepoint()
Removes the specified Savepoint and subsequent Savepoint objects from the current transaction. Any reference to the savepoint after it have been removed will cause an SQLException to be thrown. @param savepoint the Savepoint object to be removed @exception SQLException if a database access error occurs, thismethod is called on a closed connection or the given Savepoint object is not a valid savepoint in the current transaction @exception SQLFeatureNotSupportedException if the JDBC driver does not supportthis method @since 1.4
org.apache.derby.iapi.sql.conn.LanguageConnectionContext.releaseSavePoint()
Let the context deal with a release of a savepoint @param savepointName Name of the savepoint that needs to be released @param kindOfSavepoint A NULL value means it is an internal savepoint (ie not a user defined savepoint)Non NULL value means it is a user defined savepoint which can be a SQL savepoint or a JDBC savepoint A String value for kindOfSavepoint would mean it is SQL savepoint A JDBC Savepoint object value for kindOfSavepoint would mean it is JDBC savepoint @exception StandardException thrown if something goes wrong
org.apache.derby.iapi.store.access.TransactionController.releaseSavePoint()
Release the save point of the given name. Releasing a savepoint removes all knowledge from this transaction of the named savepoint and any savepoints set since the named savepoint was set. @param name The user provided name of the savepoint, set by the userin the setSavePoint() call. @param kindOfSavepoint A NULL value means it is an internal savepoint (ie not a user defined savepoint)Non NULL value means it is a user defined savepoint which can be a SQL savepoint or a JDBC savepoint A String value for kindOfSavepoint would mean it is SQL savepoint A JDBC Savepoint object value for kindOfSavepoint would mean it is JDBC savepoint @return returns savepoint position in the stack. @exception StandardException Standard cloudscape exception policy. A statement level exception is thrown if no savepoint exists with the given name.
org.apache.openjpa.persistence.OpenJPAEntityManager.releaseSavepoint()
Release the last set savepoint and any resources associated with it. The given savepoint and any set after it will become invalid.

Examples of java.sql.Connection.releaseSavepoint()

    public void testReleaseMultipleTimes() throws SQLException {
        Connection con = getConnection();
        Savepoint savepoint1 = con.setSavepoint("MyName");
        con.releaseSavepoint(savepoint1);
        try {
            con.releaseSavepoint(savepoint1);
            fail("FAIL 12 releasing a savepoint multiple times should fail");
        } catch (SQLException se) {
            // Expected exception.
            assertSQLState("3B001", se);
        }

View Full Code Here

Examples of java.sql.Connection.releaseSavepoint()

        con.setAutoCommit(true);
        con.setAutoCommit(false);
        Savepoint savepoint2 = con.setSavepoint("MyName1");
        try {// shouldn't be able to use savepoint from earlier tranasaction
            // after setting autocommit on and off
            con.releaseSavepoint(savepoint1);
            fail("FAIL 13 shouldn't be able to use a savepoint from earlier "
                    + "transaction after setting autocommit on and off");
        } catch (SQLException se) {
            // Expected exception.
            assertSQLState("3B001", se);

View Full Code Here

Examples of java.sql.Connection.releaseSavepoint()

                    + "transaction after setting autocommit on and off");
        } catch (SQLException se) {
            // Expected exception.
            assertSQLState("3B001", se);
        }
        con.releaseSavepoint(savepoint2);
        con.rollback();
    }


    /**
     * Test 14 cause a transaction rollback and that should release the internal

View Full Code Here

Examples of java.sql.Connection.releaseSavepoint()

            // Expected exception.
            assertSQLState("40XL1", se);
        }
        try {// the transaction rollback above should have removed the
            // savepoint MyName
            con2.releaseSavepoint(savepoint1);
            fail("FAIL 14 A non-user initiated transaction rollback should "
                    + "release the internal savepoint array");
        } catch (SQLException se) {
            // Expected exception.
            assertSQLState("3B001", se);

View Full Code Here

Examples of java.sql.Connection.releaseSavepoint()

            // Expected exception.
            assertSQLState("3B002", se);
        }
        // rollback the JDBC savepoint. Now since there are no user defined
        // savepoints, we can define SQL savepoint
        con.releaseSavepoint(savepoint1);
        s.executeUpdate("SAVEPOINT s1 ON ROLLBACK RETAIN LOCKS ON "
                + "ROLLBACK RETAIN CURSORS");
        con.rollback();
    }

View Full Code Here

Examples of java.sql.Connection.releaseSavepoint()

        con.rollback(savepoint2);
        assertTableRowCount("T1", 1);


        // Trying to release second named savepoint s2 should throw exception.
        try {
            con.releaseSavepoint(savepoint3);
            fail("FAIL 41a release of rolled back savepoint");
        } catch (SQLException se) {
            // Expected exception.
            assertSQLState("3B001", se);
        }

View Full Code Here

Examples of java.sql.Connection.releaseSavepoint()

                assertSQLState("3B501", se);
            } else if (usingDerbyNetClient()) {
                assertSQLState("3B002", se);
            }
        }
        con.releaseSavepoint(savepoint1);
        con.setSavepoint("s1");
        con.rollback();
    }


    /**

View Full Code Here

Examples of java.sql.Connection.releaseSavepoint()

        Connection con = getConnection();
        Savepoint savepoint1 = con.setSavepoint();
        Savepoint savepoint2 = con.setSavepoint();
        savepoint1.getSavepointId();
        savepoint2.getSavepointId();
        con.releaseSavepoint(savepoint2);
        savepoint2 = con.setSavepoint();
        savepoint2.getSavepointId();
        con.commit();
        savepoint2 = con.setSavepoint();
        savepoint2.getSavepointId();

View Full Code Here

Examples of java.sql.Connection.releaseSavepoint()

            // Expected exception.
            assertSQLState("3B002", se);
        }
        // rollback JDBC savepoint but still can't have SQL savepoint because
        // there is still one JDBC savepoint
        con.releaseSavepoint(savepoint2);
        try {
            s.executeUpdate("SAVEPOINT s1 ON ROLLBACK RETAIN LOCKS ON ROLLBACK"
                    + " RETAIN CURSORS");
            fail("FAIL 48 Should have gotten exception for nested SQL savepoint");
        } catch (SQLException se) {

View Full Code Here

Examples of java.sql.Connection.releaseSavepoint()

        } catch (SQLException se) {
            // Expected exception.
            assertSQLState("3B002", se);


        }
        con.releaseSavepoint(savepoint1); // rollback last JDBC savepoint and
        // now try SQL savepoint again
        s.executeUpdate("SAVEPOINT s1 ON ROLLBACK RETAIN LOCKS ON ROLLBACK "
                + "RETAIN CURSORS");
        con.rollback();
    }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.