Database Schema Provider dialog box

This is a feature of JBuilder Enterprise.

Use this dialog box to establish a connection to a JDBC data source and import the schema of that data source to use as a foundation for your enterprise beans.

To display the Database Schema Provider dialog box,

  1. Right-click either the DataSource node in the structure pane or the EJB Designer pane.
  2. Choose Import Schema From|Database.


Specify A JDBC Datasource

This is a feature of JBuilder Enterprise.

Choose Existing Connection

Clicking the Choose Existing Connection button displays a Select Database dialog that displays existing database connections you might have already defined. If you select one of these existing connections and click OK, the remainder of the fields on the page are automatically filled in (except the Password field) with information about this existing connection.

Schemas And Table Type options

All Schemas

If you check the All Schemas option, the EJB 1.x Entity Bean Modeler will load all schemas the user has rights to for the connection. If you leave All Schemas unchecked, just the schemas with the same name as the username, potentially reducing the time required to make the connection and load the data.

Views

Check Views if you want the views associated with the connection loaded into the imported schema.

Driver

Select the database driver you need to connect to your data source from the list of drivers. The list displays the drivers installed on your machine in black, while all other drivers are displayed in red.

URL

Specify the URL to your data source. The pattern the URL must assume depends on the selected driver. The ... button next to the URL field is enabled in some cases to help you define the URL. What happens when you click the ... button depends on the driver you have chosen.

Username

Specify a user name to access the data source.

Password

Specify a valid password to access the data source.

Extended Properties

Use the extended properties field to define additional connection properties your driver might be able to use. Clicking the ... button displays the Extended Properties dialog box to help you define extended properties.

JNDI Name

Specify the name the JNDI should use to locate the desired data source.