You can set global preferences for whether database connections
that are invalid are automatically detected and reconnected.
About this task
Connections that are detected as being invalid are displayed
with a different icon in the Data Source Explorer.
Procedure
- In the Preferences window: Click and expand the Data
Management and Connectivity nodes.
- Click Connection Management.
- Specify options, as described.
You can select
to automatically poll all connected databases at regular intervals
to determine if they are still valid.
You can select to have
the workbench automatically reconnect to databases that are determined
to be invalid, or to prompt for reconnection.
Results
The options you selected are applied.