Re: WebLogic, Oracle JDBC related

Whoops! Sorry for the brain-dead response...

I meant to say that it is *controlled* entirely from the client. Obviously, in order to fail-over session state from one instance to another, there is quite a lot going on in the server, too... :-)

It's still an hour until 5:00pm (in this time zone), but it is Friday, so I think it's OK to start drinking now...

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, June 28, 2002 3:58 PM

> True. TAF is implemented entirely in the client...
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, June 28, 2002 2:18 PM
>
>
> > 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: Tim Gorman
> INET: Tim_at_SageLogix.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: Tim Gorman
  INET: Tim_at_SageLogix.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).