tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew Hole" <andremailingl...@gmail.com>
Subject Re: Connection pooling
Date Fri, 11 Jan 2008 14:24:10 GMT
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 <mgainty@hotmail.com> 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" <andremailinglist@gmail.com>
> 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: users-unsubscribe@tomcat.apache.org
> > For additional commands, e-mail: users-help@tomcat.apache.org
> >
> >
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message