You can add or remove connection properties to the list of JDBC Connection Properties.
- Click Add to display a dialog with the list of JDBC properties.
- Select the property you want to add. To remove a property, select it and click Remove. To clear the entire list of connection properties click Clear All.
- From the list of Property Values, select the property value. If the value requires user input, a dialog appears. Default connection properties are supplied for new connection profiles. To override these defaults, click Save Properties. Future definitions use the saved properties.
- Type in a Property Value of no more than 30 characters.
- Click OK to save the JDBC property. If the property already exists in the list, a confirmation dialog appears.
- Click OK to replace the JDBC property in the list.
- Click Reset to Defaults to set the properties to the default values.
- To cache schema, use metadataCache Properties. You must enter a user name and password in order to configure the cache properties. To delete all schema cache files for the connection profile, select Delete Cache Files
- Repeat these steps to add multiple properties.
- To test the connection, click Test Connection. A message box appears stating the ping either succeeded or failed. Click OK to close the message box.
- Select Connect every time the workbench is started to automatically connect to the database when the application is started.
- Click Finish to close the wizard and connect to your database.