did you check the listener to make sure the MySQL listener is actually listening? netstat -a | grep 3306
if you run your mysql client with the same parameters that your webpp is using mysql [EMAIL PROTECTED] Username -p password DBName can you connect? M-- ----- Original Message ----- Wrom: XRQBGJSNBOHMKHJYFMYXOEAIJJPHSCRTNHGSWZID To: <users@tomcat.apache.org> Sent: Sunday, September 23, 2007 3:08 AM Subject: Re: tomcat can not connect to MySql > > Tomcat 5.5.9 > OS Windows Server 2003 , Windows XP > Mysql 5.0 > tomcat and mysql on the same server > > javax.transaction.SystemException > com.met.data.factory.user.UserFactory.getUser(UserFactory.java:694) > com.met.action.LoginAction.execute(LoginAction.java:56) > > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces sor.java:419) > > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224) > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194) > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) > javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > com.met.filter.CharsetFilter.doFilter(CharsetFilter.java:31) > > any connection closed after open it > > -- Fatemeh > > > David Smith-2 wrote: > > > > Can you provide some specifics of your environment? > > > > Tomcat version > > OS > > Mysql version (both driver and server) > > Both tomcat and mysql on the same machine? > > If not, any firewalls that might be timing out a connection? > > How long does it run before it doesn't work? > > Can you post the full stack trace of your exception including root cause? > > In your design, are you holding on to connections or closing them as > > soon as you are done talking to the db? > > > > Mysql server does timeout connections after 8 hours by default. If you > > are using tomcat's database pooling, this can be fixed with the simple > > addition of a validation query in the config. In any case, it's best > > practice for the code querying the db to close connections as soon as > > reasonably possible and not keep them open. > > > > --David > > > > --------------------------------------------------------------------- > > To start a new topic, e-mail: users@tomcat.apache.org > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > -- > View this message in context: http://www.nabble.com/tomcat-can-not-connect-to-MySql-tf4500426.html#a128433 54 > Sent from the Tomcat - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
