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 com.alibaba.druid.pool.DruidPooledConnection.releaseSavepoint()

            Assert.assertNotNull(error);
        }
        {
            Exception error = null;
            try {
                conn.releaseSavepoint(null);
            } catch (SQLException e) {
                error = e;
            }
            Assert.assertNotNull(error);
        }

View Full Code Here

Examples of java.sql.Connection.releaseSavepoint()

            final Savepoint savepoint = localStuff.get(handle).getCheckpoints().remove(name);
            if (savepoint == null) {
                throw new TransactionException(String.format("Attempt to rollback to non-existant savepoint, '%s'",
                                                             name));
            }
            conn.releaseSavepoint(savepoint);
        }
        catch (SQLException e) {
            throw new TransactionException(String.format("Unable to create checkpoint %s", name), e);
        }
    }

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

Examples of java.sql.Connection.releaseSavepoint()

     * Test2 - After releasing a savepoint, should be able to reuse it.
     */
    public void testReusingSavepoints() throws SQLException {
        Connection con = getConnection();
        Savepoint savepoint1 = con.setSavepoint("s1");
        con.releaseSavepoint(savepoint1);
        con.setSavepoint("s1");
        con.rollback();
    }


    /**

View Full Code Here

Examples of java.sql.Connection.releaseSavepoint()

        // in a different transaction
        con.setSavepoint("s2");
        Statement s = createStatement();
        s.executeUpdate("INSERT INTO T1 VALUES(2,1)");
        try {
            con.releaseSavepoint(savepoint1);
            fail("FAIL 5a - release savepoint from a different transaction "
                    + "did not raise error");
        } catch (SQLException se) {
            // Expected exception.
            assertSQLState("3B001", se);

View Full Code Here

Examples of java.sql.Connection.releaseSavepoint()

     * same name. and release the first one
     */
    public void testReleaseReleasedSavepoint() throws SQLException {
        Connection con = getConnection();
        Savepoint savepoint1 = con.setSavepoint("s1");
        con.releaseSavepoint(savepoint1);
        // The following savepoint was earlier named s1. Changed it to s2 while
        // working on DRDA support
        // for savepoints. The reason for that is as follows
        // The client translates all savepoint jdbc calls to equivalent sql and
        // hence

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.