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
