Application Server :
Tomcat 6
DB: Oracle
Driver Type: OCI
With above configuration I am trying to connect to Oracle database using tomcat server and I am getting Exception:
javax.naming.NamingException: Cannot create resource instance
at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:143)
at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)
My server.xml details are:
<ResourceParams name="jdbc/oracle">
<parameter>
<name>factory</name>
<value>oracle.jdbc.pool.OracleDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>
jdbcracle:oci:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<ip address>)(PORT=<port number>))(CONNECT_DATA=(SID=<scheme>)))</value>
</parameter>
<parameter>
<name>username</name>
<value>usernm</value>
</parameter>
<parameter>
<name>user</name>
<value>usr</value>
</parameter>
<parameter>
<name>password</name>
<value>pass</value>
</parameter>
<parameter>
<name>connectionCachingEnabled</name>
<value>true</value>
</parameter>
<parameter>
<name>connectionCacheName</name>
<value>cm1</value>
</parameter>
<parameter>
<name>connectionCacheProperties</name>
<value>{MinLimit=2, MaxLimit=10, InitialLimit=2}</value>
</parameter>
</ResourceParams>
Can anyone help to resolve this problem.