This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Tomcat 6 + jdbc + Oracle

 
Shriram Gopalakrishnan
Ranch Hand
Posts: 44
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic