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

最新推荐文章于 2025-04-09 08:27:16 发布

iteye_1364

最新推荐文章于 2025-04-09 08:27:16 发布

阅读量261

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： JDBC MySQL Oracle .net

本文链接：https://blog.youkuaiyun.com/iteye_1364/article/details/82006304

数据库专栏收录该内容

19 篇文章

订阅专栏

本文提供了一段Java代码示例，用于通过JDBC查询不同数据库（如SQL Server 2000、MySQL 5.0及Oracle 10g）的事务隔离级别支持情况及其默认设置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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