No there is no firewall on Linux box. -----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]
