Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL with TOMCAT and JSP giving problems..

 
Apirak Panatkool
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you! Thank you! so much
You save my life...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic