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]



Reply via email to