tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Roberts, Eric" <Eric.Robe...@one.at>
Subject RE: oracle+tomcat 4.1.x+dbcp = driverClassName is required!
Date Mon, 09 Dec 2002 13:06:42 GMT
Pedro,

You need javax.sql - that is the package containing DataSource.
Your Resource type should be: type="javax.sql.DataSource"
You need these parameters in addition to url, username and password:
      <parameter>
        <name>driverClassName</name>
        <value>oracle.jdbc.driver.OracleDriver</value>
      </parameter>
      <parameter>
        <name>factory</name>
        <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
      </parameter>

In the Context the ResourceLink type should be: type="javax.sql.DataSource"

You do not need any resource-ref in your web.xml - just use your ResourceLink name as follows:
  	Context ctx = new InitialContext();
	Context envCtx = (Context) ctx.lookup("java:/comp/env/");
	DataSource ds = (DataSource) envCtx.lookup("/{name_of_resource_link}");

	if (ds != null) {
		DbCon = ds.getConnection();
	}

Hope this helps.

-----Original Message-----
From: Pedro Salazar [mailto:pedro-b-salazar@ptinovacao.pt]
Sent: Montag, 09. Dezember 2002 13:49
To: Tomcat Users List
Subject: oracle+tomcat 4.1.x+dbcp = driverClassName is required!


Greetings,

I'm getting this exception when I try to lookup and cast a DataSource:

[catalina.out]
javax.naming.NamingException: DbcpDataSourceFactory: driverClassName is
required
org.apache.naming.factory.DbcpDataSourceFactory.getObjectInstance(DbcpDataSourceFactory.java:199)
org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:177)
javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:301)
 org.apache.naming.NamingContext.lookup(NamingContext.java:835)
...

[server.xml]
I'm using a <resource> inside <globalNamingResources> and linked with
<resourceLink> in <context> (but I already tried a explicit <resource>
inside <context>).

[web.xml]
I'm using a <resource-ref>.

System: 
-tomcat 4.1.2 (JavaWebServicesDeveloperPack 1.0.1)
-dbcp 1.0
-jdbc oracle driver (renamed to jar and without javax.sql package) in
common/lib directory.

But I know that the driver is being loaded because before call my web
application, I saw this info message in catalina.out:
"
DbcpDataSourceFactory:  driverClassName=oracle.jdbc.driver.OracleDriver,
url=jdbc:oracle:thin:@192.168.89.52:1521:dbtest, user=test_01
"

I don't know why but it works fine in tomcat 4.0.6 I got it in other
machine. So, what is the problem here?

If need I can supply the exactly configurations (resource, resource-ref,
...).

thanks,
Pedro Salazar.

-- 
pedro salazar (pt-inovacao) <pedro-b-salazar@ptinovacao.pt>
key id: D803BC61


--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message