This is an absolute shot in the dark, but I believe you might have to put a JAR
with JDBC drivers into WEB-INF/lib.
Christopher Garrett III
Inixoma, Incorporated
----- Original Message -----
From: "Eugene Lee" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Monday, August 25, 2003 8:13 AM
Subject: Re: mysql connection pooling problem
Hi James,
I tried inserting the <context-param> into <web-app>, no effect.
But thanks for catching the typo in my JSP code in the lookup() line.
Unfortunately, this had no effect either. I still get the infamous
"Cannot load JDBC driver class 'null'" error... hurmmm...
Any suggestions from others are appreciated too! Anyone?
On Sat, Aug 23, 2003 at 11:09:36AM -0600, James Harman wrote:
: Eugene Lee wrote:
: >On Sat, Aug 23, 2003 at 08:59:05AM -0600, James Harman wrote:
: >:
: >: 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.
:
: Another thing you might look at is your jsp code. You have
:
: DataSource ds = (DataSource)ctx.lookup("java:/comp/env/jdbc/testdev");
:
: you probably want
:
: DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/testdev");
:
: notice that there is no / before comp.
--
Eugene Lee
http://www.coxar.pwp.blueyonder.co.uk/
---------------------------------------------------------------------
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]
