Location of context file and configuration of database access as JNDI resource has changed between Tomcat 4 and Tomcat 6.
Database driver used is Oracle JDBC thin
Tomcat6
The JNDI resource is set up in context.xml file located at $TOMCAT_HOME/conf
The contents of this file will be loaded for each web application
Resource entry uses only XML attribites. No more / tags
...
...
Tomcat 4
The JNDI resource is set up inside the entry in $TOMCAT_HOME\conf\server.xml
Resource entry uses / tags
...
username
dbusername
password
dbpassword
driverClassName
oracle.jdbc.driver.OracleDriver
url
jdbc:oracle:thin:@::
maxActive
8
maxIdle
4
...
P.S - You can also use service name option for the Database URL above (parameter/attribute name "url")
jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=) (PORT=)) (CONNECT_DATA= (SERVER=dedicated) (SERVICE_NAME=) ) )
Thanks
