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]
