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: Ji, Richard <Richard.Ji_at_MobileSpring.com>
Date: Fri, 28 Jun 2002 13:49:27 -0800
Message-ID: <F001.0048BE24.20020628134927@fatcity.com> 





Just curious, why recode just to switch drivers?
You can put the jdbc driver class and url in a .properties file
and load it from there.  And keep url for both oci and thin in
there and just comment out the one you don't use.



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


Sent: Friday, June 28, 2002 4:38 PM


To: Multiple recipients of list ORACLE-L




That is correct, at least as far as 8.1.7 is concerned.  We had to
recode our applications to use the jdbc:oci8 driver instead of
jdbc:thin.



Brian





| Brian McGraw /* DBA */  Infinity Insurance |
| mailto:Brian.McGraw_at_Infinity-Insurance.com |





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


Gerardo


Sent: Friday, June 28, 2002 3: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: Brian McGraw
  INET: brian.mcgraw_at_infinity-insurance.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:49:27 CDT












Original text of this message













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