Connection Pool configuration

["Propes, Barry L [GCG-NAOT]" <ba...@citigroup.com>]

Hello, I'm dealing with Tomcat 4.0.1 and -4.1.3.
 
I badly need to get connection pooling configured, but am not quite sure how to do it.
 
Here's  a block from my server.xml file.
 
 
    <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
 driverName="oracle.jdbc.OracleDriver"
 connectionURL="jdbc:oracle:thin:@169.xxx.xx.xxx:1521:SID"
 connectionName="user_name"
 connectionPassword="user_pwd"
 userTable="users" userNameCol="user_name" userCredCol="user_pass"
 userRoleTable="user_roles" roleNameCol="role_name" />
 
 
This goes to the users table created for password sessions.
 
Do I configure anything here for Connection Pooling? Do I add 
maxActive	 8	
minIdle 0 , etc.?
 
How would I alter or configure this? Any advice is welcomed. 
 
Thanks,
 
Barry

Re: Connection Pool configuration

[Foo Shyn <fo...@optegra.com.my>]

Hi,

I'm not sure bout Tomcat 4.0, but i think in 4.1 u could do it through the 
admin page.
Just create a Datasource under ur apps context should do the trick.....

Thanx.
Regards,
FooShyn
----- Original Message ----- 
From: "Propes, Barry L [GCG-NAOT]" <ba...@citigroup.com>
To: "Tomcat Users List" <us...@tomcat.apache.org>
Sent: Friday, February 09, 2007 12:01 AM
Subject: Connection Pool configuration


Hello, I'm dealing with Tomcat 4.0.1 and -4.1.3.

I badly need to get connection pooling configured, but am not quite sure how 
to do it.

Here's  a block from my server.xml file.


    <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
 driverName="oracle.jdbc.OracleDriver"
 connectionURL="jdbc:oracle:thin:@169.xxx.xx.xxx:1521:SID"
 connectionName="user_name"
 connectionPassword="user_pwd"
 userTable="users" userNameCol="user_name" userCredCol="user_pass"
 userRoleTable="user_roles" roleNameCol="role_name" />


This goes to the users table created for password sessions.

Do I configure anything here for Connection Pooling? Do I add
maxActive 8
minIdle 0 , etc.?

How would I alter or configure this? Any advice is welcomed.

Thanks,

Barry



--------------------------------------------------------------------------------


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.30/674 - Release Date: 2/7/2007 
3:33 PM



---------------------------------------------------------------------
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