I am using JDBC, with C3P0 as my data source. Cheers François
On May 1, 2010, at 4:14 PM, Clinton Begin wrote: > 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 > --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
