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.


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

Reply via email to