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(RequestProcessor.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#a12843354 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]
Re: tomcat can not connect to MySql
also i have to say that i use hibernate 3 to connect to Mysql thanks for your attention -- Fatemeh fdehghani wrote: 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(RequestProcessor.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#a12845323 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]
tomcat can not connect to MySql
I ues Appache tomcat as my App Server in my project but when running its service, after sometime when run my project,tomcat say that can not connect to database(SystemException) then i should restart its service to work correctly. i'm not sure thet its tomcat's problem or MySql please help me. -- View this message in context: http://www.nabble.com/tomcat-can-not-connect-to-MySql-tf4500426.html#a12834957 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]
