Check out -
http://www.mail-archive.com/[email protected]/msg56314.html
Specifically, you should be using oracle.jdbc.pool.OracleConnectionCacheImpl as the
classname. I found I have to use the same class name in web.xml to get everything to
work properly.
I'm using this on several applications without problems.
Ryan
>>> [EMAIL PROTECTED] 09/26/02 04:55PM >>>
Hello :)
I am using Tomcat 4.0.4 with JDK1.4
I am getting the followig exception while creating the DataSource:
"javax.naming.NamingException: Cannot create resource instance"
Following is my code, server.xml and web.xml entries.
I will really appreciate if anyone can help me out here.
Thanx in advance
Zeeshan
Java Code
========
ctx = (Context) new InitialContext().lookup("java:comp/env");
if (ctx!=null) {
dataSource = (javax.sql.DataSource) ctx.lookup("jdbc/datasource");
connection = dataSource.getConnection();
}
Server.xml
========
<Resource name="jdbc/datasource" auth="Container"
type="oracle.jdbc.pool.OracleDataSource"/>
<ResourceParams name="jdbc/datasource">
<parameter><name>username</name><value>test</value></parameter>
<parameter><name>password</name><value>test</value></parameter>
<parameter><name>driverClassName</name><value>oracle.jdbc.driver.OracleDriver</value></parameter>
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:oracle:thin:@localhost:1521:ORACLE</value>
</parameter>
<parameter>
<name>url</name><value>jdbc:oracle:thin:@localhost:1521:ORACLE</value>
</parameter>
<parameter><name>maxActive</name><value>100</value></parameter>
<parameter><name>maxIdle</name><value>30000</value></parameter>
<parameter><name>maxWait</name><value>100</value></parameter>
</ResourceParams>
Web.xml
=======
<resource-ref>
<description>Resource reference to java.sql.Connection factory defined in
server.xml </description>
<res-ref-name>jdbc/datasource</res-ref-name>
<res-type>oracle.jdbc.pool.OracleDataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
