In the Administration Console, you can manually suspend individual
instances of a data source. When you suspend a data source, applications
can no longer get a database connection from the data source. For
connections that are already reserved by an application, behavior
depends on the type of suspension that you select:
- Suspend - which marks the data source as disabled and blocks any
new connection requests. If there are any reserved connections, the
operation will wait for InactiveTimeout seconds
if configured, otherwise the operation waits 60 seconds before
suspending all connections. If successful, the health state is set to
Suspended. All connections are preserved
exactly as they were before the data source was suspended. If you
Resume, clients that had reserved a connection
before the data source was suspended can continue exactly where they
left off.
- Force Suspend - which marks the data source as disabled. All pool
connections are destroyed and any subsequent attempt to use reserved
connections fail. Any transactions on the connections that are closed
are rolled back. If successful, the health state is set to
Suspended. If you
Resume, clients must reserve new connections to
proceed.
To suspend a JDBC data source: