I am able to get it work with org.gjt.mm.mysql.Driver itself.
-----Original Message----- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 6:03 PM To: [EMAIL PROTECTED] Subject: RE: java.net.ConnectException: Connection refused Sounds like you may have a different classloader best to use the class loader that the DriverManangerConnectionFactory uses e.g. Class.forName("com.mysql.jdbc.Driver", true, DriverManagerConnectionFactory.class.getClassLoader()); Let me know how you make out, Martin Gainty >From: "Jim Barrows" <[EMAIL PROTECTED]> >Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]> >To: "Struts Users Mailing List" <[EMAIL PROTECTED]> >Subject: RE: java.net.ConnectException: Connection refused >Date: Tue, 10 Aug 2004 10:16:42 -0700 >MIME-Version: 1.0 >Received: from mail.apache.org ([209.237.227.199]) by mc12-f11.hotmail.com >with Microsoft SMTPSVC(5.0.2195.6824); Tue, 10 Aug 2004 10:17:13 -0700 >Received: (qmail 16184 invoked by uid 500); 10 Aug 2004 17:16:45 -0000 >Received: (qmail 16166 invoked by uid 99); 10 Aug 2004 17:16:44 -0000 >Received: from [12.34.77.106] (HELO SSSC-MAIL-2.internal.sssc.com) >(12.34.77.106) by apache.org (qpsmtpd/0.27.1) with ESMTP; Tue, 10 Aug 2004 >10:16:44 -0700 >X-Message-Info: JGTYoYF78jHjm9i5WASZbo4Un9bGokO1 >Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm >Precedence: bulk >List-Unsubscribe: <mailto:[EMAIL PROTECTED]> >List-Subscribe: <mailto:[EMAIL PROTECTED]> >List-Help: <mailto:[EMAIL PROTECTED]> >List-Post: <mailto:[EMAIL PROTECTED]> >List-Id: "Struts Users Mailing List" <user.struts.apache.org> >Delivered-To: mailing list [EMAIL PROTECTED] >X-ASF-Spam-Status: No, hits=0.0 required=10.0tests= >X-Spam-Check-By: apache.org >content-class: urn:content-classes:message >X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 >Message-ID: ><[EMAIL PROTECTED]> >X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: >java.net.ConnectException: Connection refused >Thread-Index: AcR+/Raevrqm1LFhRiC9L2lugobangAAEiFg >X-Virus-Checked: Checked >Return-Path: [EMAIL PROTECTED] >X-OriginalArrivalTime: 10 Aug 2004 17:17:13.0578 (UTC) >FILETIME=[E0C0E4A0:01C47EFD] > > > > > -----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] > _________________________________________________________________ Get ready for school! Find articles, homework help and more in the Back to School Guide! http://special.msn.com/network/04backtoschool.armx --------------------------------------------------------------------- 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]
