Database References Folder
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 Version 2 continues to work because the database reference provides all the information necessary to establish the connection. If an Oracle Database Project Version 2 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 Folder Works
The Oracle Database Project Version 2 contains a special project item called the Database References Folder. This is the parent folder for the Server Explorer connections associated with the project. You cannot delete or edit this folder.
To perform actions on a Database Project References Folder, right-click the folder and from the menu choose the appropriate command. To view the folder's properties, select the folder and/or click Properties in the folder's 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. |
|
Properties |
Displays the properties window. |