Examples of java.sql.Connection.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

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

        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

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


    /**

View Full Code Here

        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

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

        } 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

        }
        assertFalse(aes12.didConnectionClosedEventHappen());
        assertTrue(aes12.didConnectionErrorEventHappen());
        aes12.resetState();
        try {
            conn.releaseSavepoint((Savepoint)null);
            fail("SQLException of 08003 should be thrown!");
        } catch (SQLException e) {
            assertSQLState("08003", e);
        }
        assertFalse(aes12.didConnectionClosedEventHappen());

View Full Code Here

  }


  public static void doConnectionReleaseSavepoint() throws Throwable
  {
    Connection conn = DriverManager.getConnection("jdbc:default:connection");
    conn.releaseSavepoint((Savepoint) null);
    Statement s = conn.createStatement();
    s.executeUpdate("insert into t2 values(1)");
  }


  static private void dumpSQLExceptions (SQLException se) {

View Full Code Here

  }


  public static void doConnectionReleaseSavepoint() throws Throwable
  {
    Connection conn = DriverManager.getConnection("jdbc:default:connection");
    conn.releaseSavepoint((Savepoint) null);
    Statement s = conn.createStatement();
    s.executeUpdate("insert into t2 values(1)");
  }


   public static void dumpSQLExceptions (SQLException se) {

View Full Code Here

  }


  public static void doConnectionReleaseSavepoint() throws Throwable
  {
    Connection conn = DriverManager.getConnection("jdbc:default:connection");
    conn.releaseSavepoint((Savepoint) null);
    Statement s = conn.createStatement();
    s.executeUpdate("insert into t2 values(1)");
  }


  static private void dumpSQLExceptions (SQLException se) {

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.