> -----Original Message----- > From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 10, 2004 1:29 PM > To: Struts Users Mailing List > Subject: RE: java.net.ConnectException: Connection refused > > > No there is no firewall on Linux box.
Okay I'm going to down a mental list you've probably already checked, and I'm assuming a moderate level of linux understanding..... networking on the linux box is up and running? mysql is up and running? netstat --listen shows the 3306 port for mysql open and listening? Can you get the mysql admin tools to connect from commandline? If all of these are yes, I'll have to wait until I get home to post my config... unless anyone can post theirs.... > > -----Original Message----- > From: Jim Barrows [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 10, 2004 4:24 PM > To: Struts Users Mailing List > Subject: RE: java.net.ConnectException: Connection refused > > > > > > -----Original Message----- > > From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, August 10, 2004 1:13 PM > > To: Struts Users Mailing List > > Subject: RE: java.net.ConnectException: Connection refused > > > > > > Hi Jim, > > I have tried all different options for the jdbc url, but > > everything leads to > > same error, > > :java.net.ConnectException: Connection refused -- i tried to > > get connection > > from > > DriverManager.getConnection() instead from datasource and > > even that doen't > > work. > > I was able to use the same configuration on my desktop, so > > its something to > > do with the linux environment. > > I am not able to figure it out, can you send me guildelines > > on how u were > > able to make it work, whenever u got time. > > i am using mysql4.0, Tomcat 4.0, and struts1.1. > > > Does your linux box have a firewall? If so, is it blocking the port? > > > > > > > > > -----Original Message----- > > From: Jim Barrows [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, August 10, 2004 1:17 PM > > To: Struts Users Mailing List > > Subject: RE: java.net.ConnectException: Connection refused > > > > > > > > > > > -----Original Message----- > > > From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, August 10, 2004 10:10 AM > > > To: Struts Users Mailing List > > > Subject: RE: java.net.ConnectException: Connection refused > > > > > > > > > > > > This is a well known problem regarding MySQL and Linux. One > > > of two has a > > > screwy implementation of resolving host names. WHich one > > > depends on who you > > > talk to. > > > > > > Known solutions include using 127.0.0.1. You will also have > > > issues with > > > authenticating to the server if you limit mysql logins by server. > > > > > > I have tried 127.0.0.1, but even this does not work gives > > > same error, can > > > you think of any other solution... > > > > > > Unfortunately I'm not at home, which is where my MySQL > > implementation is, so > > I can't show you what I'm doing for another 7-8 hours :( > > > > On the other hand the MySQL folk have some great > > documentation and help > > forums that could probably help you more, if no one else has > > any solutions > > for you here. > > > > > > > > > > > > > Also changed driver class name to com.mysql.jdbc.Driver, > didn't work > > > > > > <parameter> > > > > <name>url</name> > > > > <value>jdbc:mysql://127.0.0.1:3306/prototypedb?autoReconnect=t > > > > rue</value> > > > > </parameter> > > > > <!-- Class name for mm.mysql JDBC driver --> > > > > <parameter> > > > > <name>driverClassName</name> > > > > <value>org.gjt.mm.mysql.Driver</value> > > > > </parameter> > > > > > > > > > -----Original Message----- > > > From: Jim Barrows [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, August 10, 2004 12:26 PM > > > To: Struts Users Mailing List > > > Subject: RE: java.net.ConnectException: Connection refused > > > > > > > > > > -----Original Message----- > > > > From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] > > > > Sent: Tuesday, August 10, 2004 9:17 AM > > > > Cc: Struts Users Mailing List > > > > Subject: RE: java.net.ConnectException: Connection refused > > > > > > > > > > > > > > > > I am using Tomcat4.0, struts1.1, mysql 4.0.18 , on Linux > > > > environment. And i > > > > am unable > > > > to connect to mysql db. Below is the url > > > > i am using in server.xml file. and also i have the jdbc > > driver under > > > > WEB-INF/lib - > > mysql-connector-java-3.0.14-production-bin.jar...I was > > > > successfully able to deploy the same application on Windows, > > > > using the same > > > > server.xml file. please help. > > > > > > > > > This is a well known problem regarding MySQL and Linux. One > > > of two has a > > > screwy implementation of resolving host names. WHich one > > > depends on who you > > > talk to. > > > > > > Known solutions include using 127.0.0.1. You will also have > > > issues with > > > authenticating to the server if you limit mysql logins by server. > > > > > > > > > > > > > > > > > <parameter> > > > > <name>factory</name> > > > > > > > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > > > > </parameter> > > > > <parameter> > > > > <name>url</name> > > > > <value>jdbc:mysql://localhost:3306/prototypedb?autoReconnect=t > > > > rue</value> > > > > </parameter> > > > > <!-- Class name for mm.mysql JDBC driver --> > > > > <parameter> > > > > <name>driverClassName</name> > > > > <value>org.gjt.mm.mysql.Driver</value> > > > > </parameter> > > > > > > > > org.apache.commons.dbcp.SQLNestedException: Cannot create > > > > PoolableConnectionFactory, cause: > > > > java.sql.SQLException: Server connection failure during > > > > transaction. Due to > > > > underlying exception: 'java.net.ConnectException: > > > Connection refused'. > > > > > > > > ** BEGIN NESTED EXCEPTION ** > > > > > > > > java.net.ConnectException > > > > MESSAGE: Connection refused > > > > > > > > STACKTRACE: > > > > > > > > java.net.ConnectException: Connection refused > > > > at java.net.PlainSocketImpl.socketConnect(Native Method) > > > > at > > > > java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305) > > > > at > > > > > > java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171) > > > > at > > > java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158) > > > > at java.net.Socket.connect(Socket.java:452) > > > > at java.net.Socket.connect(Socket.java:402) > > > > at java.net.Socket.<init>(Socket.java:309) > > > > at java.net.Socket.<init>(Socket.java:124) > > > > at > > > > com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFac > > > > tory.java:121) > > > > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:220) > > > > at > > > com.mysql.jdbc.Connection.createNewIO(Connection.java:1884) > > > > at com.mysql.jdbc.Connection.<init>(Connection.java:440) > > > > at > > > > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriv > > > > er.java:400) > > > > at > > > > org.apache.commons.dbcp.DriverConnectionFactory.createConnecti > > > > on(DriverConne > > > > ctionFactory.java:82) > > > > at > > > > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(P > > > > oolableConnect > > > > ionFactory.java:300) > > > > at > > > > org.apache.commons.dbcp.BasicDataSource.validateConnectionFact > > > > ory(BasicDataS > > > > ource.java:838) > > > > at > > > > org.apache.commons.dbcp.BasicDataSource.createDataSource(Basic > > > > DataSource.jav > > > > a:821) > > > > at > > > > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDat > > > > aSource.java:5 > > > > 18) > > > > at > > > com.ecommerce.DAO.DAOFactory.getConnection(Unknown Source) > > > > at com.ecommerce.DAO.UserDAO.<init>(Unknown Source) > > > > at > > > > com.ecommerce.action.PlaceOrderAction.execute(Unknown Source) > > > > at > > > > org.apache.struts.action.RequestProcessor.processActionPerform > > > > (RequestProces > > > > sor.java:484) > > > > at > > > > org.apache.struts.action.RequestProcessor.process(RequestProce > > > > ssor.java:274) > > > > at > > > > org.apache.struts.action.ActionServlet.process(ActionServlet.j > > > > ava:1482) > > > > at > > > > > > > > > > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) > > > > at > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > > > > at > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > > > > er(Application > > > > FilterChain.java:247) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > > > > cationFilterCh > > > > ain.java:193) > > > > at > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > > > > rapperValve.ja > > > > va:243) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardC > > > > ontextValve.ja > > > > va:190) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.valves.CertificatesValve.invoke(Certificat > > > > esValve.java:2 > > > > 46) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.core.StandardContext.invoke(StandardContex > > > > t.java:2347) > > > > Attempted reconnect 3 times. Giving up. > > > > at > > > com.mysql.jdbc.Connection.createNewIO(Connection.java:1952) > > > > at com.mysql.jdbc.Connection.<init>(Connection.java:440) > > > > at > > > > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriv > > > > er.java:400) > > > > at > > > > org.apache.commons.dbcp.DriverConnectionFactory.createConnecti > > > > on(DriverConne > > > > ctionFactory.java:82) > > > > at > > > > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(P > > > > oolableConnect > > > > ionFactory.java:300) > > > > at > > > > org.apache.commons.dbcp.BasicDataSource.validateConnectionFact > > > > ory(BasicDataS > > > > ource.java:838) > > > > at > > > > org.apache.commons.dbcp.BasicDataSource.createDataSource(Basic > > > > DataSource.jav > > > > a:821) > > > > at > > > > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDat > > > > aSource.java:5 > > > > 18) > > > > at > > > com.ecommerce.DAO.DAOFactory.getConnection(Unknown Source) > > > > at com.ecommerce.DAO.UserDAO.<init>(Unknown Source) > > > > at > > > > com.ecommerce.action.PlaceOrderAction.execute(Unknown Source) > > > > at > > > > org.apache.struts.action.RequestProcessor.processActionPerform > > > > (RequestProces > > > > sor.java:484) > > > > at > > > > org.apache.struts.action.RequestProcessor.process(RequestProce > > > > ssor.java:274) > > > > at > > > > org.apache.struts.action.ActionServlet.process(ActionServlet.j > > > > ava:1482) > > > > at > > > > > > > > > > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) > > > > at > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > > > > at > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > > > > er(Application > > > > FilterChain.java:247) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > > > > cationFilterCh > > > > ain.java:193) > > > > at > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > > > > rapperValve.ja > > > > va:243) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardC > > > > ontextValve.ja > > > > va:190) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.valves.CertificatesValve.invoke(Certificat > > > > esValve.java:2 > > > > 46) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.core.StandardContext.invoke(StandardContex > > > > t.java:2347) > > > > at > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > > > > Valve.java:180 > > > > ) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > > > > spatcherValve. > > > > java:170) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > > > > Valve.java:170 > > > > ) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv > > > > e.java:468) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > > > > gineValve.java > > > > :174) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.connector.http.HttpProcessor.process(HttpP > > > > rocessor.java: > > > > 1027) > > > > at > > > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProce > > > > ssor.java:1125 > > > > ) > > > > at java.lang.Thread.run(Thread.java:534) > > > > com.ecommerce.ecomexception.DAOException: Could not retrieve > > > > Connection > > > > Object. > > > > at > > > com.ecommerce.DAO.DAOFactory.getConnection(Unknown Source) > > > > at com.ecommerce.DAO.UserDAO.<init>(Unknown Source) > > > > at > > > > com.ecommerce.action.PlaceOrderAction.execute(Unknown Source) > > > > at > > > > org.apache.struts.action.RequestProcessor.processActionPerform > > > > (RequestProces > > > > sor.java:484) > > > > at > > > > org.apache.struts.action.RequestProcessor.process(RequestProce > > > > ssor.java:274) > > > > at > > > > org.apache.struts.action.ActionServlet.process(ActionServlet.j > > > > ava:1482) > > > > at > > > > > > > > > > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) > > > > at > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > > > > at > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > > > > er(Application > > > > FilterChain.java:247) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > > > > cationFilterCh > > > > ain.java:193) > > > > at > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > > > > rapperValve.ja > > > > va:243) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardC > > > > ontextValve.ja > > > > va:190) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.valves.CertificatesValve.invoke(Certificat > > > > esValve.java:2 > > > > 46) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.core.StandardContext.invoke(StandardContex > > > > t.java:2347) > > > > at > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > > > > Valve.java:180 > > > > ) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > > > > spatcherValve. > > > > java:170) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > > > > Valve.java:170 > > > > ) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv > > > > e.java:468) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > > > > gineValve.java > > > > :174) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.connector.http.HttpProcessor.process(HttpP > > > > rocessor.java: > > > > 1027) > > > > at > > > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProce > > > > ssor.java:1125 > > > > ) > > > > at java.lang.Thread.run(Thread.java:534) > > > > Aug 10, 2004 3:25:10 AM > > > com.ecommerce.action.PlaceOrderAction execute > > > > SEVERE: Payment.populate > > > > java.lang.NullPointerException > > > > at > com.ecommerce.DAO.UserDAO.insertNewUser(Unknown Source) > > > > at > > > > com.ecommerce.action.PlaceOrderAction.execute(Unknown Source) > > > > at > > > > org.apache.struts.action.RequestProcessor.processActionPerform > > > > (RequestProces > > > > sor.java:484) > > > > at > > > > org.apache.struts.action.RequestProcessor.process(RequestProce > > > > ssor.java:274) > > > > at > > > > org.apache.struts.action.ActionServlet.process(ActionServlet.j > > > > ava:1482) > > > > at > > > > > > > > > > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) > > > > at > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > > > > at > > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > > > > er(Application > > > > FilterChain.java:247) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > > > > cationFilterCh > > > > ain.java:193) > > > > at > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > > > > rapperValve.ja > > > > va:243) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardC > > > > ontextValve.ja > > > > va:190) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.valves.CertificatesValve.invoke(Certificat > > > > esValve.java:2 > > > > 46) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.core.StandardContext.invoke(StandardContex > > > > t.java:2347) > > > > at > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > > > > Valve.java:180 > > > > ) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > > > > spatcherValve. > > > > java:170) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > > > > Valve.java:170 > > > > ) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv > > > > e.java:468) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 64) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > > > > gineValve.java > > > > :174) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > > > > ipeline.java:5 > > > > 66) > > > > at > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > > > > ine.java:472) > > > > at > > > > > > > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > at > > > > org.apache.catalina.connector.http.HttpProcessor.process(HttpP > > > > rocessor.java: > > > > 1027) > > > > at > > > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProce > > > > ssor.java:1125 > > > > ) > > > > at java.lang.Thread.run(Thread.java:534) > > > > Aug 10, 2004 3:25:10 AM > org.apache.struts.action.RequestProcessor > > > > processException > > > > WARNING: Unhandled Exception thrown: class > > > > javax.servlet.ServletException > > > > > > > > > > > > > > > > Below is the configuration which i want to add in server.xml > > > > > > > > <!-- JNDI datasource setup to connect to MYSQL database--> > > > > <Context path="/prototype" docBase="prototype" > > > > debug="5" reloadable="true" crossContext="true" > > > > useNaming="true"> > > > > > > > > <Logger > > className="org.apache.catalina.logger.FileLogger" > > > > prefix="localhost_PrototypeDBTest_log." > suffix=".txt" > > > > timestamp="true"/> > > > > <Resource name="jdbc/prototypedb" > > > > auth="Container" > > > > type="javax.sql.DataSource"/> > > > > > > > > <ResourceParams name="jdbc/prototypedb"> > > > > <parameter> > > > > <name>factory</name> > > > > > > > > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > > > > </parameter> > > > > > > > > <!-- Maximum number of dB connections in pool. > > > Make sure you > > > > configure your mysqld max_connections large enough > > > to handle > > > > all of your db connections. Set to 0 for no limit. > > > > --> > > > > <parameter> > > > > <name>maxActive</name> > > > > <value>20</value> > > > > </parameter> > > > > > > > > <!-- Maximum number of idle dB connections to > > > retain in pool. > > > > Set to 0 for no limit. > > > > --> > > > > <parameter> > > > > <name>maxIdle</name> > > > > <value>10</value> > > > > </parameter> > > > > > > > > <!-- Maximum time to wait for a dB connection to > > > > become available > > > > in ms, in this example 10 seconds. An Exception is > > > thrown if > > > > this timeout is exceeded. Set to -1 to wait > > indefinitely. > > > > --> > > > > <parameter> > > > > <name>maxWait</name> > > > > <value>10000</value> > > > > </parameter> > > > > > > > > <!-- MySQL dB username and password for dB > > > connections --> > > > > <parameter> > > > > <name>username</name> > > > > <value>antonio</value> > > > > </parameter> > > > > <parameter> > > > > <name>password</name> > > > > <value>play</value> > > > > </parameter> > > > > > > > > <!-- Class name for mm.mysql JDBC driver --> > > > > <parameter> > > > > <name>driverClassName</name> > > > > <value>org.gjt.mm.mysql.Driver</value> > > > > </parameter> > > > > > > > > <!-- The JDBC connection url for connecting to > > > your MySQL dB. > > > > The autoReconnect=true argument to the url makes > > > > sure that the > > > > mm.mysql JDBC Driver will automatically reconnect if > > > > mysqld closed > > > > the > > > > connection. mysqld by default closes idle > > > > connections after 8 > > > > hours. > > > > --> > > > > <parameter> > > > > <name>url</name> > > > > > > > > <value>jdbc:mysql://localhost:3306/prototypedb?autoReconnect=t > > > > rue</value> > > > > </parameter> > > > > </ResourceParams> > > > > </Context> > > > > - > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
