Bugs item #664547, was opened at 2003-01-08 10: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: Kyle VanderBeek (kylev)
Date: 2003-01-08 10: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

Reply via email to