Setup the Database Connection in JDeveloper 11g

In this post we will see steps for creating new Database connection in JDeveloper 11g.

Refer my previews post for JDeveloper Installation Steps for install jdev 11g and Oracle XE Database installation for do XE database setup in our local machine.

Steps to create database connection in JDeveloper:

1. Open JDeveloper and select View > Database > Database Navigator.

1. Select IDE Connections > Right-click and choose New Connection.

2. In the Create Database Connection window, specify the field parameters:

a. Connection Name: <any name>

b. Connection Type: Oracle JDBC

c. Username: HR

d. Password: ******

e. Role: blank

f. Save Password checkbox – checked

g. Driver: thin

h. Hostname: localhost or 127.0.0.1 (as this is a local install)

i. JDBC Port: 1521

j. SID: XE

3. Click on the Test Connection button. This will display a success message.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s