Place your classes12.jar in tomcat's common/lib
Regards,
PQ
"This Guy Thinks He Knows Everything"
"This Guy Thinks He Knows What He Is Doing"
-----Original Message-----
From: David Hemingway [mailto:dbh001@kooee.com.au]
Sent: January 5, 2003 11:51 PM
To: commons-user@jakarta.apache.org
Subject: DBCP: java.sql.SQLException: Cannot load JDBC driver class 'null'
Hi,
Sorry if this has been addressed before on this list but I have not seen it.
I have followed the instructions in
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how
to.html. I am not sure if this is a problem with tomcat or with dbcp.
I can get the setup to work 100% under win32 but using the same settings
under linux I get:
java.sql.SQLException: Cannot load JDBC driver class 'null'
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:529)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3
12)
I have seen this problem raised in many places but no one has seemed to know
the correct answer.
My configuration is as follows:
Linux - Red Hat 7.3
Apache 1.3.27
Tomcat 4.1.12 LE
Oracle 9i
Pool 1.0
DBCP 1.0
Collections 2.0
common/lib/commons-collections.jar
common/lib/commons-dbcp.jar
common/lib/commons-pool.jar
common/lib/classes12.jar (with the javax.sql removed)
server.xml:
<Context path="/lawonline" docBase="lawonline" debug="0"
reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_lawonline_log." suffix=".txt"
timestamp="true"/>
<Ejb name="ejb/EmplRecord" type="Entity"
home="com.wombat.empl.EmployeeRecordHome"
remote="com.wombat.empl.EmployeeRecord"/>
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/myoracle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@192.168.0.10:1521:lawol</value>
</parameter>
<parameter>
<name>username</name>
<value>lawonline</value>
</parameter>
<parameter>
<name>password</name>
<value>Le12No06</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
<Environment name="maxExemptions" type="java.lang.Integer"
value="15"/>
<Parameter name="context.param.name" value="context.param.value"
override="false"/>
<Resource name="jdbc/EmployeeAppDb" auth="SERVLET"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/EmployeeAppDb">
<parameter><name>username</name><value>sa</value></parameter>
<parameter><name>password</name><value></value></parameter>
<parameter><name>driverClassName</name>
<value>org.hsql.jdbcDriver</value></parameter>
<parameter><name>url</name>
<value>jdbc:HypersonicSQL:database</value></parameter>
</ResourceParams>
<Resource name="mail/Session" auth="Container"
type="javax.mail.Session"/>
<ResourceParams name="mail/Session">
<parameter>
<name>mail.smtp.host</name>
<value>localhost</value>
</parameter>
</ResourceParams>
<ResourceLink name="linkToGlobalResource"
global="simpleValue"
type="java.lang.Integer"/>
</Context>
web.xml:
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Any help would be very much appreciated. Thank you
regards,
David Hemingway
|