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]
