Databases Reference
In-Depth Information
The Clear Statement Cache operation clears the callable and prepared statement caches.
The Clear Statement Cache operation is useful when there are
changes in DBMS objects such as stored procedures. Some
exceptions and errors can be caused by deprecated cached
statements.
The Suspend operation disables the data source. Although it leaves the connection state
unchanged in the pool, the applications cannot borrow connections. The Suspend operation
can also be forced. In this case, all connections are closed.
The Resume operation resumes a suspended data source.
The Shutdown operation shuts down the data source. If there are connections in use by the
application, the application operation, in the course of time, will fail and return an error. The
Shutdown operation can be forced. In this case, if the connections are in use, WebLogic will
forcibly close all of them and will shut down the data source.
The Start operation starts a stopped data source.
See also
F
Creating a JDBC data source
F
Creating a multi data source
F
Creating a GridLink data source
Tuning data sources for reliable connections
In the previous recipes, some data sources required by the
DBApp
application were created.
Some default parameter values are not the best option to use out of the box, so in this recipe
the parameters of the GridLink
ds-GridLinkXA
data source will be tuned to avoid unreliable
connections being delivered to the applications.
The changes are generic to the GridLink and Generic data source types and can be applied
to all previously created data sources.
Getting ready
Access the Administration Console to tune the
ds-GridLinkXA
data source parameter.
Make sure the
ds-GridLinkXA
GridLink was created in the previous recipe and that the
Administration Server is running.
Search WWH ::
Custom Search