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()

        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()

        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

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

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

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()


  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()

        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()

        boolean supportsOuterJoins = dbMetaData.supportsOuterJoins();
        boolean supportsFullOuterJoins = dbMetaData.supportsFullOuterJoins();
        boolean supportsLimitedOuterJoins = dbMetaData.supportsLimitedOuterJoins();


        boolean supportsMultipleTransactions = dbMetaData.supportsMultipleTransactions();
        boolean supportsOpenCursorsAcrossCommit = dbMetaData.supportsOpenCursorsAcrossCommit();
        boolean supportsOpenCursorsAcrossRollback = dbMetaData.supportsOpenCursorsAcrossRollback();
        boolean supportsOpenStatementsAcrossCommit = dbMetaData.supportsOpenStatementsAcrossCommit();
        boolean supportsOpenStatementsAcrossRollback = dbMetaData.supportsOpenStatementsAcrossRollback();


        boolean supportsOrderByUnrelated = dbMetaData.supportsOrderByUnrelated();

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.