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=TCP
)(HOST=xxxx.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxx.com)(SERVER
=DEDICATED)))"
maxActive="8" maxIdle="4"/>
</Context>
