Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: WebLogic, Oracle JDBC related

RE: WebLogic, Oracle JDBC related

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Fri, 28 Jun 2002 05:53:21 -0800
Message-ID: <F001.0048B5E9.20020628055321@fatcity.com>


Tim,
I really do not know why JDBC 'thin' was used.  

They have a couple of App. Servers connecting to a cluster (HACMP) of four database servers. Using OCI driver is in the Vendor's plan (in the next release ;)

I will let our DBA team know about the quirks with 'thin' driver.

Thanks.

-----Original Message-----

Sent: Friday, June 28, 2002 1:03 AM
To: Multiple recipients of list ORACLE-L

Kirti,

Taking another tack...

Why would they want to use JDBC Thin? Typically, the "thin" driver is intended for environments where the "Oracle Client" is not expected to be installed (i.e. applets on the browser) and the JDBC "OCI" driver for environments where the "Oracle Client" is expected to be installed (i.e. servlets on the app server).

JDBC Thin has some nasty quirks beyond not populating V$SESSION properly. For example, if a database object or a cursor should go invalid for any reason, a "thin" driver cannot handle the problem as an "OCI" driver can...

Just some food for thought...

-Tim

-
--

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 - 08:53:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US