Re: JDBC with oracle

[Lindsay, William (USPC.PCT.Hopewell)]

We use the the thin client driver without installing Oracle, we just copy classes12.zip to the classpath.

-----Original Message-----
From: Margaret Fisk [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:08 PM
To: [EMAIL PROTECTED]
Subject: Re: JDBC with oracle

Just an additional note...

 

You must install the Oracle client on the machine you are using to run the servlets or map a permanent drive to a location where the Oracle client is installed.

 

Margaret

-----Original Message-----
From: Dahnke, Eric [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 9:14 AM
To: [EMAIL PROTECTED]
Subject: Re: JDBC with oracle

1. the drivers come with your oracle installation. on my windoze box they are here: /oracle/ora81/jdbc/lib/classes12.zip.

2. put the classes12.jar file in your classpath. use a connection string as follows in your code (Connection Conn = DriverManager.getConnection "jdbc:oracle:thin:@10.1.1.15:1521:nxtdb","NXTDB01","passwd!"

 

 

-----Original Message-----
From: tejas patel [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:08 PM
To: [EMAIL PROTECTED]
Subject: JDBC with oracle

hello all,

I need some help regarding JDBC. At present I am using MSAccess as a database and sun.jdbc.odbc.JdbcOdbcDriver driver. We are migrating to Oracle database. now I need to change my servlet's code in order to work with oracle database

My questions are

1. where can I download oracle.jdbc.driver.OracleDriver

2. What I need to configure in order to connect to oracle database. Do i need to change my classpath or I need to download addition library's.

Thanks

Tejas

---

Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax