I can say, this is purely a connection closing problem. That's the reason when you restart the tomcat it works fine till the time all the connection in the connection pool utilize and then after it hangs.
Are u closing your connection in finally block? -Jignesh On Mon, 2004-08-16 at 02:14, Rajesh wrote: > Hai guys > > am still fasing same problem with my struts,tomcat with mysql. > > am working in the environment of tomcat,struts,dbcp,JP2, mysql.. > > i developed a site of round 20-50 actions which accesses db through DBCP > to MySQL > > i completely debugged my site theroughly, there is no but in my code. > > i uploaded the site to net, after a using the site successfully suddenly > my connections is not working . > > i found this by my index page where i am using 2 message board which > takes top 5 records from db and displays it in text scrolling javascript > > where ever am connection to mysql through getDataSource(request) am not > gettign connection properly. > > i am properly closing connection in my program > > but when i restart my tomcat then my program start working properlty > then after a day or so the same problem arrice. > > can anybody help me to overcome this. > > am fasing the same problem for many days. > > thanks you > Rajesh > > --------------------------------------------------------------------- > 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]
