Bugs item #484776, was opened at 2001-11-23 02:30 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=484776&group_id=22866
>Category: JBossCX Group: v2.4 (stable) Status: Open Resolution: None Priority: 5 Submitted By: Bani Greyling (banigreyling) Assigned to: David Jencks (d_jencks) Summary: Dead connection in Pool Initial Comment: Windows NT4 SP5 JDK 1.3 JBoss2.4.1a-Tomcat3.2.3 If a connection die in the pool and is later given out to participate in a transaction, it (obviously) give an exception. I think this is incorrect behaviour for the pool to assume the connection to be still valid after the transaction the connection was used in did not succeed. I configured my datasource with InvalidateOnError=true, but it does not seem to work. The dead connection stay in the pool. If my connections tend to die over time, I will end up with a pool of dead connections with no automated way of getting rid of them. IdleTimeout will not work, because the connection will not be idle as it is given out all the time (and cause exceptions). ---------------------------------------------------------------------- Comment By: David Jencks (d_jencks) Date: 2002-02-05 12:27 Message: Logged In: YES user_id=60525 I believe that the jdbc specs don't really discuss what to do with dead connections, however the jca specs do. Please try using the jca xa wrapper to see if that works properly. Note that this is pretty much untested code, since I don't have a XADataSource implementation to play with. (For various reasons, the "XADataSourceImpl" wrapper doesn't work very well pretending to be an XADatasource in the jca framework) ---------------------------------------------------------------------- Comment By: Bani Greyling (banigreyling) Date: 2001-11-28 02:46 Message: Logged In: YES user_id=302589 I investigated this further. As it turned out I was not using "org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl" but "com.jnetdirect.jsql.JSQLXADataSource" as my DataSourceClass. When using "org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl" any dead connection would be removed from the pool after participating in a (failed) transaction, so at least I would not end up with a bunch of dead connections. Maybe this is not a bug but rather an enhancement request;) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=484776&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development