I am using mySQL with tomcat and JSP without any problem. Hearing about your symptoms, I would guess that your connections need to be refreshed from time to time (after a certain time an unactive connection will be dropped which explain why you have to restart tomcat)
You should use a connectionPoolManager. I personally use the one from bitmechanic and I am so far happy with it http://www.bitmechanic.com/projects/jdbcpool/ Regards, Benoit -----Original Message----- From: aravind gorthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 8:19 AM To: [EMAIL PROTECTED] Subject: MySQL with TOMCAT and JSP giving problems.. 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 Aravind Gorthy, VisualSoft Technolgies, Hyderabad-India. _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
