MySQL connection pooling problems!! (please help)

[andres garcia]

Hi.
I'm new to struts, and i have find it great, until connection poolling. I'm using the GenericDataSurce implementation and my aplicattion uses a singleton to access de connection. All the code was in a Wrox book (Beginning jsp).
I'm having this problem:
I have a action servlet that query the database using a connection of the pool. The first times the connection is recicled, but after some requests, the pool creates a new connection and the first one is lost. I'm sure that the action servlet is closing the connections because i'm logging this (the file seems ok: open - close - open -close). With more request to the action all the connections are used and i can`t connect any more to the database. I'm the only client (the server is my pc)!!. What is going on? What is the problem?
Is a bug of the GenericDataSource? (if i should use other pool, please recommend me one easy to install)

Other question: The connection pooling must be supported by the driver or is independant? (i'm using the mm.mysql driver latest release)

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es


--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>