Database References Node

This section covers the following topics:

About Database References

Database references are used to run scripts.

They associate zero or more Server Explorer connections with a project. There can be, at most, one database reference which is used as the default for the project. You can delete the default database reference and have no default database reference.

A database reference is not actually a connection, but it contains the connection information that is necessary to establish the connection.

Passwords are not stored in the database reference. When a script is run, the password is taken from the Server Explorer connection that corresponds to the database reference, if one exists. If there is no existing connection, one is created. You will be prompted for the password, if necessary. After that, the password is remembered.

If the corresponding connection in Server Explorer is deleted, Oracle Database Project continues to work because the database reference provides all the information necessary to establish the connection. If an Oracle Database Project is moved to a different machine, it continues to work. Also, if the corresponding connection in Server Explorer is modified, the changes are not reflected in the database reference.

How Database References Node Work

The Oracle Database Project contains a special project item called the Database References project item. This is the parent node for the Server Explorer connections associated with the project. You cannot delete or edit this item.

To perform actions on a Database Project References node, right-click the node and from the menu choose the appropriate command. To view the node's properties, select the node and/or click Properties in the nodes menu.

Menu Options

Menu Option Description

New Database Reference

Displays the Oracle Database Project Add Database Reference Dialog, which allows you to associate a new connection with the project. If there is no Server Explorer connection, the Connection dialog box appears instead. See Adding Database References

Properties

Displays the properties window.

Properties

Property Name

Description

Name

Database References.