The attribute maxactive controls how big the pool is. if maxactive is set to 1 then there can be only 1 per time. There are also non-dbcp solutions which have oracle examples described under JDBC datasources link in tomcat 5.5 doc at http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html good luck - andy gordon
Edmon Begoli <[EMAIL PROTECTED]> wrote: 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: " auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" type="javax.sql.DataSource" username="" password=" " url="jdbc:oracle:thin:@" maxActive="1" maxIdle="1" maxWait="-1" removeAbandoned="true" logAbandoned="true" removeAbandonedTimeout="300" /> -- Thank you, Edmon Begoli http://blogs.ittoolbox.com/eai/software --------------------------------- Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort.
