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
