Skip navigation.
Downloads | Product Documentation | Support

Administration Console Online Help

# JDBC Data Source: Control

Buttons Column Display Related Tasks Related Topics

Use this page to manually control each instance of this JDBC data source.

#### Buttons

Name | Description
--- | ---
Shrink | Shrinks the database connection pool in the data source to the higher of the current number of reserved connections or the initial size of the connection pool. This is a privileged operation that can only be invoked by a an authorized user. MBean Attribute: `JDBCDataSourceRuntimeMBean.shrink`
Reset | Resets the connection pool in the data source by shutting down and reestablishing all database connections in the pool. This method should be used when the data source is in a bad state and needs to be reinitialized. This is a privileged operation that can only be invoked by a an authorized user. MBean Attribute: `JDBCDataSourceRuntimeMBean.reset`
Clear Statement Cache | For each connection in the connection pool, clears the statement cache of Prepared and Callable Statements. MBean Attribute: `JDBCDataSourceRuntimeMBean.clearStatementCache`
Suspend | Disables the data source, suspending all operations on connections from the data source until the data source is re-enabled. This is a privileged operation that can only be invoked by a an authorized user. MBean Attribute: `JDBCDataSourceRuntimeMBean.suspend`
Force Suspend | Forcibly disables the data source, suspending all operations on connections from the data source until the data source is re-enabled. All current connection users are forcibly disconnected. All connections currently in use are closed and recreated. This is a privileged operation that can only be invoked by a an authorized user. MBean Attribute: `JDBCDataSourceRuntimeMBean.forceSuspend`
Shut Down | Shuts down the data source. If any connections from the data source are currently in use, the operation will fail. This is a privileged operation that can only be invoked by a an authorized user. MBean Attribute: `JDBCDataSourceRuntimeMBean.shutdown`
Force Shut Down | Forcibly shuts down the data source. All current connection users are forcibly disconnected. This is a privileged operation that can only be invoked by a an authorized user. MBean Attribute: `JDBCDataSourceRuntimeMBean.forceShutdown`
Resume | Restores all access to and operations on a data source that has been suspended (marked as disabled). This is a privileged operation that can only be invoked by a an authorized user. MBean Attribute: `JDBCDataSourceRuntimeMBean.resume`

#### Column Display

You can show fewer or additional data points on this page by expanding Customize this table and modifying the Column Display list. Each data point displays in its own table column.

The following table lists all of the data points that you can display in columns on this page.

Name | Description
--- | ---
Server Name | The server on which the data source instance is deployed.
State | The current state of the data source. Possible states are: `Running` - the data source is enabled (deployed and not SUSPENDED). This is the normal state of the data source. `Suspended` - the data source has been manually disabled. `Shutdown` - the data source is shutdown and all database connections have been closed. `Unhealthy` - all connections are unavailable (not because they are in use). This state occurs if the database server is unavailable when the data source is created (creation retry must be enabled) or if all connections have failed connection tests (on creation, on reserve, or periodic testing). `Unknown` - the data source state is unknown. MBean Attribute: `JDBCDataSourceRuntimeMBean.State`
Status of Last Action | Status information related to this task.

Related Tasks

- Reset connections in a JDBC data source
- Shrink the connection pool in a JDBC data source
- Clear the statement cache in a JDBC data source
- Suspend JDBC data sources
- Resume suspended JDBC data sources

Related Topics

- Configuring and Managing WebLogic JDBC