From dbh001@kooee.com.au  Mon Jan  6 04:45:52 2003
Return-Path: <dbh001@kooee.com.au>
Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Delivered-To: mailing list commons-user@jakarta.apache.org
Received: (qmail 21446 invoked by uid 98); 6 Jan 2003 04:45:52 -0000
X-Antivirus: nagoya (v4218 created Aug 14 2002)
Received: (qmail 21128 invoked from network); 6 Jan 2003 04:45:49 -0000
Received: from daedalus.apache.org (HELO apache.org) (63.251.56.142)
  by nagoya.betaversion.org with SMTP; 6 Jan 2003 04:45:49 -0000
Received: (qmail 29877 invoked by uid 500); 6 Jan 2003 04:44:22 -0000
Received: (qmail 29860 invoked from network); 6 Jan 2003 04:44:21 -0000
Received: from smtp03.iprimus.com.au (210.50.30.52)
  by daedalus.apache.org with SMTP; 6 Jan 2003 04:44:21 -0000
Received: from smtp02.iprimus.net.au (210.50.76.70) by smtp03.iprimus.com.au (6.7.010)
        id 3E0FA3A200080F33 for commons-user@jakarta.apache.org; Mon, 6 Jan 2003 15:44:31 +1100
Received: from w9b1jqmyjsd9ds1 ([211.26.152.6]) by smtp02.iprimus.net.au with Microsoft SMTPSVC(5.0.2195.5600);
	 Mon, 6 Jan 2003 15:44:29 +1100
Message-ID: <00b301c2b53f$3fa43b50$0200a8c0@w9b1jqmyjsd9ds1>
From: "David Hemingway" <dbh001@kooee.com.au>
To: <commons-user@jakarta.apache.org>
Subject: DBCP: java.sql.SQLException: Cannot load JDBC driver class 'null'
Date: Mon, 6 Jan 2003 15:51:16 +1100
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00B0_01C2B59B.72A3A200"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-OriginalArrivalTime: 06 Jan 2003 04:44:29.0921 (UTC) FILETIME=[4CB33D10:01C2B53E]
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

------=_NextPart_000_00B0_01C2B59B.72A3A200
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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-=
howto.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:=20

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.jav=
a:312)

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=3D"/lawonline" docBase=3D"lawonline" debug=3D"0"
                 reloadable=3D"true" crossContext=3D"true">
          <Logger className=3D"org.apache.catalina.logger.FileLogger"
                     prefix=3D"localhost_lawonline_log." suffix=3D".txt"
                  timestamp=3D"true"/>
          <Ejb   name=3D"ejb/EmplRecord" type=3D"Entity"
                 home=3D"com.wombat.empl.EmployeeRecordHome"
               remote=3D"com.wombat.empl.EmployeeRecord"/>

 <Resource name=3D"jdbc/myoracle" auth=3D"Container"
              type=3D"javax.sql.DataSource"/>

 <ResourceParams name=3D"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=3D"maxExemptions" type=3D"java.lang.Integer"
                      value=3D"15"/>
          <Parameter name=3D"context.param.name" =
value=3D"context.param.value"
                     override=3D"false"/>
          <Resource name=3D"jdbc/EmployeeAppDb" auth=3D"SERVLET"
                    type=3D"javax.sql.DataSource"/>
          <ResourceParams name=3D"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=3D"mail/Session" auth=3D"Container"
                    type=3D"javax.mail.Session"/>
          <ResourceParams name=3D"mail/Session">
            <parameter>
              <name>mail.smtp.host</name>
              <value>localhost</value>
            </parameter>
          </ResourceParams>
          <ResourceLink name=3D"linkToGlobalResource"
                    global=3D"simpleValue"
                    type=3D"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



------=_NextPart_000_00B0_01C2B59B.72A3A200--