Just a poor choice of words on my part...
- Original Message -----
Date: Friday, June 28, 2002 4:49 pm
> 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
> seemsto
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
Received on Fri Jun 28 2002 - 22:58:18 CDT
