The only code changes related to that were with managed transactions. Which transacion manager are you using? (JDBC or MANAGED)?
Cheers, Clinton 2010/5/1 François Schiettecatte <fschietteca...@gmail.com>: > Hi > > I grabbed the latest, greatest release of 3.0 from : > > > http://people.apache.org/builds/ibatis/ibatis-3-core/ibatis-core-3.0-bundle.zip > > and am now getting an exception from time to time, but I was not getting it > with the previous 3.0 beta release (240). I was wondering if there had been > any change in the code which deals with connections and pool between those > two releases. What it looks like to me is that connections are not being > returned to the pool after I close the SqlSession. I have mysql set to > timeout idle connections after 60 seconds and the connection pool to time out > idle connections after 50 seconds. Again this was not an issue in 240. > > Any suggestions? > > Cheers > > François > > > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:38) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > com.poplar.sql.IBatis.selectObject(IBatis.java:554) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > com.poplar.db.dictionaries.Category.fromCategoryName(Category.java:118) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > com.poplar.db.items.ItemCategory.<init>(ItemCategory.java:201) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > com.poplar.db.items.ItemCategory.<init>(ItemCategory.java:227) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > com.poplar.db.items.Item.addItemCategory(Item.java:2182) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > com.poplar.crawler.processors.FeedProcessor.processEntryCategories(FeedProcessor.java:2494) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > com.poplar.crawler.processors.FeedProcessor.process(FeedProcessor.java:823) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > com.poplar.crawler.Worker.crawl(Worker.java:1313) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > com.poplar.crawler.Worker.crawlSourceKey(Worker.java:681) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > com.poplar.crawler.Worker.run(Worker.java:591) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > 2010-05-01 01:54:20,609 [pool-1-thread-1] ERROR com.poplar.crawler.Worker - > java.lang.Thread.run(Thread.java:619) > 2010-05-01 01:54:20,609 [pool-1-thread-1] WARN com.poplar.crawler.Worker - > Failed to crawl the source key: 'C01240E19154BE7BDA3703F726D5A68190D4A540', > exception: 'org.apache.ibatis.exceptions.IbatisException: > ### Error querying database. Cause: > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link > failure > > The last packet successfully received from the server was 104,024 > milliseconds ago. The last packet sent successfully to the server was 0 > milliseconds ago. > ### The error may involve > dictionaries.Category.selectObjectByCategoryName-Inline > ### The error occurred while setting parameters > ### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: > Communications link failure > > The last packet successfully received from the server was 104,024 > milliseconds ago. The last packet sent successfully to the server was 0 > milliseconds ago.'. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
