tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fdehghani <dehghani_fate...@yahoo.com>
Subject Re: tomcat can not connect to MySql
Date Sun, 23 Sep 2007 11:01:42 GMT

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: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>> 
>> 
>> 
> 
> 

-- 
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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message