Defining Database Connections

To define a new database connection:

From the main menu, choose File New, or right-click and choose New . The New Gallery opens.
In the Categories list, expand General and select Connections.
In the Items list, double-click Database Connection to open the Create Connection wizard.
If the Welcome page is displayed, click N ext.
On the Type page, enter a name for the connection and select a type from the dropdown list. The type you select here determines the information you'll enter later.
Click Next.
On the Authentication page, enter a user name, a password, and, optionally, a role. Remember that this user must have sufficient privileges to perform the tasks you wish to perform against the online database, including creating, editing, or dropping tables, views, and other objects. Be sure to provide a user name with sufficient privileges.
Click Next.
On the Connection page, enter the connection details as requested, which vary depending upon the connection type. Note that when you are working with third-party JDBC drivers, you can register a new driver directly from this page.
Click Next.
On the Test page, click Test Connection . The Testing Connection Status dialog appears (this may be very brief for a local database) and JDeveloper checks the connection using the information you provided. If the test succeeds, a success message appears in the status text area. If the test does not succeed, an error appears. Click Back and change any previously entered information as needed to correct the error, or check the error content to determine other possible sources of the error.
Click Cancel on the Testing Connection Status dialog to cancel the connection test if necessary.
When the test succeeds, click Finish . The Create Connection wizard closes. The new connection name appears under the Database node in the Connections Navigator. Alternately, to bypass the New Gallery, select View Connection Navigator, right-click Database, and choose New Connection.

Context Menu Shortcut:

In the Connections Navigator, right-click the Database and select New Database Connection

Note: Database connections provide access to online database objects. If you wish to view, create, or change offline database definitions, see Working with Offline Database Definitions.