Hi,
I am developing a webapp using Struts, Tomcat, JSP, Servlets and MySQL.
I am using BasicDataSource for JDBC connection pooling needs. I have a
question regarding returning the connections back to the pool.
Whenever I get a connection using
Connection conn = ds.getConnection();
I make sure that in the finally{} or any other appropriate place I
close the connection using
if(conn!=null) conn.close();
I am wondering if conn.close() is indeed returing the Connection back
to pool or not. Does it? When I checked the source code it seems it
does. But after getting and closing the connections 8 times the nineth
getConnection() call just goes in an endless loop.
>From the docs and sources I can see that if I hit the MaxActive()
count the next call to getConnection() will wait till an object is
returned to the pool. But in my case I make sure that I return the
objects back to the pool each time I get them. So why is it going in
wait() ?
Please tell me what could be going wrong?
Regards
Sanjeet
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
