jdbc查看数据库事务隔离级别

jdbc查看数据库事务隔离级别

数据库事务 2009-07-04 15:22:53 阅读111 评论0  字号：大中小 订阅

public static void main(String[] args) {
 String driverClass = "net.sourceforge.jtds.jdbc.Driver";
 // driverClass = "com.mysql.jdbc.Driver";
 driverClass = "oracle.jdbc.driver.OracleDriver";

 String url = "jdbc:jtds:sqlserver://localhost:1433;DatabaseName=zypsb";
 // url =
 // "jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=gb2312";
 url = "jdbc:oracle:thin:@localhost:1521:SUNJUN";
 try {
  Class.forName(driverClass);
  Connection con = DriverManager.getConnection(url, "system",
    "sunjun");
  DatabaseMetaData dbmt = con.getMetaData();
  System.out.println(dbmt.supportsTransactions());
  // 0
  if (dbmt
    .supportsTransactionIsolationLevel(Connection.TRANSACTION_NONE))
   System.out.println("TRANSACTION_NONE");
  // 1
  if (dbmt
    .supportsTransactionIsolationLevel(Connection.TRANSACTION_READ_UNCOMMITTED))
   System.out.println("TRANSACTION_READ_UNCOMMITTED");
  // 2
  if (dbmt
    .supportsTransactionIsolationLevel(Connection.TRANSACTION_READ_COMMITTED))
   System.out.println("TRANSACTION_READ_COMMITTED");
  // 4
  if (dbmt
    .supportsTransactionIsolationLevel(Connection.TRANSACTION_REPEATABLE_READ))
   System.out.println("TRANSACTION_REPEATABLE_READ");
  // 8
  if (dbmt
    .supportsTransactionIsolationLevel(Connection.TRANSACTION_SERIALIZABLE))
   System.out.println("TRANSACTION_SERIALIZABLE");
  System.out.println(dbmt.getDefaultTransactionIsolation());
 } catch (Exception e) {
  e.printStackTrace();
 }
}

---------------------------------------------------------------------------------------------------
sqlserver  2000
true
TRANSACTION_READ_UNCOMMITTED  1
TRANSACTION_READ_COMMITTED  2
TRANSACTION_REPEATABLE_READ  4
TRANSACTION_SERIALIZABLE    8
2

---------------------------------------------------------------------------------------------------
mysql 5.0
true
TRANSACTION_READ_UNCOMMITTED  1
TRANSACTION_READ_COMMITTED  2
TRANSACTION_REPEATABLE_READ  4
TRANSACTION_SERIALIZABLE    8
2

---------------------------------------------------------------------------------------------------
oracle 10g
true
TRANSACTION_READ_COMMITTED  2
TRANSACTION_SERIALIZABLE    8
2