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]