Hi David, Thank you so much for the response and good advice. I verified that I was able to connect to MySQL using the command you suggested (via port 3306). I also removed the autoReconnect parameter and moved the pooling config out to Catalina/localhost/DBTest.xml. I restarted tomcat and I'm still having the same issue.
Do you have any other ideas? Thanks again, Ty --- David Smith <[EMAIL PROTECTED]> wrote: > For starters, you might want to make a copy of your > server.xml file for > documentation purposes and then drop all the > comments from the active > one. The documentation comments are excellent, but > they make the > serverl.xml near impossible to read. > > At any rate.... the exception is connection refused. > Are you sure your > MySQL server is listening on port 3306? Some > default configurations use > unix sockets exclusively -- something java JDBC > drivers can't do. Try > this from the same machine your server is on: > > mysql -h localhost -P 3306 -u rpd -p > > The above command forces mysql client to connect via > TCP/IP with userid > rpd and prompt for a password. If this works, then > we're looking at > something else. If this doesn't, reconfigure your > mysql server to > listen on tcp/ip port 3306 and try again. > > Some additional recommendations -- not directly > related to your issue, > but worth mentioning: > > The <Context ...> ... </Context> block should be in > it's own xml file > under conf/Catalina/localhost, named to match the > context of your webapp > -- DBTest.xml in your case. Avoid setting this in > server.xml as it > requires restarting the tomcat container every time > you want to make a > change to your webapp's config. > > Drop the autoReconnect=true from your database url. > It isn't > recommended by MySQL and doesn't make sense in a > database connection > pool anyway. > > --David > > tyju tiui wrote: > > I'm having problems setting up connection pooling > with > > comcat 5.5.2.0 and MySQL 5.0.24 using mysql > > connector/J 5.0. > > > > I've setup / populated a test database and > verified > > that I can login to the server/db using the > specified > > username/password/host found in the connection > string. > > My server.xml looks like this: > > > > > <snipped here .... a lot of irrelevant stuff to > the issue at hand. /> > > <!-- ********** Pooling Config ********** > --> > > <Context path="/DBTest" docBase="DBTest" > > debug="5" reloadable="true" > > crossContext="true"> > > > > > > > < snipped again...../> > > <Resource name="jdbc/TestDB" > > auth="Container" > > type="javax.sql.DataSource" > > > > > factory="org.apache.commons.dbcp.BasicDataSourceFactory" > > maxActive="100" > > username="rpd" > > password="2wERk4rpd" > > maxIdle="30" > > maxWait="10000" > > > > driverClassName="com.mysql.jdbc.Driver" > > removeAbandoned="true" > > > > > url="jdbc:mysql://localhost:3306/phptest?autoReconnect=true" > > /> > > > > </Context> > > <!-- ********** End Pooling ********** --> > > > > </Host> > > > > </Engine> > > > > </Service> > > > > </Server> > > > > > > > > > > > > > > > > I'm using the sample web.xml and test.jsp found > at: > > > http://tomcat.apache.org/tomcat-5.0-doc/jndi-datasource-examples-howto.html > > > > > > > > > > > > > > There error I'm getting is: > > > > org.apache.jasper.JasperException: Unable to get > > connection, DataSource invalid: > > "org.apache.commons.dbcp.SQLNestedException: > Cannot > > create PoolableConnectionFactory (Server > connection > > failure during transaction. Due to underlying > > exception: 'java.net.SocketException: > > java.net.ConnectException: Connection refused'. > > > > ** BEGIN NESTED EXCEPTION ** > > > > java.net.SocketException > > MESSAGE: java.net.ConnectException: Connection > refused > > > > STACKTRACE: > > > > java.net.SocketException: > java.net.ConnectException: > > Connection refused > > at > > > com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) > > at > com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) > > at > > > com.mysql.jdbc.Connection.createNewIO(Connection.java:2815) > > at > > > com.mysql.jdbc.Connection.<init>(Connection.java:1531) > > at > > > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) > > at > > > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) > > at > > > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) > > at > > > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877) > > at > > > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851) > > at > > > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) > > at > > > org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(Unknown > > Source) > > at > > > org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(Unknown > > Source) > > at > > > org.apache.jsp.test_jsp._jspx_meth_sql_query_0(test_jsp.java:100) > > at > > > org.apache.jsp.test_jsp._jspService(test_jsp.java:58) > > at > > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) > > at > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > at > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334) > > at > > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) > > at > > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) > === message truncated === ____________________________________________________________________________________ Sponsored Link $420k for $1,399/mo. Think You Pay Too Much For Your Mortgage? Find Out! www.LowerMyBills.com/lre --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
