tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Martin Gainty" <mgai...@hotmail.com>
Subject Re: Connection pooling
Date Fri, 11 Jan 2008 14:10:24 GMT
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


Mime
View raw message