M
Mullin
i got the following error when using the following jsp on tomcat 4.06
Error Message
=============
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory, cause:
java.sql.SQLException: Server connection failure during transaction.
Attempted reconnect 3 times. Giving up.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1704)
at com.mysql.jdbc.Connection.(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:82)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:838)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:821)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at org.apache.jsp.test$jsp._jspService(test$jsp.java:64)
JSP file
========
<%@ page contentType="text/html;charset=utf-8" language="java"
import="java.sql.*,javax.naming.*"%>
<% Context initCtx = new InitialContext();
Context ctx = (Context) initCtx.lookup("java:comp/env");
Object obj = (Object) ctx.lookup("jdbc/svgtx");
javax.sql.DataSource ds = (javax.sql.DataSource)obj;
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String strSql = "select * from ppgmap";
ResultSet rs = stmt.executeQuery(strSql);%>
<body>
<%while(rs.next()){%>
<p>
<%=rs.getString("template")%>
</p>
<%}%>
<body>
server.xml at tomcat
====================
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="svgtx_log." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/svgtx" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/svgtx">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/svgtx?autoReconnect=true&profileSql=false</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
</ResourceParams>
Error Message
=============
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory, cause:
java.sql.SQLException: Server connection failure during transaction.
Attempted reconnect 3 times. Giving up.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1704)
at com.mysql.jdbc.Connection.(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:82)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:838)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:821)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at org.apache.jsp.test$jsp._jspService(test$jsp.java:64)
JSP file
========
<%@ page contentType="text/html;charset=utf-8" language="java"
import="java.sql.*,javax.naming.*"%>
<% Context initCtx = new InitialContext();
Context ctx = (Context) initCtx.lookup("java:comp/env");
Object obj = (Object) ctx.lookup("jdbc/svgtx");
javax.sql.DataSource ds = (javax.sql.DataSource)obj;
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String strSql = "select * from ppgmap";
ResultSet rs = stmt.executeQuery(strSql);%>
<body>
<%while(rs.next()){%>
<p>
<%=rs.getString("template")%>
</p>
<%}%>
<body>
server.xml at tomcat
====================
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="svgtx_log." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/svgtx" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/svgtx">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/svgtx?autoReconnect=true&profileSql=false</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
</ResourceParams>