Examples of java.sql.Savepoint

java.sql.Savepoint
A Savepoint is an instant during the current transaction that can be utilised by a Rollback from the Connection.rollback method. Rolling back to a particular Savepoint means that all changes that occurred after that Savepoint are removed.

        // Try with named save points
        this.conn.setAutoCommit(false);
        this.stmt
            .executeUpdate("INSERT INTO testSavepoints VALUES (1)");


        Savepoint afterInsert = this.conn.setSavepoint("afterInsert");
        this.stmt.executeUpdate("UPDATE testSavepoints SET field1=2");


        Savepoint afterUpdate = this.conn.setSavepoint("afterUpdate");
        this.stmt.executeUpdate("DELETE FROM testSavepoints");


        assertTrue("Row count should be 0",
            getRowCount("testSavepoints") == 0);
        this.conn.rollback(afterUpdate);

View Full Code Here

        //logic to scan all the records to find another rcord for 
        //comparison.
        con.setAutoCommit(false);
        assertEquals (499, stmt.executeUpdate (
                "delete from constraintest where val1 != '0'"));
        Savepoint deleted = con.setSavepoint("deleted");
        ps.setString(1, "0");
        ps.setString (2, "test");
        try {
            ps.execute();
            fail ("managed to insert a duplicate");

View Full Code Here

        throws SQLException
    {
        conn.setAutoCommit(false);
        addClass(classes, conn.getClass(), java.sql.Connection.class);


        Savepoint sp = conn.setSavepoint();
        addClass(classes, sp.getClass(), java.sql.Savepoint.class);
        conn.releaseSavepoint(sp);


        DatabaseMetaData dmd = conn.getMetaData();
        addClass(classes, dmd.getClass(), java.sql.DatabaseMetaData.class);

View Full Code Here

     */
    public void testGetKeyAfterSavepointRollback() throws SQLException
    {
        Connection conn = getConnection();
        Statement s = createStatement();
        Savepoint savepoint1 = conn.setSavepoint();


        int expected=1;


        s.execute("insert into t11_AutoGen(c11) values(99)", 
            Statement.RETURN_GENERATED_KEYS);

View Full Code Here

                // to enforce DB2 restriction which is savepoint name
                // can't start with SYS
                if (userSuppliedSavepointName && name.startsWith("SYS")) {
                    throw newSQLException(SQLState.INVALID_SCHEMA_SYS, "SYS");
                }
                Savepoint savePt = new EmbedSavepoint(this, name);
                return savePt;
            } catch (StandardException e) {
                throw handleException(e);
            } finally {
                restoreContextStack();

View Full Code Here

    /**
     * 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

     * @throws SQLException
     */
    public void testNamesAndIds() throws SQLException {
        Connection con = getConnection();
        try {
            Savepoint savepoint1 = con.setSavepoint();
            savepoint1.getSavepointId();
            // following should throw exception for unnamed savepoint
            savepoint1.getSavepointName();
            fail("FAIL 4 getSavepointName on id savepoint");
        } catch (SQLException se) {
            // Expected exception.
            assertSQLState("XJ014", se);
        }
        con.rollback();
        try {
            Savepoint savepoint1 = con.setSavepoint("s1");
            savepoint1.getSavepointName();
            // following should throw exception for named savepoint
            savepoint1.getSavepointId();
            fail("FAIL 4 getSavepointId on named savepoint ");
        } catch (SQLException se) {
            // Expected exception.
            assertSQLState("XJ013", se);
        }

View Full Code Here

     * different transactions and release the first one in the subsequent
     * transaction
     */
    public void testBug4465() throws SQLException {
        Connection con = getConnection();
        Savepoint savepoint1 = con.setSavepoint("s1");
        con.commit();
        // 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

View Full Code Here

     * test 6a - create a savepoint release it and then create another with the
     * 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

View Full Code Here

     * test 6b - create a savepoints release it and then create another with the
     * same name. and rollback the first one
     */
    public void testRollbackReleasedSavepoint() 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

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of java.sql.Savepoint

arjdbc.jdbc.RubyJdbcConnection

br.com.objectos.comuns.relational.jdbc.TransactionsGuice

br.com.objectos.way.relational.TransactionsGuice

com.alibaba.druid.bvt.pool.DruidPooledConnectionTest

com.alibaba.druid.bvt.proxy.BasicTypeTest

com.alibaba.druid.bvt.proxy.ConnectionTest

com.alibaba.druid.filter.logging.LogFilter

com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl

com.cloud.utils.db.Merovingian

com.cloud.utils.db.Transaction

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.