Edit Multiple Database Connections

There are situation when you may need to change one or several connection settings for multiple database connections at the same time. Instead of doing this one connection at a time, the connections editor come in handy.

To open the connections editor select multiple database connections in the Databases tab, right-click and chose Edit Multiple Connections.

The connections editor will show only those fields that are commonly available for the database connections being edited.

The window has the following columns:

• Update: Indicates if the value is edited. You may manually uncheck this to indicate the setting should not be updated
• Value: Enter the new value here. Once the field is being edited its background will change and the Update box is checked.

Changing the database driver

The Driver (JDBC) setting is the main setting that controls what properties are available for a database connection. Once Driver (JDBC) has been edited its Update checkbox cannot be unchecked.