Spring事务管理JDBC连接详细日志

最新推荐文章于 2024-08-08 07:36:51 发布

yangsj19870829

最新推荐文章于 2024-08-08 07:36:51 发布

阅读量529

点赞数

CC 4.0 BY-SA版权

文章标签： Spring 事务

本文链接：https://blog.youkuaiyun.com/yangsj19870829/article/details/84418733

本文记录了在一个Spring框架的应用程序中，如何使用DataSourceTransactionManager进行数据库事务管理，并通过JdbcTemplate执行SQL查询与插入操作的过程。

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

Root WebApplicationContext: startup date [Sat Apr 13 19:29:05 CST 2013]; root of context hierarchy

727844 DEBUG [http-8080-1] org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'fooService'

727844 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager - Creating new transaction with name [x.y.service.FooService.getFoo]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly

727844 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager - Acquired Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] for JDBC transaction

727844 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceUtils - Setting JDBC Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] read-only

727844 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager - Switching JDBC Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] to manual commit

727844 DEBUG [http-8080-1] org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'dataSource'

727844 DEBUG [http-8080-1] org.springframework.jdbc.core.JdbcTemplate - Executing SQL query [select count(*) from emp]

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager - Initiating transaction commit

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager - Committing JDBC transaction on Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver]

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceUtils - Resetting read-only flag of JDBC Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver]

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager - Releasing JDBC Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] after transaction

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager - Creating new transaction with name [x.y.service.FooService.insertFoo]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager - Acquired Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] for JDBC transaction

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager - Switching JDBC Connection [jdbc:oracle:thin:@192.168.58.199:1521:orcl, UserName=SCOTT, Oracle JDBC driver] to manual commit

727937 DEBUG [http-8080-1] org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'dataSource'

727937 DEBUG [http-8080-1] org.springframework.jdbc.core.JdbcTemplate - Executing SQL statement [insert into emp values(1000, 'awp', 'CLERK', 8200, to_date('2013-04-13', 'yyyy-mm-dd'), 8000, 0, 10)]

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceTransactionManager - Initiating transaction commit

727937 DEBUG [http-8080-1] org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource