How To Connect Oracle 11g Express Edition to Eclipse

Hello everybody!

Let's see how to connect Oracle 11g Express Edition that we just installed (here is the guide for installaton) to Eclipse.

STEP 1

Download the compatible ojdbc.jar from this link. Put it somewhere on your computer. I placed mine under "C:\ojdbc" folder.



STEP 2

Start Eclipse and go to Windows->Show View-> Data Source Explorer.

Under the "Data Source Explorer" right click on "Database Connections" and select "New".

STEP 3

To create a new connection you first need to select the connection profile type which will be Oracle in our case. Then click "Next".

Now you will need to give more information about the connection you want to setup. Basically it will be something more or less like below. Notice that there is a "Test Connection" button on the bottom part of the window. We will test the connection here after we finish everything.

One last thing you need to do here is selecting the driver you had downloaded before we start. To do that you need to click on that small button just next to "Drivers". I marked it with a purple square in the screenshot below.

Then you will get a new window asking you to select a driver template. You need to select "Oracle Thin Driver" here. After selecting it, now go to the second tab which is "JAR List".

Then find and select ojdbc.jar that you downloaded earlier. After that you can click "OK" and return to the first window.

STEP 4

Time to test everything we did! Click on "Test Connection" button. And hopefully if everything is fine, you will see a success message.

Hope to see you in the next blog post!

Selen