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" <[email protected]>
> 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: [email protected]
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: [email protected]
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
