RE: WebLogic, Oracle JDBC related

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Fri, 28 Jun 2002 06:58:28 -0800
Message-ID: <F001.0048B6ED.20020628065828@fatcity.com>

Thank you all who responded. I really appreciate it very much. I am learning something new from you.

I think I have enough 'ammunition' to ask some good(?) questions. I found out that on one of the App servers, they use multiple programs(Java?) to support the Web traffic. There are multiple weblogic.properties files. Some have connection pooling setup (initialCapacity=3|1|5 maxCapacity=41 with increments of 2|1|3 and such) while others don't. The CLASSPATH seems to be a mile long! My hunch is that the App is releasing the entire connection pool and establishing it again when a new request comes along. That may be keeping the listener on the database servers very busy all the times.

Following is a typical entry for Connection Pooling. No other properties are defined for any other pools (related to shrink, refreshes etc), at least I did not find them in other properties files..

weblogic.jdbc.connectionPool.summaryPool_A=\

           url=jdbc:oracle:thin:@rs001-cs1:1541:AS1TRP,\
           driver=oracle.jdbc.driver.OracleDriver,\
           initialCapacity=3,\
           maxCapacity=41,\
           capacityIncrement=2,\
           props=user=XXXX;password=YYYY

Thank you very much...

• Kirti
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Deshpande, Kirti INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 28 2002 - 09:58:28 CDT