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 -----Original Message----- From: Chandolu, Yuva [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 14, 2002 3:21 PM To: [EMAIL PROTECTED] Subject: JDBC Datasource problem 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 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
