在使用SPRINGMVC和MYBATIS框架的项目中，遇到事务不起作用的问题，详细记录了问题现象、排查过程及解决方案。
21:31:01 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@1b05a17 [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1addd4d)
2015/11/04 21:31:01 DEBUG BasicResourcePool:422 - decremented pending_acquires: 2
2015/11/04 21:31:01 DEBUG SpringManagedTransaction:49 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1a98b79] [color=red]will not be managed by Spring[/color]
2015/11/04 21:31:01 DEBUG add:49 - ==> Preparing: insert into g_bbs_goods_review (id, goods_id, content, user_id, gmt_create, is_deleted, gmt_modify,goods_name,is_shop,parent_id) values (?, ?, ?, ?, now(),'n', now(),?,?,?)
2015/11/04 21:31:01 DEBUG add:49 - ==> Parameters: null, 520(Integer), 好评b！(String), 250(Integer), null, null, 0(Integer)
2015/11/04 21:31:01 DEBUG add:49 - <== Updates: 1
2015/11/04 21:31:01 DEBUG SqlSessionUtils:49 - [color=red]Closing non transactional SqlSession[/color] [org.apache.ibatis.session.defaults.DefaultSqlSession@251a84]
2015/11/04 21:31:01 DEBUG DataSourceUtils:332 - Returning JDBC Connection to DataSource
2015/11/04 21:31:01 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@1b05a17 [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1addd4d)
2015/11/04 21:31:03 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@1eeafb0.acquireResource() returning.
2015/11/04 21:31:03 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@1b05a17 [managed: 2, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1addd4d)
2015/11/04 21:31:03 DEBUG BasicResourcePool:422 - decremented pending_acquires: 1
2015/11/04 21:31:03 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@1eeafb0.acquireResource() returning.
2015/11/04 21:31:03 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@1b05a17 [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1addd4d)
2015/11/04 21:31:03 DEBUG BasicResourcePool:422 - decremented pending_acquires: 0
spingmvc+mybatis项目，事务不起作用、切面和扫包都已经检查过了，已经搞了几天了都没能解决，希望哪位大神能帮忙看下，谢了！！！
2015/11/04 21:31:01 DEBUG BasicResourcePool:422 - decremented pending_acquires: 2
2015/11/04 21:31:01 DEBUG SpringManagedTransaction:49 - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@1a98b79] [color=red]will not be managed by Spring[/color]
2015/11/04 21:31:01 DEBUG add:49 - ==> Preparing: insert into g_bbs_goods_review (id, goods_id, content, user_id, gmt_create, is_deleted, gmt_modify,goods_name,is_shop,parent_id) values (?, ?, ?, ?, now(),'n', now(),?,?,?)
2015/11/04 21:31:01 DEBUG add:49 - ==> Parameters: null, 520(Integer), 好评b！(String), 250(Integer), null, null, 0(Integer)
2015/11/04 21:31:01 DEBUG add:49 - <== Updates: 1
2015/11/04 21:31:01 DEBUG SqlSessionUtils:49 - [color=red]Closing non transactional SqlSession[/color] [org.apache.ibatis.session.defaults.DefaultSqlSession@251a84]
2015/11/04 21:31:01 DEBUG DataSourceUtils:332 - Returning JDBC Connection to DataSource
2015/11/04 21:31:01 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@1b05a17 [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1addd4d)
2015/11/04 21:31:03 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@1eeafb0.acquireResource() returning.
2015/11/04 21:31:03 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@1b05a17 [managed: 2, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1addd4d)
2015/11/04 21:31:03 DEBUG BasicResourcePool:422 - decremented pending_acquires: 1
2015/11/04 21:31:03 DEBUG C3P0PooledConnectionPool:217 - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@1eeafb0.acquireResource() returning.
2015/11/04 21:31:03 DEBUG BasicResourcePool:1644 - trace com.mchange.v2.resourcepool.BasicResourcePool@1b05a17 [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1addd4d)
2015/11/04 21:31:03 DEBUG BasicResourcePool:422 - decremented pending_acquires: 0
spingmvc+mybatis项目，事务不起作用、切面和扫包都已经检查过了，已经搞了几天了都没能解决，希望哪位大神能帮忙看下，谢了！！！
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
