spring 事物日志

单条事物日志

   System.out.println("threadId==="+Thread.currentThread().getId());

return jdbcTemplate.queryForList(sql);

//创建事物2015-12-13 19:05:06 [ main:7232 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:366) Creating new transaction with name [com.zzm.spider.dao.impl.BasicDaoImpl2.queryForListMap]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '',-java.lang.Exception//获取数据库连接池并加入到线程上线文2015-12-13 19:05:08 [ main:9666 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:205) Acquired Connection  for JDBC transaction//2015-12-13 19:05:09 [ main:9714 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:222) Switching JDBC Connection  to manual committhreadId===12015-12-13 19:05:09 [ main:9729 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from website]threadId===12015-12-13 19:05:16 [ main:17141 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:753) Initiating transaction commit//提交事物2015-12-13 19:05:16 [ main:17157 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:265) Committing JDBC transaction on Connection //释放数据库连接池，从当前线程上下文中删除2015-12-13 19:05:16 [ main:17173 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCleanupAfterCompletion(DataSourceTransactionManager.java:323) Releasing JDBC Connection 2015-12-13 19:05:16 [ main:17173 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:328) Returning JDBC Connection to DataSource

 

   

for(int i=0;i<8;i++){//使用当前的 transactionserviceUtil.queryTasks();}System.out.println("threadId==="+Thread.currentThread().getId());return jdbcTemplate.queryForList(sql);

 

   

2015-12-13 19:10:50 [ main:9219 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:366) Creating new transaction with name [com.zzm.spider.dao.impl.BasicDaoImpl2.queryForListMap]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '',-java.lang.Exception2015-12-13 19:10:53 [ main:11856 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:205) Acquired Connection [, MySQL Connector Java] for JDBC transaction2015-12-13 19:10:53 [ main:11935 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:222) Switching JDBC Connection [, MySQL Connector Java] to manual commit2015-12-13 19:10:53 [ main:11951 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:10:53 [ main:11951 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:471) Participating in existing transaction2015-12-13 19:10:53 [ main:12185 ] - [ DEBUG ] org.crazycake.jdbcTemplateTool.utils.CatalogUtils.changeCatalog(CatalogUtils.java:34) real sql: select * from query_task where status = 02015-12-13 19:10:53 [ main:12185 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from query_task where status = 0]threadId===12015-12-13 19:11:02 [ main:20574 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:11:02 [ main:20574 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:471) Participating in existing transaction2015-12-13 19:11:02 [ main:20574 ] - [ DEBUG ] org.crazycake.jdbcTemplateTool.utils.CatalogUtils.changeCatalog(CatalogUtils.java:34) real sql: select * from query_task where status = 02015-12-13 19:11:02 [ main:20574 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from query_task where status = 0]threadId===12015-12-13 19:11:03 [ main:21729 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:11:03 [ main:21729 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:471) Participating in existing transaction2015-12-13 19:11:03 [ main:21729 ] - [ DEBUG ] org.crazycake.jdbcTemplateTool.utils.CatalogUtils.changeCatalog(CatalogUtils.java:34) real sql: select * from query_task where status = 02015-12-13 19:11:03 [ main:21729 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from query_task where status = 0]threadId===12015-12-13 19:11:04 [ main:22636 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:11:04 [ main:22636 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:471) Participating in existing transaction2015-12-13 19:11:04 [ main:22636 ] - [ DEBUG ] org.crazycake.jdbcTemplateTool.utils.CatalogUtils.changeCatalog(CatalogUtils.java:34) real sql: select * from query_task where status = 02015-12-13 19:11:04 [ main:22636 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from query_task where status = 0]threadId===12015-12-13 19:11:05 [ main:23466 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:11:05 [ main:23466 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:471) Participating in existing transaction2015-12-13 19:11:05 [ main:23466 ] - [ DEBUG ] org.crazycake.jdbcTemplateTool.utils.CatalogUtils.changeCatalog(CatalogUtils.java:34) real sql: select * from query_task where status = 02015-12-13 19:11:05 [ main:23466 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from query_task where status = 0]threadId===12015-12-13 19:11:05 [ main:24261 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:11:05 [ main:24261 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:471) Participating in existing transaction2015-12-13 19:11:05 [ main:24261 ] - [ DEBUG ] org.crazycake.jdbcTemplateTool.utils.CatalogUtils.changeCatalog(CatalogUtils.java:34) real sql: select * from query_task where status = 02015-12-13 19:11:05 [ main:24261 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from query_task where status = 0]threadId===12015-12-13 19:11:06 [ main:25208 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:11:06 [ main:25208 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:471) Participating in existing transaction2015-12-13 19:11:06 [ main:25208 ] - [ DEBUG ] org.crazycake.jdbcTemplateTool.utils.CatalogUtils.changeCatalog(CatalogUtils.java:34) real sql: select * from query_task where status = 02015-12-13 19:11:06 [ main:25208 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from query_task where status = 0]threadId===12015-12-13 19:11:07 [ main:26066 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:11:07 [ main:26066 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.handleExistingTransaction(AbstractPlatformTransactionManager.java:471) Participating in existing transaction2015-12-13 19:11:07 [ main:26066 ] - [ DEBUG ] org.crazycake.jdbcTemplateTool.utils.CatalogUtils.changeCatalog(CatalogUtils.java:34) real sql: select * from query_task where status = 02015-12-13 19:11:07 [ main:26066 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from query_task where status = 0]threadId===1threadId===12015-12-13 19:11:08 [ main:26941 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from website]threadId===12015-12-13 19:11:09 [ main:27956 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:753) Initiating transaction commit2015-12-13 19:11:09 [ main:27972 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:265) Committing JDBC transaction on Connection [, MySQL Connector Java]2015-12-13 19:11:09 [ main:28022 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCleanupAfterCompletion(DataSourceTransactionManager.java:323) Releasing JDBC Connection [, MySQL Connector Java] after transaction2015-12-13 19:11:09 [ main:28022 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:328) Returning JDBC Connection to DataSource

 

    

for(int i=0;i<4;i++){executorService.submit(new Callable<String>() {public String call() throws Exception {System.out.println("ThreadId==="+Thread.currentThread().getId());//Creating new transaction with name //同一个线程缓存的同一个connection //每一次Creating new transactionserviceUtil.queryTasks();return sql;};});}//Connection conn = DataSourceUtils.getConnection(jdbcTemplate.getDataSource());/*for(int i=0;i<8;i++){//使用当前的 transactionserviceUtil.queryTasks();}*/System.out.println("threadId==="+Thread.currentThread().getId());return jdbcTemplate.queryForList(sql);

 

  

2015-12-13 19:14:25 [ main:3880 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:14:25 [ main:3896 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:366) Creating new transaction with name [com.zzm.spider.dao.impl.BasicDaoImpl2.queryForListMap]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '',-java.lang.Exception2015-12-13 19:14:29 [ main:7517 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:205) Acquired Connection [, MySQL Connector Java] for JDBC transaction2015-12-13 19:14:29 [ main:7533 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:222) Switching JDBC Connection [, MySQL Connector Java] to manual committhreadId===1ThreadId===102015-12-13 19:14:29 [ pool-1-thread-1:7565 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:14:29 [ pool-1-thread-1:7565 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:366) Creating new transaction with name [com.zzm.spider.util.ServiceUtil.queryTasks]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '',-java.lang.Exception2015-12-13 19:14:29 [ main:7565 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from website]threadId===12015-12-13 19:14:29 [ pool-1-thread-1:7580 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:205) Acquired Connection [, MySQL Connector Java] for JDBC transaction2015-12-13 19:14:29 [ pool-1-thread-1:7596 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:222) Switching JDBC Connection [, MySQL Connector Java] to manual commit2015-12-13 19:14:29 [ main:7690 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:753) Initiating transaction commit2015-12-13 19:14:29 [ main:7690 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:265) Committing JDBC transaction on Connection [, MySQL Connector Java]2015-12-13 19:14:29 [ pool-1-thread-1:7736 ] - [ DEBUG ] org.crazycake.jdbcTemplateTool.utils.CatalogUtils.changeCatalog(CatalogUtils.java:34) real sql: select * from query_task where status = 02015-12-13 19:14:29 [ pool-1-thread-1:7736 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from query_task where status = 0]threadId===102015-12-13 19:14:29 [ main:7736 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCleanupAfterCompletion(DataSourceTransactionManager.java:323) Releasing JDBC Connection [, MySQL Connector Java] after transaction2015-12-13 19:14:29 [ main:7736 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:328) Returning JDBC Connection to DataSource{id=1, fid=1, site_name=新浪微博, login_url=https://login.sina.com.cn/signup/signin.php?entry=homepage, post_url=null, login_userame_xpath=//input[@name='username'], login_userpassword_xpath=//input[@name='password'], login_loginsubmit_xpath=//input[@class='btn_submit_m'], login_verifcode_xpath=//img[@id='check_img'], login_verifcodeinput_xpath=//input[@id='door'], post_verifcode_xpath=null, postcontent_xpath=null, posttitle_xpath=null, postbutton_xpath=null, loginsuccess_code=http://club.history.sina.com.cn/my.php, postcontent_div_xpath=null, replytitle_xpath=null, replycontent_xpath=null, reply_button=null, postcontent_iframe_xpath=null, replycontent_iframe_xpath=null, replycontent_div_xpath=null, login_check=1, post_verifcode_button=null, post_verifcodeinput_xpath=null, reply_verifcode_xpath=null, reply_verifcodeinput_xpath=null, reply_verifcode_button=null, post_confirm_button=null, rfid=null, post_class=null, update_time=null, type=4, create_time=null, status=true}2015-12-13 19:14:29 [ pool-1-thread-1:7768 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:753) Initiating transaction commit2015-12-13 19:14:29 [ pool-1-thread-1:7783 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:265) Committing JDBC transaction on Connection [, MySQL Connector Java]2015-12-13 19:14:29 [ pool-1-thread-1:7830 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCleanupAfterCompletion(DataSourceTransactionManager.java:323) Releasing JDBC Connection [, MySQL Connector Java] after transaction2015-12-13 19:14:29 [ pool-1-thread-1:7830 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:328) Returning JDBC Connection to DataSourceThreadId===102015-12-13 19:14:29 [ pool-1-thread-1:7830 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:14:29 [ pool-1-thread-1:7830 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:366) Creating new transaction with name [com.zzm.spider.util.ServiceUtil.queryTasks]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '',-java.lang.Exception2015-12-13 19:14:29 [ pool-1-thread-1:7830 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:205) Acquired Connection [, MySQL Connector Java] for JDBC transaction2015-12-13 19:14:29 [ pool-1-thread-1:7846 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:222) Switching JDBC Connection [, MySQL Connector Java] to manual commit2015-12-13 19:14:29 [ pool-1-thread-1:7877 ] - [ DEBUG ] org.crazycake.jdbcTemplateTool.utils.CatalogUtils.changeCatalog(CatalogUtils.java:34) real sql: select * from query_task where status = 02015-12-13 19:14:29 [ pool-1-thread-1:7877 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from query_task where status = 0]threadId===102015-12-13 19:14:29 [ pool-1-thread-1:7970 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:753) Initiating transaction commit2015-12-13 19:14:29 [ pool-1-thread-1:7986 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:265) Committing JDBC transaction on Connection [, MySQL Connector Java]2015-12-13 19:14:29 [ pool-1-thread-1:8048 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCleanupAfterCompletion(DataSourceTransactionManager.java:323) Releasing JDBC Connection [, MySQL Connector Java] after transaction2015-12-13 19:14:29 [ pool-1-thread-1:8048 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:328) Returning JDBC Connection to DataSourceThreadId===102015-12-13 19:14:29 [ pool-1-thread-1:8048 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:14:29 [ pool-1-thread-1:8048 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:366) Creating new transaction with name [com.zzm.spider.util.ServiceUtil.queryTasks]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '',-java.lang.Exception2015-12-13 19:14:29 [ pool-1-thread-1:8064 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:205) Acquired Connection [, MySQL Connector Java] for JDBC transaction2015-12-13 19:14:29 [ pool-1-thread-1:8064 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:222) Switching JDBC Connection [, MySQL Connector Java] to manual commit2015-12-13 19:14:29 [ pool-1-thread-1:8095 ] - [ DEBUG ] org.crazycake.jdbcTemplateTool.utils.CatalogUtils.changeCatalog(CatalogUtils.java:34) real sql: select * from query_task where status = 02015-12-13 19:14:29 [ pool-1-thread-1:8095 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from query_task where status = 0]threadId===102015-12-13 19:14:29 [ pool-1-thread-1:8111 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:753) Initiating transaction commit2015-12-13 19:14:29 [ pool-1-thread-1:8126 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:265) Committing JDBC transaction on Connection [, MySQL Connector Java]2015-12-13 19:14:29 [ pool-1-thread-1:8204 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCleanupAfterCompletion(DataSourceTransactionManager.java:323) Releasing JDBC Connection [, MySQL Connector Java] after transaction2015-12-13 19:14:29 [ pool-1-thread-1:8204 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:328) Returning JDBC Connection to DataSourceThreadId===102015-12-13 19:14:29 [ pool-1-thread-1:8204 ] - [ DEBUG ] org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246) Returning cached instance of singleton bean 'transactionManager'2015-12-13 19:14:29 [ pool-1-thread-1:8204 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:366) Creating new transaction with name [com.zzm.spider.util.ServiceUtil.queryTasks]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '',-java.lang.Exception2015-12-13 19:14:29 [ pool-1-thread-1:8220 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:205) Acquired Connection [, MySQL Connector Java] for JDBC transaction2015-12-13 19:14:30 [ pool-1-thread-1:8236 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:222) Switching JDBC Connection [, MySQL Connector Java] to manual commit2015-12-13 19:14:30 [ pool-1-thread-1:8251 ] - [ DEBUG ] org.crazycake.jdbcTemplateTool.utils.CatalogUtils.changeCatalog(CatalogUtils.java:34) real sql: select * from query_task where status = 02015-12-13 19:14:30 [ pool-1-thread-1:8251 ] - [ DEBUG ] org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:435) Executing SQL query [select * from query_task where status = 0]threadId===102015-12-13 19:14:30 [ pool-1-thread-1:8282 ] - [ DEBUG ] org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:753) Initiating transaction commit2015-12-13 19:14:30 [ pool-1-thread-1:8282 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:265) Committing JDBC transaction on Connection [, MySQL Connector Java]2015-12-13 19:14:30 [ pool-1-thread-1:8345 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceTransactionManager.doCleanupAfterCompletion(DataSourceTransactionManager.java:323) Releasing JDBC Connection [, MySQL Connector Java] after transaction2015-12-13 19:14:30 [ pool-1-thread-1:8345 ] - [ DEBUG ] org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:328) Returning JDBC Connection to DataSource