Druid的事务和连接

最新推荐文章于 2023-02-21 09:56:54 发布

JAVA道人

最新推荐文章于 2023-02-21 09:56:54 发布

阅读量2.4k

点赞数 1

分类专栏： # JDBC

本文链接：https://blog.csdn.net/dmw412724/article/details/103226306

版权

JDBC 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

事务方法里，所有的连接都是同一个连接，直到最后会提交。

非事务方法里，每一个连接都重新获取，每次jdbc都自动提交。

这块的核心方法在org.springframework.jdbc.datasource.DataSourceUtils里。如下：

ublic static Connection doGetConnection(DataSource dataSource) throws SQLException {
		Assert.notNull(dataSource, "No DataSource specified");

		ConnectionHolder conHolder = (ConnectionHolder) TransactionSynchronizationManager.getResource(dataSource);
		if (conHolder != null && (conHolder.hasConnection() || conHolder.isSynchronizedWithTransaction())) {
			conHolder.requested();
			if (!conHolder.hasConnection()) {
				logger.debug("Fetching resumed JDBC Connection from DataSource");
				conHolder.setConnection(fetchConnection(dataSource));
			}
			return conHolder.getConnection();
		}
		// Else we either got no holder or an empty thread-bound holder here.

		logger.debug("Fetching JDBC Connection from DataSource");
		Connection con = fetchConnection(dataSource);

		if (TransactionSynchronizationManager.isSynchronizationActive()) {
			try {
				// Use same Connection for further JDBC actions within the transaction.
				// Thread-bound object will get removed by synchronization at transaction completion.
				ConnectionHolder holderToUse = conHolder;
				if (holderToUse == null) {
					holderToUse = new ConnectionHolder(con);
				}
				else {
					holderToUse.setConnection(con);
				}
				holderToUse.requested();
				TransactionSynchronizationManager.registerSynchronization(
						new ConnectionSynchronization(holderToUse, dataSource));
				holderToUse.setSynchronizedWithTransaction(true);
				if (holderToUse != conHolder) {
					TransactionSynchronizationManager.bindResource(dataSource, holderToUse);
				}
			}
			catch (RuntimeException ex) {
				// Unexpected exception from external delegation call -> close Connection and rethrow.
				releaseConnection(con, dataSource);
				throw ex;
			}
		}

		return con;
	}

该方法做了以下事情：

1、如果当前请求处在事务中，那么把唯一事务连接取出来。如果还没有创建，执行第二条

2、重新获取一条连接

3、如果当前请求处在事务中，把这条连接作为唯一事务连接，并锁住该连接，不让其他获取到