Actually in our - quite recent - case, it SEEMS to have been solved with various small optimisations and upgrades in the components' versions and either activating Spring's Transaction Manager (quite safe, some overhead added) or creating a custom SqlMapClientTemplate in place of Spring's one - a very simple one, that forwards the actions to ibatis (Spring does some weird things with the closing of connections)
Impressive performance boosts came when we also switched from apache dbcp to a well configured c3p0 data source. It's been 10 days the application is running fluently (except from some small peaks, but nothing fatal) 2008/2/5, manypoints <[EMAIL PROTECTED]>: > > > I did and seems like no one is saying its fixed. > > > https://issues.apache.org/jira/browse/IBATIS-249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12557974#action_12557974 > > But again other people are still seeing same issue. > > thanks > > > cmathrusse wrote: > > > > Did you search the archives? I found the following threads pertaining to > > your issue. > > > > http://www.mail-archive.com/[email protected]/msg10469.html > > > > > http://mail-archives.apache.org/mod_mbox/ibatis-dev/200704.mbox/[EMAIL > PROTECTED] > > > > > http://www.nabble.com/Re:-Ibatis-throttle---possible-deadlock-(ibatis-2.2,-2.3)-td14759064.html > > > > > > > > > > > > > > manypoints <[EMAIL PROTECTED]> > > 02/04/2008 03:45 PM > > Please respond to > > [email protected] > > > > > > To > > [email protected] > > cc > > > > Subject > > Re: spring-ibatis Object.wait error ? > > > > > > > > > > > > > > > > But i am seeing ibatis error some times..here is the error > > > > at java.lang.Object.wait(Native Method) > > at java.lang.Object.wait(Object.java:474) > > at > > com.ibatis.common.util.Throttle.increment(Throttle.java:69) > > - locked <800003ff65d79cf8> (a java.lang.Object) > > at > > com.ibatis.common.util.ThrottledPool.pop(ThrottledPool.java:60) > > at > > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.popSession( > SqlMapExecutorDelegate.java:910) > > at > > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.<init>( > SqlMapSessionImpl.java:50) > > at > > com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.getLocalSqlMapSession( > SqlMapClientImpl.java:214) > > at > > com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.openSession( > SqlMapClientImpl.java:173) > > at > > org.springframework.orm.ibatis.SqlMapClientTemplate.execute( > SqlMapClientTemplate.java:172) > > > > > > cmathrusse wrote: > >> > >> I think your exception shows you clearly that this is not an iBatis > > issue > >> but rather an Apache Commons DBCP issue. Review your documentation and > >> configuration of the connection pool. > >> > >> > >> > >> > >> > >> manypoints <[EMAIL PROTECTED]> > >> 02/04/2008 03:21 PM > >> Please respond to > >> [email protected] > >> > >> > >> To > >> [email protected] > >> cc > >> > >> Subject > >> spring-ibatis Object.wait error ? > >> > >> > >> > >> > >> > >> > >> > >> at java.lang.Object.wait(Native Method) > >> at java.lang.Object.wait(Object.java:474) > >> at > >> > > org.apache.commons.pool.impl.GenericObjectPool.borrowObject( > GenericObjectPool.java:748) > >> - locked (a > >> org.apache.commons.pool.impl.GenericObjectPool) > >> at > >> > > org.apache.commons.dbcp.PoolingDataSource.getConnection( > PoolingDataSource.java:95) > >> at > >> > > org.apache.commons.dbcp.BasicDataSource.getConnection( > BasicDataSource.java:540) > >> at > >> > > org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection( > DataSourceUtils.java:113) > >> at > >> > > org.springframework.jdbc.datasource.DataSourceUtils.getConnection( > DataSourceUtils.java:79) > >> at > >> > > org.springframework.orm.ibatis.SqlMapClientTemplate.execute( > SqlMapClientTemplate.java:182) > >> > >> Any help ? > >> -- > >> View this message in context: > >> > > > http://www.nabble.com/spring-ibatis-Object.wait-error---tp15280119p15280119.html > > > >> > >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >> > >> > >> > >> > >> > > > > -- > > View this message in context: > > > http://www.nabble.com/spring-ibatis-Object.wait-error---tp15280119p15280531.html > > > > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > > > > > > > > > > -- > View this message in context: > http://www.nabble.com/spring-ibatis-Object.wait-error---tp15280119p15280791.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > -- Gobelin Survivant du dev de www.650km.com http://recursive-cacophony.net/tec-goblin http://googoomucks.blogspot.com -------------------------------------------------------------------------- no creed on earth can replace or provide in my darkest hour, the comfort I'd feel leading me to see I can be more than I expect of me vnv nation
