JDataStore Explorer: New JDBC Connection dialog box

This is a feature of JBuilder Professional and Enterprise.

Use the New JDBC Connection dialog box to define a connection to a database server. To open this dialog box in the JDataStore Explorer, choose Tools|Import|Tables and click the New button.

Choose Existing Connection

Opens the Select Database dialog box so you can choose a previous database connection.

Driver

Specify the driver class to use when connecting to the database. Choose from one of the predefined drivers for popular databases, or type in the class name.

URL

Specify the Universal Resource Locator (URL) for the database connection. The format consists of the URL type ("jdbc" for JDBC database access), followed by driver-specific information, separated by colons. The driver-specific information is driver/server dependent. Refer to your driver documentation for more information on this property. It typically includes the driver name followed by the data source name.

For example, the format for a remote JDataStore URL is:

jdbc:borland:dsremote://<hostname>/<filename>

A URL in that format to access the JDataStore file c:\someApp\ecom.jds on the computer mobile.mycompany.com would look like:

jdbc:borland:dsremote://mobile.mycompany.com/c:/someApp/ecom.jds

...

For some database drivers, the button next to the URL is enabled to help you choose a local file. The URL is then set automatically for that file.

Username

Enter the user name authorized to access the server database.

Password

Enter the password of the specified Username for access to the server database. An asterisk (*) appears for each character that you type in this field.

Extended properties

Displays the extended properties used for the connection. To edit these properties, click the Edit button.

...

The button next to Extended properties opens the Extended Properties dialog box, in which you specify addition name/value settings required by the connection.