Hello all. I'm new to the forum and excited to be here.
I have a project written in
struts with
jsp pages and
servlets. I access a mysql database that is on the same server as the code which is running on
Tomcat 5.0. I am using a datasource for the mysql database in the code. I have this strange issue. If no one logs into the website for a awhile, when you try to login, the site just hangs and it doesn't make the connection to the database. However if you then press the login button again, which will re-create the datasource connection, it works perfectly and connects, logs in, etc... Then any attempts to login to my application will work fine for a certain period of time (seems to be at leaast 30 minutes, might be quite a lot longer), even in a brand new browser session.
So it seems like after a certain period of time the datasource dies in some way, but then once I "wake it up", after the first failure, it will work again.
Anyone have any ideas?
I can't access my server log till Tuesday to see if there are any hints, but I wanted to get this question out there to see if it sounds familiar. Thanks for any help
