The WebLogic JDBC subsystem can be controlled when needed. A WebLogic Administrator can start, stop, shrink, pause, suspend, and reset the data source on demand. The statement cache can also be cleared if needed.
In this recipe, the ds-nonXA data source will be used as an example.
The JDBC operations use the Administration Console, so make sure the Administration Server is running.
To control the data source operations, carry out the following steps:
Access the Administration Console with your web browser at
http://adminhost.domain.local:7001/console.Click on the plus sign to open the Services tree on the left, and then click on Data Sources.
Click on the
ds-nonXAlink to open the data source and then click on the Control tab.Select the checkbox from
ds-nonXAand click on the button of the desired operation: Shrink, Reset, Clear Statement Cache, Suspend, Resume, Shutdown, or Start.