Package java.sql

Examples of java.sql.DatabaseMetaData.supportsTransactionIsolationLevel()

393
394
395
396
397
398
399
400
401
402
403
                Connection.TRANSACTION_READ_COMMITTED));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_READ_UNCOMMITTED));
        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
572
573
574
575
576
577
578
579
580
581
582
          Connection.TRANSACTION_SERIALIZABLE };

      DatabaseMetaData dbmd = this.conn.getMetaData();

      for (int i = 0; i < isolationLevels.length; i++) {
        if (dbmd.supportsTransactionIsolationLevel(isolationLevels[i])) {
          this.conn.setTransactionIsolation(isolationLevels[i]);

          assertTrue(
              "Transaction isolation level that was set ("
                  + isoLevelNames[i]
View Full Code Here
277
278
279
280
281
282
283
284
285
286
287
            public RubyBoolean call(final Connection connection) throws SQLException {
                final DatabaseMetaData metaData = connection.getMetaData();
                final boolean supported;
                if ( isolation != null && ! isolation.isNil() ) {
                    final int level = mapTransactionIsolationLevel(isolation);
                    supported = metaData.supportsTransactionIsolationLevel(level);
                }
                else {
                    final int level = metaData.getDefaultTransactionIsolation();
                    supported = level > Connection.TRANSACTION_NONE; // > 0
                }
View Full Code Here
480
481
482
483
484
485
486
487
488
489
490
        assertTrue(dmd.supportsSubqueriesInExists());
        assertTrue(dmd.supportsSubqueriesInIns());
        assertTrue(dmd.supportsSubqueriesInQuantifieds());
        assertTrue(dmd.supportsTableCorrelationNames());
       
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_READ_COMMITTED));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_READ_UNCOMMITTED));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_REPEATABLE_READ));
View Full Code Here
482
483
484
485
486
487
488
489
490
491
492
        assertTrue(dmd.supportsSubqueriesInQuantifieds());
        assertTrue(dmd.supportsTableCorrelationNames());
       
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_READ_COMMITTED));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_READ_UNCOMMITTED));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_REPEATABLE_READ));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_SERIALIZABLE));
View Full Code Here
484
485
486
487
488
489
490
491
492
493
494
       
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_READ_COMMITTED));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_READ_UNCOMMITTED));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_REPEATABLE_READ));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_SERIALIZABLE));
       
        assertTrue(dmd.supportsTransactions());
View Full Code Here
486
487
488
489
490
491
492
493
494
495
496
                Connection.TRANSACTION_READ_COMMITTED));
        assertTrue(dmd.supportsTransactionIsolationLevel(
                Connection.TRANSACTION_READ_UNCOMMITTED));
        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
491
492
493
494
495
496
497
498
499
500
501
      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): " +
                 met.supportsTransactionIsolationLevel(Connection.TRANSACTION_SERIALIZABLE));
      System.out.println("supportsDataDefinitionAndDataManipulationTransactions(): " +
View Full Code Here
493
494
495
496
497
498
499
500
501
502
503
      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): " +
                 met.supportsTransactionIsolationLevel(Connection.TRANSACTION_SERIALIZABLE));
      System.out.println("supportsDataDefinitionAndDataManipulationTransactions(): " +
                 met.supportsDataDefinitionAndDataManipulationTransactions());
      System.out.println("supportsDataManipulationTransactionsOnly(): " +
View Full Code Here
495
496
497
498
499
500
501
502
503
504
505
      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): " +
                 met.supportsTransactionIsolationLevel(Connection.TRANSACTION_SERIALIZABLE));
      System.out.println("supportsDataDefinitionAndDataManipulationTransactions(): " +
                 met.supportsDataDefinitionAndDataManipulationTransactions());
      System.out.println("supportsDataManipulationTransactionsOnly(): " +
                 met.supportsDataManipulationTransactionsOnly());
      System.out.println("dataDefinitionCausesTransactionCommit(): " +
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.