tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabriel Belingueres <belingue...@gmail.com>
Subject Re: Realm using LOTS of DB connections
Date Thu, 18 Nov 2004 20:28:06 GMT
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
<norrisshelton@yahoo.com> 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: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
>

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message