| Drivers |
Select a driver from the list. If an appropriate driver definition does not exist, you can create one.
- Select
New Driver Definition to create a new driver definition.
- Select
Edit Driver Definition to edit an existing driver definition.
|
| Database Location |
Enter the fully qualified path to the database, or click Browse. You can select an existing database or create a new one. |
| User Name
|
User ID associated with the connection profile.
|
| Password
|
Password for the database server login.
|
| URL
|
Displays the URL address for the profile.
|
| Create Database (If Required) |
Creates a database, if the one you indicated in the Database Location does not exist. |
| Upgrade Database to Current Version |
Select if you are using an older version of a Derby database and want to use the version that matches the driver version. |
| Save Password |
Save the password for this connection profile.
Passwords persist only for the current session. If you do not save your password and exit the workbench, you have to enter it when trying to connect to the database server via the connection profile for the new session. Note: Whether you want to save your password depends on your organization's security policy. Passwords are saved in the workspace metadata in the ServerProfiles.dat file with minimal encryption.
|
| Optional |
- In the
text box, specify connection properties using the KEY=value format, or choose
from the drop-down list, and click
Add.
For example,
DYNAMIC_PREPARE=true.
- Use the
Up,
Down,
Remove, and
Clear All buttons to delete or
change the order of the connection properties.
|
| Test Connection |
Ping the
server and verify that the connection profile is working. |