Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Cannot create PoolableConnectionFactory to mysql by JSP on tomcat

24 views
Skip to first unread message

Mullin

unread,
Apr 1, 2005, 1:30:03 AM4/1/05
to
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&amp;profileSql=false</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
</ResourceParams>

0 new messages