I've been having similar probs. with the OCI, running under NT with IIS the webserver
crashed. I switched to weblogic type 2, but the problems occatianlly occurs anyway.
How is performance with the type 4 driver, does it support lobs?
-Henric
----- Original Message -----
From: Rod McChesney <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 15, 1999 8:50 PM
Subject: Re: Drivers for Servlet
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
___________________________________________________________________________
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
