RE: JDBC Datasource problem - please help me

["Chandolu, Yuva" <YC...@thexchange.com>]

Hi,

I still have the "Cannot load JDBC driver class 'null'" problem :-(. I have
decompiled the org.apache.commons.dbcp.BasicDataSource class, put debug and
compiled it, and noticed that driverClassName is coming as null, and the
function setDriverClassName() is never called, but in the logs I see that
the jndi params for db pool I specified are picked up by the server. I don't
know where I am doing wrong. Here I am pasting parts of my server.xml,
web.xml and the log.

Please someone help me, I am badly stuck here :-(

Server.xml:
~~~~~~~~~~
<Host name="localhost" debug="5" appBase="webapps" 
	unpackWARs="true" autoDeploy="true">

	<Logger className="org.apache.catalina.logger.FileLogger"
		directory="logs"  prefix="localhost_log." suffix=".txt"
		timestamp="true"/>

	<Context path="arbinet" docBase="arbinet" debug="5"
		reloadable="true" crossContext="true">

		<Logger className="org.apache.catalina.logger.FileLogger"
			prefix="localhost_examples_log." suffix=".txt"
			timestamp="true"/>

		<Resource name="jdbc/arbinet" auth="Container"
			type="javax.sql.DataSource"/>

		<ResourceParams name="jdbc/arbinet">
			<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:@1.1.1.1:1521:testdb</value>
			</parameter>
			<parameter>
				<name>username</name>
				<value>arbinet</value>
			</parameter>
			<parameter>
				<name>password</name>
				<value>arbinet7</value>
			</parameter>
			<parameter>
				<name>maxActive</name>
				<value>20</value>
			</parameter>
			<parameter>
				<name>maxIdle</name>
				<value>10</value>
			</parameter>
			<parameter>
				<name>maxWait</name>
				<value>0</value>
			</parameter>
		</ResourceParams>

	</Context>

</Host>



Web.xml:
~~~~~~~
<resource-ref>
	<description>Arbinet's Oracle Datasource</description>
	<res-ref-name>jdbc/arbinet</res-ref-name>
	<res-type>javax.sql.DataSource</res-type>
	<res-auth>Container</res-auth>
</resource-ref>


localhost_examples_log.2002-12-17.txt:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2002-12-17 10:16:15 NamingContextListener[/Standalone/localhostarbinet]:
Creating JNDI naming context
2002-12-17 10:16:15 NamingContextListener[/Standalone/localhostarbinet]:
Resource parameters for jdbc/arbinet = ResourceParams[name=jdbc/arbinet,
parameters={factory=org.apache.commons.dbcp.BasicDataSourceFactory,
maxWait=0, maxActive=20, password=arbinet7,
url=jdbc:oracle:thin:@10.0.40.50:1521:ARBDEVF,
driverClassName=oracle.jdbc.driver.OracleDriver, maxIdle=10,
username=arbinet}]
2002-12-17 10:16:15 NamingContextListener[/Standalone/localhostarbinet]:
Adding resource ref jdbc/arbinet
2002-12-17 10:16:15 NamingContextListener[/Standalone/localhostarbinet]:
ResourceRef[className=javax.sql.DataSource,factoryClassLocation=null,factory
ClassName=org.apache.naming.factory.ResourceFactory,{type=scope,content=Shar
eable},{type=auth,content=Container},{type=factory,content=org.apache.common
s.dbcp.BasicDataSourceFactory},{type=maxWait,content=0},{type=maxActive,cont
ent=20},{type=password,content=arbinet7},{type=url,content=jdbc:oracle:thin:
@10.0.40.50:1521:ARBDEVF},{type=driverClassName,content=oracle.jdbc.driver.O
racleDriver},{type=maxIdle,content=10},{type=username,content=arbinet}]
2002-12-17 10:16:15 NamingContextListener[/Standalone/localhostarbinet]:
Resource parameters for UserTransaction = null

Thanks in advance
Yuva


-----Original Message-----
From: Eddie Liang [mailto:eliang@edge.com]
Sent: Monday, December 16, 2002 11:01 AM
To: 'Tomcat Users List'
Subject: RE: JDBC Datasource problem


Yuva,
   I guess that your database server is Oracle. If that is the case, try to
change " javax.sql.DataSource" to "
oracle.jdbc.pool.OracleConnectionCacheImpl" in server.xml and web.xml.


Eddie Liang
Database Architect
Phone: 630-810-9669 x253