Bugs item #664547, was opened at 2003-01-08 13:51 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=664547&group_id=22866
Category: JBossServer Group: v2.4 (stable) Status: Open Resolution: None Priority: 5 Submitted By: Kyle VanderBeek (kylev) Assigned to: Nobody/Anonymous (nobody) Summary: JDBC pooling completely broken Initial Comment: Crate a simple JDBC data source in jboss.jcml (we're currently on 2.4.8): <mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider"> <attribute name="Drivers">com.sybase.jdbc2.jdbc.SybDriver,com.mysql.jdbc.Driver</attribute> </mbean> <mbean code="org.jboss.jdbc.JDBCDataSourceLoader" name="DefaultDomain:service=JDBCDataSource,name=CartDS"> <attribute name="PoolName">CartDS</attribute> <attribute name="URL">jdbc:mysql://db2.server.dom/cart?autoReconnect=true</attribute> <attribute name="JDBCUser">user</attribute> <attribute name="Password">pass</attribute> <attribute name="MaxSize">16</attribute> </mbean> This pool is completely un-usable and will be quickly exhausted with any simple code: for (int i = 0; i < someNum; i++) { Connection con = ds.getConnection(); con.close(); } If you turn on tracing for "org.jboss.pool", you'll see that the end of ObjectPool.releaseObject() is *never* reached. ---------------------------------------------------------------------- >Comment By: Bill Burke (patriot1burke) Date: 2003-01-08 18:14 Message: Logged In: YES user_id=176497 Use XADataSourceLoader. Its being used in many many production sites around the world. In fact, if you want transactions with your ejbs, you can't use a plain JDBC loader. Don't count on this getting fixed anytime soon. 2.4.x series development is basically retired except for paying support customers. ---------------------------------------------------------------------- Comment By: Kyle VanderBeek (kylev) Date: 2003-01-08 17:38 Message: Logged In: YES user_id=51762 (Forgot to actually attach patch) ---------------------------------------------------------------------- Comment By: Kyle VanderBeek (kylev) Date: 2003-01-08 17:38 Message: Logged In: YES user_id=51762 Proposed patch (by my co-worker Blaise). This alone is almost worth rolling a new release (IMHO). An EJB server that can't reliably use a DataSource isn't worth much. ---------------------------------------------------------------------- Comment By: Kyle VanderBeek (kylev) Date: 2003-01-08 13:59 Message: Logged In: YES user_id=51762 A quick glance by my co-worker found that the calls in ObjectPool.releaseObject() may be the problem: factory.returnObject(object);//do this first pooled = factory.translateObject(object); Looking at the JDBCConnectionFactory, pooled will ALWAYS be null after these calls, because JDBCConnectionFactory.returnObject() calls ConnectionInPool.reset() which sets the underlying connection to null. Something here is incorrect, though I'm not sure yet what the expected semmantics are. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=664547&group_id=22866 ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development