RE: WebLogic, Oracle JDBC related

From: Ji, Richard <Richard.Ji_at_MobileSpring.com>
Date: Fri, 28 Jun 2002 13:53:23 -0800
Message-ID: <F001.0048BE41.20020628135323@fatcity.com>

The performance between thin and oci driver aren't a clear cut. It really depends on what you are doing. So the best bet is test it using both drivers and see which one is faster for your application.

-----Original Message-----
Sent: Friday, June 28, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L

The pure java thin driver is supposed to be faster because it does not incur a context switch between the oci and java, while the thick driver has better lob support.

JDBC 3.0 is supposed to have improved lob support as well as pooling, but I don't believe the weblogic server can take advantage of it yet...

Suzy Vordos wrote:

> 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: Warren Lindsey
  INET: wlindsey_at_ponvia.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: Ji, Richard
  INET: Richard.Ji_at_MobileSpring.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 - 16:53:23 CDT