tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Propes, Barry L [GCG-NAOT]" <barry.l.pro...@citigroup.com>
Subject RE: Connection Pool configuration
Date Wed, 14 Feb 2007 16:50:45 GMT
also,

I'm looking for my DBCP configuration in the server.xml file and see the very generic:

          <Resource name="jdbc/EmployeeAppDb" auth="SERVLET"
                    type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/EmployeeAppDb">
            <parameter><name>user</name><value>sa</value></parameter>
            <parameter><name>password</name><value></value></parameter>
            <parameter><name>driverClassName</name>
              <value>org.hsql.jdbcDriver</value></parameter>
            <parameter><name>driverName</name>
              <value>jdbc:HypersonicSQL:database</value></parameter>
          </ResourceParams>

Is this actually it?
Do I just need to recreate my own or do I add additional resource params to this?
Like for instance, that below.

         <parameter>
              <name>removeAbandoned</name>
              <value>true</value>
            </parameter>


I didn't see a preconfigured DBCP setting that's commented out. Any feedback would be great!

Thanks,
.

-----Original Message-----
From: Propes, Barry L [GCG-NAOT] 
Sent: Wednesday, February 14, 2007 10:17 AM
To: Tomcat Users List
Subject: RE: Connection Pool configuration


are you talking under the META-INF folder of the app I suppose? Just so that I'm clear.

I was looking at the documentation of TC 5.5 and it mentioned a jar file titled naming-factory-dbcp.jar.
I don't seem to have that under either of my lib directories -- common or root.
I do have naming-factory.jar, but is that good enough for DB Connection Pooling?

Anyone that's dealt with 4.0 or 4.1 know?

-----Original Message-----
From: Foo Shyn [mailto:fooshyn@optegra.com.my]
Sent: Thursday, February 08, 2007 7:36 PM
To: Tomcat Users List
Subject: Re: Connection Pool configuration


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]" <barry.l.propes@citigroup.com>
To: "Tomcat Users List" <users@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


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