This is pretty much exactly how mine is laid out already. The only difference is that you have the type specified in the context.xml resource link.
I have since added that attribute to my copy and I still have no luck.. Exact same error as before. On Wed, 2004-04-14 at 00:04, Riaan Oberholzer wrote: > This here should work. Follows a slightly different > approach: declare the datasource global to Tomcat and > let your application use a reference to it. In your > server.xml, this should be added: > (Example is for MySql) > > The global DataSource definition > -------------------------------- > > <!-- Global JNDI resources --> > <GlobalNamingResources> > > <Resource name="jdbc/MySQLConnectPool" > auth="Container" > type="javax.sql.DataSource" /> > > <ResourceParams name="jdbc/MySQLConnectPool" > > > <parameter> > <name>username</name> > <value>????????</value> > </parameter> > > <parameter> > <name>password</name> > <value>????????</value> > </parameter> > > <parameter> > <name>driverClassName</name> > <value>com.mysql.jdbc.Driver</value> > </parameter> > > etc.... > > <ResourceParams> > > </GlobalNamingResources> > > > Context reference to global DataSource, this snippet > comes in the <context> part for your application and > is very important: > -------------------------------------- > > <ResourceLink name="jdbc/MySQLConnectPool" > global="jdbc/MySQLConnectPool" > type="javax.sql.DataSource" /> > > This should work. If the mysql.jar is in Tomcat's > /common/lib directory. > > > > --- Paul Richards <[EMAIL PROTECTED]> wrote: > > Hi, > > I am running Tomcat from the Java Webservices > > Developer Pack 1.3 and I > > cannot get JNDI working for mysql DataSource > > objects. I have googled > > around for my error which is: > > > > java.sql.SQLException: Cannot load JDBC driver class > > 'null' > > at > > > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:529) > > at > > > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:329) > > > > > > What I found on google was that this error is not > > just a problem with Mysql and that people have > > experienced it with Oracle and Postgresql also: > > > http://archives.real-time.com/pipermail/tomcat-users/2002-October/081368.html > > > > I tried the suggestion in this last URL of using the > > exact orderings of > > parameters in the server.xml file as shown in the > > Tomcat JNDI DataSource > > HowTo. Unfortunately this has not helped my case. > > > > > > I appreciate that a very similar thread to this is > > currently running but > > that problem looks different to mine. > > > > > > I have failover code which created a Mysql > > datasource manually if the > > JNDI fails and the failover code works perfectly. > > This makes me sure > > that my CLASSPATHs are correct. > > > > > > > > -- > > Paul Richards <[EMAIL PROTECTED]> > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Tax Center - File online by April 15th > http://taxes.yahoo.com/filing.html > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- Paul Richards <[EMAIL PROTECTED]> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
