I don't know it this would help, but I use the pooling classes of jakarta. Take a look at: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how to.html
It's an example under Tomcat. Regards, Miguel > -----Mensaje original----- > De: andres garcia [mailto:[EMAIL PROTECTED]] > Enviado el: lunes, 18 de noviembre de 2002 22:46 > Para: [EMAIL PROTECTED] > Asunto: MySQL connection pooling problems!! (please help) > > > 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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
