tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mgai...@hotmail.com
Subject Re: tomcat can not connect to MySql
Date Sat, 23 Sep 2000 13:00:54 GMT
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 -u@SERVER 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: 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#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: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>


---------------------------------------------------------------------
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