事务方法日志:
reating new transaction with name ]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,-Exception
Acquired Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@1ff05076] for JDBC transaction
Switching JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@1ff05076] to manual commit
db操作
db操作
db操作
db操作
Initiating transaction commit
Committing JDBC transaction on Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@1ff05076]
Releasing JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@1ff05076] after transaction
Returning JDBC Connection to DataSource
非事务方法日志:
Fetching JDBC Connection from DataSource
JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@106f5913] will not be managed by Spring
Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@106f5913]
Preparing: sql..........................
Parameters: 9855153(Long), 9157285(Long), 9665893(Long), 31031419(Long), 30292757(Long), 9157263(Long), 9856389(Long), 31191611(Long), 31192781(Long)
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@58254e5a]
Returning JDBC Connection to DataSource
mybatis 有事务:
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@27daa766]
SpringManagedTransaction:85 - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@106f5913] will be managed by Spring
Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@106f5913]
Preparing:sql
Parameters: 0(Integer), 1(Integer), 2(Integer), 237(Long), 883(Long), 236(Long), 235(Long), 233(Long), 719(Long), 231(Long), 229(Long), 227(Long), 223(Long), 907(Long), 697(Long), 417(Long), 419(Long), 0(Integer), 18(Integer)
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@27daa766] from current transaction
Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@106f5913]
Preparing: sql
Parameters: 0(Integer), 1(Integer), 2(Integer), 237(Long), 883(Long), 236(Long), 235(Long), 233(Long), 719(Long), 231(Long), 229(Long), 227(Long), 223(Long), 907(Long), 697(Long), 417(Long), 419(Long), 0(Integer), 18(Integer)
SqlSessionUtils:165 - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@27daa766]
Participating in existing transaction
Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@27daa766] from current transaction
Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@106f5913]
Preparing:sql
Parameters: 442(Long), 213715(Long), 208649(Long), 213707(Long), 212137(Long), 213699(Long), 211365(Long), 212799(Long), 211367(Long), 212745(Long), 212385(Long), 210029(Long), 208623(Long), 5231(Long), 208635(Long), 18915(Long), 11307(Long), 5643(Long), 16699(Long)
SqlSessionUtils:165 - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@27daa766]
SqlSessionUtils:170 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@741ab9e]
DataSourceUtils:327 - Returning JDBC Connection to DataSource