Anyone, I want to configure Tomcat 5.5.x to access each database in the Oracle cluster, and not using the pool. This configuration is for database diagnostic puproses, so I need to create a single connection everytime.
What is the most appropriate way to this using Oracle driver? Currently I am doing this: <Resource name="jdbc/<server name>" auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" type="javax.sql.DataSource" username="<username>" password="<password>" url="jdbc:oracle:thin:@<server>" maxActive="1" maxIdle="1" maxWait="-1" removeAbandoned="true" logAbandoned="true" removeAbandonedTimeout="300" /> -- Thank you, Edmon Begoli http://blogs.ittoolbox.com/eai/software