how to install an oracle 10g jdbc driver in eclipse IDE?
 

hello nice people,

in advance,sorry if it is already posted or if it is a simple question.

i am (new) using eclipse 3.3 as IDE, under win XP , and oracle 10g as DBMS; i want to access data stored in the database using java programs.

i think i should install the oracle jdbc driver(JAR) in eclipse.

i downloded the class12.jar file,but i do not know how to install it.

please i need some help concerning the installation(jar), and a simple example to connect to my database.

many thanks.

Hi -

A simple google search turned up this:
http://www.ugrad.cs.ubc.ca/~cs304/20...romEclipse.htm

You should be able to find lots of similar links.

The basic steps are:

1. Make sure you can connect to the Oracle database (i.e. that you have a valid logon and password, correct permissions, network connectivity, and the correct environment).

2. Download and install the JDBC driver on the same PC as you're running Eclipse (Linux or Windows - it doesn't matter)

3. Go into Eclipse, Package Explorer, Add external .Jar's, and add your JDBC driver

4. Write a simple "hello world" Java program that uses JDBC and talks to your database
For example:
http://www.macs.hw.ac.uk/cs/online/3ni3/5/8.htm
... or ...
http://www.oracle.com/technology/sam...sic/basic.html
... or ...
http://java.sun.com/docs/books/tutor.../complete.html

5. Run your program (presumably from Eclipse, or from a command prompt)

'Hope that helps .. PSM

hello again,

thank you for the halp.

i did already , i just added the jar to eclipse, i do not know that it was simple; and now i can connect to the database.

thanks again.