Cannot load JDBC driver class in WebApp-specific lib

[McEahern, Mark S]

I have a JNDI resource defined in my application's context.xml like so:

  <?xml version="1.0" encoding="UTF-8"?>
  <Context reloadable="true" debug="true" allowLinking="true">
    <Resource
      name="jdbc/v5/myjndi"
      type="javax.sql.DataSource"
      driverClassName="oracle.jdbc.driver.OracleDriver"
      password="password"
      maxIdle="2"
      maxWait="5000"
      validationQuery="Select &apos;Hello&apos; from Dual"
      username="username"
      url="jdbc:oracle:thin:@host:port:instance"
      maxActive="4"/>
  </Context>

When I try to put the ojdbc14.jar in the /WEB-INF/lib/*.jar of my web
application, it results in the following error:

Could not get JDBC Connection; nested exception is
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver
class 'oracle.jdbc.driver.OracleDriver' 

However, if I merely move ojdbc14.jar to the common lib folder, it
works:

  C:\Program Files\Apache Software Foundation\Tomcat 6.0\lib

I'd like to package the ojdbc14.jar inside of my application--not so
much because I expect it to be different across applications, but so as
to minimize Tomcat setup necessary to run my applications.  As much as
possible, I'd like my applications to be self-contained.

How do I get the class loader used for this JNDI resource to use my
application's /WEB-INF/lib folder's jars?

Thanks,



Mark McEahern
Lead Architect
Division of Public Health Informatics and Surveillance
Wisconsin State Lab of Hygiene


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]