List of supportsOpenCursorsAcrossCommit() Examples

Examples of supportsOpenCursorsAcrossCommit()

java.sql.DatabaseMetaData.supportsOpenCursorsAcrossCommit()
Determine whether keeping Cursors open across Commit operations is supported. @return true if Cursors can be kept open across Commitoperations, false if they might get closed. @throws SQLException a database error occurred

Examples of java.sql.DatabaseMetaData.supportsOpenCursorsAcrossCommit()

    private static void runCursor( Connection conn, int maxColValue, String[][][] dupVals)
        throws SQLException
    {
        System.out.println( "Running scroll insensitive cursor");
        DatabaseMetaData dmd = conn.getMetaData();
        boolean holdOverCommit = dmd.supportsOpenCursorsAcrossCommit();
        Statement stmt;
        if( holdOverCommit)
            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                        ResultSet.CONCUR_READ_ONLY,
                                        ResultSet.HOLD_CURSORS_OVER_COMMIT);

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsOpenCursorsAcrossCommit()

        assertFalse(dmd.supportsNamedParameters());
        assertTrue(dmd.supportsNonNullableColumns());
        
        // Open cursors are not supported across global
        // (XA) transactions so the driver returns false.
        assertFalse(dmd.supportsOpenCursorsAcrossCommit());
        
        assertFalse(dmd.supportsOpenCursorsAcrossRollback());
        assertTrue(dmd.supportsOpenStatementsAcrossCommit());
        
        assertFalse(dmd.supportsOpenStatementsAcrossRollback());

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsOpenCursorsAcrossCommit()

      System.out.println("supportsUnion(): " +
                 met.supportsUnion());
      System.out.println("supportsUnionAll(): " +
                 met.supportsUnionAll());
      System.out.println("supportsOpenCursorsAcrossCommit(): " +
                 met.supportsOpenCursorsAcrossCommit());
      System.out.println("supportsOpenCursorsAcrossRollback(): " +
                 met.supportsOpenCursorsAcrossRollback());
      System.out.println("supportsOpenStatementsAcrossCommit(): " +
                 met.supportsOpenStatementsAcrossCommit());
      System.out.println("supportsOpenStatementsAcrossRollback(): " +

View Full Code Here

0 1 2

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.