JDBC Datasource problem

[Chandolu, Yuva]

Hi,

I am getting "org.apache.jasper.JasperException: Cannot create resource
instance" when I am trying to get connection from the DBCP pool. the jsp
code I wrote is...

=============================================
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
=============================================

And I have following in my web.xml

=============================================
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd";>
<web-app>
  <display-name>Welcome to Tomcat</display-name>
  <description>
     Welcome to Tomcat
  </description>

<resource-ref>
        <description>Arbinet's Oracle Datasource</description>
        <res-ref-name>jdbc/myoracle</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
</resource-ref>

</web-app>
==============================================

And I have following in my server.xml

==============================================
<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:@1.1.1.1:1521:testdb</value>
  </parameter>
  <parameter>
    <name>username</name>
    <value>test</value>
  </parameter>
  <parameter>
    <name>password</name>
    <value>test</value>
  </parameter>
  <parameter>
    <name>maxActive</name>
    <value>20</value>
  </parameter>
  <parameter>
    <name>maxIdle</name>
    <value>10</value>
  </parameter>
  <parameter>
    <name>maxWait</name>
    <value>-1</value>
  </parameter>
</ResourceParams>
==============================================

I also have downloaded commons DBCP version 1.0 and Pool 1.0 and copied the
zip files to commons/lin folder and renamed to jar files. Tomcat 4.1.12 doc
mentioned that I should also copy commons collection 2.0 jar but when I copy
collections 2.0 jar in commons\lib Tomcat is not starting at all :-(. So I
have kept back the collections.jar in commons\lib that came with
Tomcat.4.1.12.

Please some one help me getting out of the problem. I also tried deleting
javax.sql.* files from classes12.jar (jdbc oracle client stuff, which I have
in commons\lib folder) and no luck.

Thanks in advance.

-Yuva