understood. :) -----Original Message----- [mailto:[EMAIL PROTECTED]] Sent: Friday, June 28, 2002 11:58 PM To: Multiple recipients of list ORACLE-L
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:[EMAIL PROTECTED] | > ---------------------------------------------- > > -----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: [EMAIL PROTECTED] > >> > >>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
