Examples of java.sql.DatabaseMetaData.supportsTransactions()

java.sql.DatabaseMetaData.supportsTransactions()
Determine whether transactions are supported.
If transactions are not supported, then the commit method does nothing and the transaction isolation level is always TRANSACTION_NONE. @return true if transactions are supported otherwisefalse. @throws SQLException a database error occurred

      System.out.println("getMaxTablesInSelect(): " +
                 met.getMaxTablesInSelect());
      System.out.println("getMaxUserNameLength(): " +
                 met.getMaxUserNameLength());
      System.out.println("supportsTransactions(): " +
                 met.supportsTransactions());
      System.out.println("supportsTransactionIsolationLevel(Connection.TRANSACTION_NONE): " +
                 met.supportsTransactionIsolationLevel(Connection.TRANSACTION_NONE));
      System.out.println("supportsTransactionIsolationLevel(Connection.TRANSACTION_REPEATABLE_READ): " +
                 met.supportsTransactionIsolationLevel(Connection.TRANSACTION_REPEATABLE_READ));
      System.out.println("supportsTransactionIsolationLevel(Connection.TRANSACTION_SERIALIZABLE): " +

View Full Code Here

      System.out.println("getMaxTablesInSelect(): " +
                 met.getMaxTablesInSelect());
      System.out.println("getMaxUserNameLength(): " +
                 met.getMaxUserNameLength());
      System.out.println("supportsTransactions(): " +
                 met.supportsTransactions());
      System.out.println("supportsTransactionIsolationLevel(Connection.TRANSACTION_NONE): " +
                 met.supportsTransactionIsolationLevel(Connection.TRANSACTION_NONE));
      System.out.println("supportsTransactionIsolationLevel(Connection.TRANSACTION_REPEATABLE_READ): " +
                 met.supportsTransactionIsolationLevel(Connection.TRANSACTION_REPEATABLE_READ));
      System.out.println("supportsTransactionIsolationLevel(Connection.TRANSACTION_SERIALIZABLE): " +

View Full Code Here

        // 1 - There is more than one supported level
        // 2 - There is one supported level which is not TRANSACTION_NONE
        boolean expectedSupport = supportedLevels.size() > 0
                && (supportedLevels.size() != 1 || (supportedLevels.size() == 1 && !supportedLevels.get(0).equals(
                        Connection.TRANSACTION_NONE)));
        Assert.assertEquals(expectedSupport, metadata.supportsTransactions());


        for (int level : TRANSACTION_LEVELS) {
            Assert.assertEquals(supportedLevels.contains(level), metadata.supportsTransactionIsolationLevel(level));
        }
    }

View Full Code Here

      System.out.println("getMaxTablesInSelect(): " +
                 met.getMaxTablesInSelect());
      System.out.println("getMaxUserNameLength(): " +
                 met.getMaxUserNameLength());
      System.out.println("supportsTransactions(): " +
                 met.supportsTransactions());
      System.out.println("supportsTransactionIsolationLevel(Connection.TRANSACTION_NONE): " +
                 met.supportsTransactionIsolationLevel(Connection.TRANSACTION_NONE));
      System.out.println("supportsTransactionIsolationLevel(Connection.TRANSACTION_REPEATABLE_READ): " +
                 met.supportsTransactionIsolationLevel(Connection.TRANSACTION_REPEATABLE_READ));
      System.out.println("supportsTransactionIsolationLevel(Connection.TRANSACTION_SERIALIZABLE): " +

View Full Code Here

        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_REPEATABLE_READ));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_SERIALIZABLE));
        
        assertTrue(dmd.supportsTransactions());
        assertTrue(dmd.supportsUnion());
        assertTrue(dmd.supportsUnionAll());         
    }
    
    /**

View Full Code Here

        int currentIsolation = Connection.TRANSACTION_NONE;
        final DatabaseMetaData meta = _conn.getMetaData();
        _databaseInfo = meta.getDatabaseProductName() + " - " + meta.getDatabaseProductVersion();
        HenPlus.msg().println(" " + _databaseInfo);
        try {
            if (meta.supportsTransactions()) {
                currentIsolation = _conn.getTransactionIsolation();
            } else {
                HenPlus.msg().println("no transactions.");
            }
            _conn.setAutoCommit(false);

View Full Code Here

        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_REPEATABLE_READ));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_SERIALIZABLE));
        
        assertTrue(dmd.supportsTransactions());
        assertTrue(dmd.supportsUnion());
        assertTrue(dmd.supportsUnionAll());         
    }
    
    /**

View Full Code Here

        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_REPEATABLE_READ));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_SERIALIZABLE));
        
        assertTrue(dmd.supportsTransactions());
        assertTrue(dmd.supportsUnion());
        assertTrue(dmd.supportsUnionAll());         
    }
    
    /**

View Full Code Here

        boolean supportsOrderByUnrelated = dbMetaData.supportsOrderByUnrelated();
        boolean supportsPositionedDelete = dbMetaData.supportsPositionedDelete();


        boolean supportsSelectForUpdate = dbMetaData.supportsSelectForUpdate();
        boolean supportsStoredProcedures = dbMetaData.supportsStoredProcedures();
        boolean supportsTransactions = dbMetaData.supportsTransactions();
        boolean supportsUnion = dbMetaData.supportsUnion();
        boolean supportsUnionAll = dbMetaData.supportsUnionAll();


        int getMaxColumnNameLength = dbMetaData.getMaxColumnNameLength();
        int getMaxColumnsInIndex = dbMetaData.getMaxColumnsInIndex();

View Full Code Here

        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_REPEATABLE_READ));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_SERIALIZABLE));
        
        assertTrue(dmd.supportsTransactions());
        assertTrue(dmd.supportsUnion());
        assertTrue(dmd.supportsUnionAll());         
    }
    
    /**

View Full Code Here

0 1 2 3

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.