Hi
Why you want to use thin driver when you are using Oracle 8.0.4 bec's
oracle 8i supports jdbc.
import oracle.jdbc.driver.*;
give the following conn in the servlet:
// Loading the data base
Class.foName("oracle.jdbc.driver.OracleDriver");
// Connecting to db
Connection conn =
DriverManager.getConnection("jdbc:oracle:oci8:@", "username",
"passwd");
Have fun
Neeraja
-----Original Message-----
From: John Larson <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Monday, April 12, 1999 4:41 PM
Subject: JDBC Connection Question
>Hi,
>
>I have a question about DB connections. My testing doesn't match what I
>read in a couple books, so I am confused...
>
>Background/Environment:
>I am using Oracle 8.0.4 and the Oracle thin driver. My servlet is using
>the SingleThread implementation and I create a connection to the DB in
>the Init method of the servlet. The servlet engine is JRun 2.3.
>
>Connection con; //Declared within the servlet class before the init
>method
>
>//In init
>String url = "jdbc:oracle:thin:@ip:port:dbname";
> con = DriverManager.getConnection(url, "db","pw");
>
>After I run the servlet the first time, Oracle reports 7
>connections to my Servlet! I only create one connection in the Init
>block. My
>servlet does declare two different result sets and two prepared
>statements, all using the "con" connection object. They are not
>explicitly closed.
>
>If I run the servlet several more times, there are still 7 connections,
>so it appears that they are being reused.
>
>Question:
>How did I get more than 1 connection to the DB?
>
>Thank you for your time and assistance,
>John
>
>___________________________________________________________________________
>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
