I noticed that in the web.xml you have the jbdc resource in a resource-ref. In my stuff I have it as a context-param like this
<context-param>
<param-name>
javax.servlet.jsp.jstl.sql.dataSource
</param-name>
<param-value>
jdbc/testdev
</param-value>
</context-param>This comes right after the <web-app> element in the web.xml file.
I am not experienced enough to know the difference between context-param and resource-ref, but this seems to work for me.
James
Eugene Lee wrote:
I'm having a really odd problem connecting to a local MySQL server. If I use java.sql.DriverManager.getConnection(), it works perfectly fine. But when I try to use a connection pool:
http://www.mysql.com/articles/connection_pooling_with_connectorj.html
it errors out:
java.sql.SQLException: Cannot load JDBC driver class 'null'
I've tried moving the MySQL driver to $CATALINA_HOME/common/lib, $JAVA_HOME/jre/lib/ext, and even my webapp's WEB-INF/lib. The results are still the same.
I've followed the often-recommended Tomcat 4.1 documentation to no avail. Here's what my box is running:
FreeBSD 4.8-RELEASE-p3 Java 2 SDK 1.3.1_09
Jakarta-Tomcat 4.1.27
MySQL Connector/J 3.0.8
I've attached my server.xml, my webapp's web.xml, and a test page test.jsp to demonstrate the error. BTW, before it throws the exception on the getconnection(), the page output is:
con1 works! DS lookup OK!
I appreciate any suggestions. Much thanks in advance.
------------------------------------------------------------------------
--------------------------------------------------------------------- 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]
