I'm using an older version of Tomcat, [ : ( ], so I can't string all my attributes together like you have, but DBCP does work for me.
Keep in mind, I have to split my attributes in separate tags, but it's basically the same, but here's my config: <Resource name="jdbc/myoracle" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/myoracle"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>driverClassName</name> <value>oracle.jdbc.OracleDriver</value> </parameter> <parameter> <name>url</name> <value>jdbc:oracle:thin:@169.222.22.222:1521:SID</value> </parameter> <parameter> <name>username</name> <value>user_name</value> </parameter> <parameter> <name>password</name> <value>*******</value> </parameter> <parameter> <name>maxActive</name> <value>125</value> </parameter> <parameter> <name>maxIdle</name> <value>15</value> </parameter> <parameter> <name>maxWait</name> <value>7000</value> </parameter> <parameter> <name>removeAbandoned</name> <value>true</value> </parameter> <parameter> <name>removeAbandonedTimeout</name> <value>60</value> </parameter> <parameter> <name>logAbandoned</name> <value>true</value> </parameter> <parameter> <name>minEvictableIdleTimeMillis</name> <value>5000</value> </parameter> <parameter> <name>timeBetweenEvictionRunsMillis</name> <value>10000</value> </parameter> <parameter> <name>testWhileIdle</name> <value>true</value> </parameter> </ResourceParams> -----Original Message----- From: Andrew Hole [mailto:[EMAIL PROTECTED] Sent: Friday, January 11, 2008 8:24 AM To: Tomcat Users List Subject: Re: Connection pooling Hi! Thanks... With the following configuration i get the error:DatasourceConnectionProvider - Could not find datasource: java:/comp/env/ehr <Resource name="jdbc/ehr" auth="Container" type="oracle.jdbc.pool.OracleDataSource" factory="oracle.jdbc.pool.OracleDataSourceFactory" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@192.168.1.244:1521:MIGRA03" user="alert_viewer" password="alert" initialLimit="5" minLimit="5" maxLimit="10" debug="5" /> With Resoruce name = "ehr" works fine but pooling is disable. I don't know if paramenters initalLimit, minLimit are defined correctly. Could you help me to setup a correct configuration? I want have 5 initial database sessions. <Resource name="ehr" auth="Container" type="oracle.jdbc.pool.OracleDataSource" factory="oracle.jdbc.pool.OracleDataSourceFactory" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@192.168.1.244:1521:MIGRA03" user="alert_viewer" password="alert" initialLimit="5" minLimit="5" maxLimit="10" debug="5" /> Thanks a lot On Jan 11, 2008 2:10 PM, Martin Gainty <[EMAIL PROTECTED]> wrote: > Andrew- > > The first thing I noticed is your Resource name shoule be "jdbc/ehr" > replace server_name with the actual server name > replace the SID with the Service ID you will be using (check the > tnsnames.ora for SID) > http://www.microdeveloper.com/html/JNDI_Orcl_Tomcat1p.html > > Martin > > ----- Original Message ----- > From: "Andrew Hole" <[EMAIL PROTECTED]> > To: "Tomcat Users List" <users@tomcat.apache.org> > Sent: Friday, January 11, 2008 5:32 AM > Subject: Connection pooling > > > > Hello! > > > > The following configuration was not supposed to be created 5 > > connections at first get connection execution? > > My application with the following configuration creates always a new > > session in the database for each invocation, > > which is not to take advantage of pooling. Why? > > > > <Context docBase="F:/TOMCAT_UPG1_VIEWER/mni_ehrviewer" > > reloadable="true" path="upg1ehr" > > > > > <Resource name="ehr" auth="Container" > type="oracle.jdbc.pool.OracleDataSource" > > factory="oracle.jdbc.pool.OracleDataSourceFactory" > > driverClassName="oracle.jdbc.OracleDriver" > > url="jdbc:oracle:thin:@server_name:1521:sid" user="user" > > password="password" initialSize="5" maxActive="50" maxIdle="10" > > minIdle="5" maxWait="-1" defaultAutoCommit="false"/> > > > > > > <Manager className="org.apache.catalina.session.StandardManager" > > maxActiveSessions="-1" maxInactiveInterval="1800" pathname="" > > processExpiresFrequency="6" /> > > > > </Context> > > > > > > Thanks a lot > > > > --------------------------------------------------------------------- > > To start a new topic, e-mail: users@tomcat.apache.org > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]