The OCI driver frequently stops working for no apparent reason.
This was on Solaris 2.6, Oracle 8, NES 3.5.1, JRun 2.2.1 using the
JavaExchange connection pool. Sometimes the symptom is a hang,
sometimes an actual DB exception, but in either case the symptoms go
away after switching to the thin driver.
Rod
Henric Larsson wrote:
>
> What do you mean by flaky ?
>
> -Henric
>
> ----- Original Message -----
> From: Rod McChesney <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, March 12, 1999 9:13 PM
> Subject: Re: Drivers for Servlet
>
> Not only that, the OCI drivers are flaky. Stick with the thin drivers.
>
> Rod McChesney, Korobra Corporation
>
> Patrick McGovern wrote:
> >
> > I've been using the thin drivers because it requires almost zero setup. With the
>OCI's you have to install SQL-Net on each machine.
> >
> > Patrick
> >
> > >>> Sreenivasa R V <[EMAIL PROTECTED]> 03/12 11:58 AM >>>
> > Hi Madhu,
> > We are developing an Intranet application using servlets.
> > Our configuration is as follows:
> > Servlet Engine: Jrun2.3
> > Web Server: Netscape Enterprise Server
> > Browsers : Netscape 4.0 and above or IE 4 and above.
> > Database: Oracle8.0
> > Both Web Server and Database will be residing on Solaris 2.6
> >
> > We are not able to decide whether we should go for Type 2(OCI ) driver or
> > Type 4 driver. We donot have any prior experience on both of these drivers. I've
> > worked only with JDBC-ODBC bridge. Can u please give us some details on the
> > performance and advantages-disadvantages for these 2 drivers.
> >
> > Regards,
> > RVS
> >
> > "Gullanki, Madhu" wrote:
> >
> > > Hi Nimesh,
> > > The best drivers to use for Oracle from servlets is Oracle JDBC drivers.
> > > They are available in 2 types.
> > > 1) Thin drivers 2) OCI drivers. You can download them for free from
> > > Oracle's web site and also you can find the instructions how to use them
> > > right there. I used OCI drivers. They worked great.
> > >
> > > The steps to make connection are:
> > > DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> > > DriverManager.getConnection("jdbc:oracle:oci7:@MyDatabase","userid","passwor
> > > d");
> > >
> > > --
> > > MG
> > >
> > > > -----Original Message-----
> > > > From: Kenia Nimesh [SMTP:[EMAIL PROTECTED]]
> > > > Sent: Friday, March 05, 1999 11:01 PM
> > > > To: [EMAIL PROTECTED]
> > > > Subject: Drivers for Servlet
> > > >
> > > > I have developed an servlet application.Until now I was using jdbc.odbc
> > > > drivers with MS Access as my database.Now I want to launch my
> > > > application.On the web server Oracle is the database.
> > > > I wanted to know what drivers should I be using??Where's the driver
> > > > availability??
> > > > I have heard something like thin drivers and OCI drivers.. What are they??
> > > >
> > > > It would also be helpful if you could give some steps for making the
> > > > connection.
> > > >
> > > > Thankyou
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > > ___________________________________________________________________________
> > > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> > > of the message "signoff SERVLET-INTEREST".
> > >
> > > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > > Resources: http://java.sun.com/products/servlet/external-resources.html
> > > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
> > ___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
> > ___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
