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: <tomcat-user@jakarta.apache.org> 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: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]