MySQL with TOMCAT and JSP giving problems..

[Apirak Panatkool]

Hai,
I am using MySQL with TOMCAT and JSP for development
purpose.
1. Every morning without restarting the tomcat
server, i am unable to connect the MySql Database.
What might be the problem..
I did't get this type of problem in Oracle & SQL server.
2. While Running Tomcat Server , I Loose Database
Connection
To get Connection from database server, i am
restarting tomcat server each time, Is MySQL Behaves
same with all Servers ???]
Does any one in the list face this type of Problem.
Thanks in advance
ps. MySQL still run.

[Nagurva Reddy]

Hi,
This is because of MySQL driver. Change your URL
from
jdbc:mysql://127.0.0.1/database
to
jdbc:mysql://127.0.0.1/database?autoReconnect=true
As per my knowledge it will solve your problem.

Nagurva


[ June 26, 2002: Message edited by: Nagurva Reddy ]

[Apirak Panatkool]

Thank you! Thank you! so much
You save my life...