May be you should try using a DataSourceRealm, so that connections could be pooled by DBCP.
On Thu, 18 Nov 2004 11:05:02 -0800 (PST), Norris Shelton <[EMAIL PROTECTED]> wrote: > We have the manager app for each of our contexts set-up to use > the DB to authenticate users. Unfortunately, it is using TONS > of connections. Over an 8 min period, it used 1200 connections. > We have 2 boxes, each with 16 contexts with their own manager > context. Here is what the manager context of each of them looks > like: > <Context docBase="../../server/webapps/manager" > path="/manager" > privileged="true"> > > <Realm > className="org.apache.catalina.realm.JDBCRealm" > digest="MD5" > > driverName="oracle.jdbc.driver.OracleDriver" > > connectionURL="jdbc:oracle:thin:@myhost.com:myport:mydb" > connectionName="tomcatmgr" > connectionPassword="password" > userTable="user_table" > userNameCol="ss_user_id" userCredCol="ss_password" > userRoleTable="role_table" > roleNameCol="tomcat_role" /> > > <Valve > className="org.apache.catalina.valves.RemoteAddrValve" > allow="10\.11\.\d+\.\d+,127\.0\.0\.1"/> > </Context> > > Is this normal? Is there a way to throttle it? > > ===== > > Norris Shelton > Software Engineer > Sun Certified Java 1.1 Programmer > Appriss, Inc. > ICQ# 26487421 > AIM NorrisEShelton > YIM norrisshelton > > __________________________________ > Do you Yahoo!? > Meet the all-new My Yahoo! - Try it today! > http://my.yahoo.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
