Henric Larsson wrote:
>
> 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?
It's adequate for our purposes. I cache almost everything in memory
anyway, so we don't have that many database hits. We steer completely
away from LONG columns -- JDBC handles them, but I can't comment from
personal experience.
Rod McChesney, Korobra Corporation
> -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
___________________________________________________________________________
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
