RE: DBCP + Tomcat Issues?
Hi, It IS a shot in the dark when you give that little context. What's the stack trace of the SQL exception? Yoav Shapira Millennium Research Informatics -Original Message- From: Rahman Syed [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 2:35 PM To: [EMAIL PROTECTED] Subject: DBCP + Tomcat Issues? Hello, I realize this may not be the best place to ask but I'll give it a shot. I'm using DBCP in a Struts application to make requests to MySQL DB and simply return results for Select queries. The application works fine for a while then for some reason stops; it throws SQLExceptions whenever I try to create a Statement. If I restart Tomcat, things are fine again. Might be a shot in the dark to ask here, but does anyone have any idea? Thanks in advance. Rahman - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: DBCP + Tomcat Issues?
What are the sql exceptions? Looks like the connections arent beeing released in the connection pool. Eventually they all are beeing used. Rahman Syed wrote: Hello, I realize this may not be the best place to ask but I'll give it a shot. I'm using DBCP in a Struts application to make requests to MySQL DB and simply return results for Select queries. The application works fine for a while then for some reason stops; it throws SQLExceptions whenever I try to create a Statement. If I restart Tomcat, things are fine again. Might be a shot in the dark to ask here, but does anyone have any idea? Thanks in advance. Rahman - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: DBCP + Tomcat Issues?
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations Look at the link. Make sure you are closing the connections. Anastasios Angelidis wrote: What are the sql exceptions? Looks like the connections arent beeing released in the connection pool. Eventually they all are beeing used. Rahman Syed wrote: Hello, I realize this may not be the best place to ask but I'll give it a shot. I'm using DBCP in a Struts application to make requests to MySQL DB and simply return results for Select queries. The application works fine for a while then for some reason stops; it throws SQLExceptions whenever I try to create a Statement. If I restart Tomcat, things are fine again. Might be a shot in the dark to ask here, but does anyone have any idea? Thanks in advance. Rahman - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]