The reasoning I had heard was that the developers preferred JDBC Thin
because it was "pure Java". There was no explanation as to why that was
supposed to be better. Also, there were mutterings of vague "bugs" with
JDBC OCI, one of which turned out to be a simple config error in the Oracle
Client layer. One development manager "trumped" me by demanding assurance
that there were no bugs at all in JDBC OCI, a level of certification that
apparently wasn't necessary for "pure Java". The discussion of the relative
merits of thin vs OCI didn't make a dent against the FUD...
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, June 28, 2002 12:48 PM
>
> 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: Suzy Vordos
> INET: lvordos_at_qwest.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).
Received on Fri Jun 28 2002 - 14:31:02 CDT
