javax.naming.NamingException: Tomcat 6.0 conn to Ora10g
I searched extensively to try and figure out where my error lies, but I am about stumped. I am trying to make a JDBC connection from a web service to an Oracle 10g database using Tomcat 6.0 enabled with Apache AXIS for SOAP implementation. Here is the relevant information:
=== EDMSService.xml (context file in TOMCAT_HOME\webapps\ ) ===
<Contextpath="/EDMSService"
docBase="EDMSService.war"
debug="1"
reloadable="true"
crossContext="true"
useNaming="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost-EDMSService-log."
suffix=".txt"
timestamp="true"/>
<Resourcename="jdbc/EDMS"
auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/EDMS">
<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:@HOST:PORT:DATABASE</value>
</parameter>
<parameter>
<name>username</name>
<value>USERNAME</value>
</parameter>
<parameter>
<name>password</name>
<value>PASSWORD</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>0</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>60000</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>300</value>
</parameter>
</ResourceParams>
</Context>
=== web.xml ===
<resource-ref>
<description>The database for the EDMS Info</description>
<res-ref-name>jdbc/EDMS</res-ref-name>
<res-type>javax.sql.EDMS</res-type>
<res-auth>Container</res-auth>
</resource-ref>
=== java database connection method ===
publicstatic DataSource getDataSource(String connection)throws NamingException
{
DataSource datasource =null;
Context jndi =new InitialContext();
datasource = (DataSource) jndi.lookup("java:comp/env/jdbc/" + connection);
return datasource;
}
=== Libraries in TOMCAT_HOME\lib ===
ojdbc14.jar
classes12.jar
commons-pool-1.3.jar
commons-dbcp-1.2.jar
===
I can locate and pull up the WSDL fine, but when I call a method that accesses the database, I receive the following error:
javax.naming.NamingException: Cannot create resource instance
Any help would be greatly appreciated.
