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:[EMAIL PROTECTED]
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]" <[EMAIL PROTECTED]>
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: [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]
