File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Tomcat 6 + jdbc + Oracle" Watch "Tomcat 6 + jdbc + Oracle" New topic

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(
at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)

My server.xml details are:

<ResourceParams name="jdbc/oracle">
<value>jdbcracleci:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<ip address>)(PORT=<port number>))(CONNECT_DATA=(SID=<scheme>)))</value>
<value>{MinLimit=2, MaxLimit=10, InitialLimit=2}</value>

Can anyone help to resolve this problem.
I agree. Here's the link:
subject: Tomcat 6 + jdbc + Oracle
It's not a secret anymore!