We are also using Tomcat 5 and Oracle 10g, but we don't have to use
tnsnames, just a service name. Your commented out code uses a SID format,
and you are trying to use a TNS entry format. Try something like:
<Resource name='jdbc/diamond9'
auth='Container'
type='javax.sql.DataSource'
driverClassName='oracle.jdbc.OracleDriver'
url='jdbc:oracle:thin:@//poseidon.interfast.ca:1521/develop.interf
ast.ca'
username='tomcat' password='noway'
defaultAutoCommit='false'
maxActive='10' maxIdle='2' maxWait='1000' minIdle='1'
/>
The syntax for url is
jdbc:oracle:thin:@//{hostname or ip}:{listenerPort}/{service name}
I also noticed that you are using a deprecated classname for the Oracle
Driver. The current class name is oracle.jdbc.OracleDriver (not
oracle.jdbc.driver.OracleDriver)
FYI:
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq_0.htm
specifically:
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq_0.htm#05_04
and for the classname:
http://forums.oracle.com/forums/ann.jspa?annID=201
Actually, looking at the faq, the url in your commented out code should
still work. {host}:{port}:{SID}, unless your Listener is now a cluster or
something that makes the SID no longer applicable.
(Still the TNS names for should still work)
I HTH,
Brian
-----Original Message-----
From: "Scott Purcell" <[EMAIL PROTECTED]>
To: <[email protected]>
Date: Wed, 7 Jun 2006 12:39:20 -0500
Subject: TNS entry JNDI
>
>
> I am running Tomcat 5.x and have been using Oracle 9i. We are now
> running Oracle 10g and it only uses TNS names. Here is my context
> element: The one commented out used to work for 9i, and the other one
> is
> for the tns names. I am having trouble finding information about Tomcat
> and TNS names for connection. Does this look correct?
>
>
>
>
>
>
>
>
>
> <Context reloadable="true" path="/new10">
>
>
>
> <Logger className="org.apache.catalina.logger.FileLogger"
> prefix="cpe10g." suffix=".log" timestamp="true"/>
>
>
>
>
>
> <!--
>
> <Resource name="jdbc/old" auth="Container"
>
> type="javax.sql.DataSource" username="old" password="xxx"
>
> driverClassName="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@xxxcom:1521:DEV"
>
> maxActive="8" maxIdle="4"/>
>
>
>
> -->
>
> <Resource name="jdbc/new" auth="Container"
>
> type="javax.sql.DataSource" username="new" password="xxx"
>
> driverClassName="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TC
> P
> )(HOST=xxxx.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxx.com)(SERVE
> R
> =DEDICATED)))"
>
> maxActive="8" maxIdle="4"/>
>
>
>
>
>
> </Context>
>
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
