Or put it into tomcat4/common/lib - because then all web applications can access the JDBC driver.
Rob -----Original Message----- From: Christopher Garrett [mailto:[EMAIL PROTECTED] Sent: 26 August 2003 10:43 To: Tomcat Users List Subject: Re: mysql connection pooling problem 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] This e-mail is confidential and privileged. If you are not the intended recipient please accept our apologies; please do not disclose, copy or distribute information in this e-mail or take any action in reliance on its contents: to do so is strictly prohibited and may be unlawful. Please inform us that this message has gone astray before deleting it. Thank you for your co-operation. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
