Connection Profile JDBC or Driver Connection Properties

Edit the properties of a JDBC connection profile.

Property Description
Drivers Select a driver from the list. If an appropriate driver definition does not exist, you can create one.
  • Select New Driver Definition button New Driver Definition to create a new driver definition.
  • Select Edit Driver Definition button Edit Driver Definition to edit an existing driver definition.

If deploying a web service to EAServer or Service Container, you need to add the JAR to the lib\ext directory in the EAServer installation.

Database Database associated with the connection profile.
URL URL address for the profile. In most cases, if you selected a provided driver, you do not need to modify the value in this field.
User Name User ID associated with the connection profile.
Password Password for the database server login.
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
  1. 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.

  2. 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.
Related tasks
Editing Connection Profile Properties
Related reference
Connection Profile Common Properties
Connection Profile Default Schema Filter Properties
Connection Profile Default Stored Procedure Filter Properties
Connection Profile Default Table Filter Properties
Connection Profile Derby JDBC Connection Properties
Connection Profile Version Properties