wood burning stoves 2.0*
The moose likes JSP and the fly likes MySQL with TOMCAT and JSP giving problems.. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "MySQL with TOMCAT and JSP giving problems.. " Watch "MySQL with TOMCAT and JSP giving problems.. " New topic
Author

MySQL with TOMCAT and JSP giving problems..

Apirak Panatkool
Greenhorn

Joined: Apr 30, 2002
Posts: 15
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.


bAnk
Nagurva Reddy
Greenhorn

Joined: Jun 24, 2002
Posts: 4
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
Greenhorn

Joined: Apr 30, 2002
Posts: 15
Thank you! Thank you! so much
You save my life...
 
 
subject: MySQL with TOMCAT and JSP giving problems..
 
Similar Threads
Communications link failure Last packet sent to the server was 0 ms ago
hibernate_struts_tomcat
MySql Password error
Running out of database connections using JSP
forum miss topics