How To Connect To a Database Using Eclipse IDE

Step 1

Open Eclipse IDE and Select Database Perspective (Windows >> Open Perspective >> Other).

Step 2

Create Connection Profile: Here we will create profile for connecting to DB.

Method 1: Right click on “Database Connections” and click New.

Method 2: Click on “New Connection Profile” button in “Data Source Explorer” view.

Step 3:

Select DB (Oracle in this case) to connect from popup window. And provide connection profile name (JBT in this case).

Click Next. In next screen provide DB connection details as shown below.

Once provide you can check if connection to DB is successful or not by clicking “Test Connection” button as shown above.
If everything is fine it should show Ping Succeed popup window as below. If not then check connection related details.

After providing the connection related details click Finish. If everything is fine then a new Connection profile named JBT will be created in Data Source Explorer view