RE: WebLogic, Oracle JDBC related

From: Michael P Sale <Michael.Sale_at_oracle.com>
Date: Fri, 28 Jun 2002 14:33:21 -0800
Message-ID: <F001.0048BEEF.20020628143321@fatcity.com>

Confirmed.

If you think about it, logically it doesn't makes sense as TAF is configured in the tnsnames configuration file. There is no such file with the thin driver. Although the thin driver can appear to be faster for simple, short queries, the thick driver has serious advantages. For example, the thick driver was used in the recent screaming benchmarks for Oracle iAS.

Regards,

Michael Sale
Author: Oracle9i for Windows(R) 2000 Tips & Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626

-----Original Message-----
Gerardo
Sent: Friday, June 28, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L

I've also heard that thick driver is required for TAF (Transparent Application Failover). Can someone confirm or refute this?

Thanks,
Gerardo

-----Original Message-----
Sent: Friday, June 28, 2002 12: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: Molina, Gerardo
  INET: Gerardo.Molina_at_schwab.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: Michael P Sale
  INET: Michael.Sale_at_oracle.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 - 17:33:21 CDT