File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Tomcat and the fly likes Tomcat 6 + jdbc + Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Tomcat 6 + jdbc + Oracle" Watch "Tomcat 6 + jdbc + Oracle" New topic
Author

Tomcat 6 + jdbc + Oracle

Shriram Gopalakrishnan
Ranch Hand

Joined: Feb 20, 2007
Posts: 44
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>jdbcracleci:@(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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Tomcat 6 + jdbc + Oracle
 
Similar Threads
Tomcat DataSource Configuration Problem
Context in Virtual Hosts
connection pooling with Tomcat 4.0
Geting error while i accessing URL
Tomcat 4.1.31 Connection Pooling Problem