Working with Databases

Each OracleAS TopLink Mapping Workbench project contains a database. You can create multiple logins for each database. This section describes how to specify database properties and how to log into the database.

Database Properties

Use the Database property sheet to specify information about the database and login(s).

To Specify the Database Properties:

Choose the database object in the Navigator pane. The Database property sheet appears in the Editor pane.

Figure 3-1 Database Property Sheet

Description of the illustration dbprop.gif

Use this table to enter data in each field:

Field	Description
Database Platform	Database platform for the project. Click Change to select a new database. Note: To use Oracle Database 10g, select Oracle9i. To use an Oracle Database prior to version 8i, select Oracle.
Defined Logins	Login used to access the database. Click Add to add a new login, or Remove to delete an existing login.
Login Fields:	To edit these fields, first select a Defined Login.
Driver Class URL	The OracleAS TopLink Mapping Workbench connects to databases through JDBC. Contact your database administrator for information on installing and configuring your driver.
Username	Name required to log into the database.
Password	Password required to log into the database. Note: When exporting deployment XML and Java source (see "Exporting Project Information") the OracleAS TopLink Mapping Workbench writes out this password. Use the OracleAS TopLink Sessions Editor (see Chapter 8, "Understanding the OracleAS TopLink Sessions Editor") to specify password encryption options.
Save Password	Specify whether the OracleAS TopLink Mapping Workbench saves the Password for this Defined Login.
Development Login Deployment Login	The OracleAS TopLink Mapping Workbench supports multiple logins. Select a Defined Login to use for development and/or deployment.

After entering the information, continue with "Logging into the Database".

Logging into the Database

You must log into the database before importing or exporting table information.

To Log into the Database:

Description of the illustration loginbtn.gif

Select the database object in the Navigator pane and click the Login button on the toolbar. The OracleAS TopLink Mapping Workbench logs into the database. The database object in the Navigator pane changes to.

Login icon.
Description of the illustration logindb.gif

You can also right-click on the database object and choose Log In from the pop-up menu or choose Selected > Log In from the menu.

Note:

If you have not defined a login, the system displays a warning message. See "Database Properties" for more information on creating a database login.