Ricjard is correct. jdbc thin client does not allow transparent fail over. The thick client reads a tnsnames.ora file which is where the fail over actually occurs. There are multiple server names for the same service name. If the first server in the search is down, it falls through to the next server.
jdbc is a straight connection to a single database. No read of tnsnames.ora. Pete --- "Ji, Richard" <[EMAIL PROTECTED]> wrote: > Dennis, > > One thing you can't do with Thin driver is > Transparent Application Failover > which is what Peter wants to do I believe. > > Richard > > -----Original Message----- > Sent: Wednesday, August 28, 2002 1:00 PM > To: Multiple recipients of list ORACLE-L > > > Peter - A couple of issues come to mind: > > 1) So you are saying that connection failover is > your prime interest at this > stage? I was thinking database failover when I saw > your question. > 2) So what is wrong with thin client? At my site we > are tending to go with > thin so we don't have to install SQL*Net client on > every app server. That > was what attracted us to Java in the first place. > Everything I've seen says > that for some applications thin has better > performance and for others OCI is > better. Personally I like having options. > 3) How committed to Oracle is your site? If you have > a heavy Oracle > commitment, you may be able to stick it to IBM's > attitude. Traditionally IBM > has had an attitude of "use all of our stuff". This > goes back to when they > were the Microsoft of the computer industry. Nobody > worries about IBM > monopolizing the industry today. Obviously they are > learning to shed that > parochial attitude in order to succeed today. I'll > bet if you complained up > the IBM management chain about this person's > attitude you might see a change > for the better. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Tuesday, August 27, 2002 5:49 PM > To: Multiple recipients of list ORACLE-L > > > Dennis, > > This is a auite of products. The prime offender is > WebSphere, an IBM product. The IBM consultants have > been particularly difficult to deal with. According > to them, nothing Oracle ever produced works. > > The project specifications call for transparent fail > over which is possible using Oracle's thick client. > Unfortunately, WebSphere does not seem to be able to > use anything but jdbc thin client. > > If we can't get this to work, we will likely go to > something like Veritas Cluster Server. Replication > provided a solution that had already paid for. > > > --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > > Peter - Have you looked at Oracle Standby Server? > > Which App server are you > > using? Most of them claim to help you with this. > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > > > -----Original Message----- > > Sent: Tuesday, August 27, 2002 3:38 PM > > To: Multiple recipients of list ORACLE-L > > > > > > We are looking at fail over options for databases > in > > a > > 7x24 e-commerce environment. > > > > Currently, we are using advanced replication. It > > works but it is labor intensive. We have also > > discovered that the application can only use jdbc > > rather than the Oracle thick client. In essence, > > this > > replication is now manual fail over. > > > > Would someone who has made java and the thick > client > > work provide some pointers to getting it to work? > > > > > > > Thanks, > > > > > > > > ===== > > Pete Barnett > > Lead Database Administrator > > The Regence Group > > [EMAIL PROTECTED] > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Finance - Get real-time stock quotes > > http://finance.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Peter Barnett > > 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: DENNIS WILLIAMS > > 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). > > > ===== > Pete Barnett > Lead Database Administrator > The Regence Group > [EMAIL PROTECTED] > > __________________________________________________ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Peter Barnett > 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 > === message truncated === ===== Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett 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).
