Defining Database Connections

To define a new database connection:

From the main menu, choose File | N ew, 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.
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 . 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.

The T est Connection button becomes the C ancel Test button during testing. Click Cancel Test 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 Connection Navigator. Alternately, to bypass the New Gallery, select View | Connection Navigator, right-click Database , and choose New 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.