Re: WebLogic, Oracle JDBC related

IIRC, the WebLogic server startup script contains the path/filename of which weblogic.properties file that is used, and it's passed as a command-line argument.

At a previous job, one application we had used two properties files (Tim's gonna like this one :). One was weblogic.properties config'd with connection pooling and JDBC Thin. The other was application.properties, no connection pooling and JDBC OCI. The developer's reason? JDBC OCI was used to work with LOBs, and all other database calls used JDBC Thin. It never made sense to me, but then I'm not a Java developer either.

"Deshpande, Kirti" wrote:
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.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).