Runtime MBean that represents a UCP JDBC data source.
| Since | 12.2.1.0.0 | ||
| Fully Qualified Interface Name | If you use the getMBeanInfo operation in MBeanTypeServiceMBean, supply the following value as this MBean's fully qualified interface name:
weblogic.management.runtime.JDBCUCPDataSourceRuntimeMBean
|
||
| Factory Methods | No factory methods. Instances of this MBean are created automatically. | ||
| Access Points Inherited from ComponentRuntimeMBean |
Because this MBean extends or implements ComponentRuntimeMBean, you can also access this MBean by retrieving ComponentRuntimeMBeans. The following attributes contain ComponentRuntimeMBeans and its subtypes:
|
||
| Access Points Inherited from JDBCDataSourceRuntimeMBean |
Because this MBean extends or implements JDBCDataSourceRuntimeMBean, you can also access this MBean by retrieving JDBCDataSourceRuntimeMBeans. The following attributes contain JDBCDataSourceRuntimeMBeans and its subtypes:
|
||
| Access Points Inherited from RuntimeMBean |
Because this MBean extends or implements RuntimeMBean, you can also access this MBean by retrieving RuntimeMBeans. The following attributes contain RuntimeMBeans and its subtypes:
|
This section describes attributes that provide access to other MBeans.
Gets the JDBCDriverRuntimeMBean associated with this data source.
| Factory Methods | No explicit creator method. The child shares the lifecycle of its parent. |
| Privileges | Read only |
| Type | JDBCDriverRuntimeMBean |
| Relationship type: | Containment. |
Get the statistics for replay only if the datasource is using an Oracle replay driver for 12.1.0.2 and later. Otherwise, null is returned. The statistics are a snapshort. To update the snapshot, call refreshStatistics() on the mbean.
| Factory Methods | No explicit creator method. The child shares the lifecycle of its parent. |
| Privileges | Read only |
| Type | JDBCReplayStatisticsRuntimeMBean |
| Relationship type: | Containment. |
Get the last datasource Task
| Factory Methods | No explicit creator method. The child shares the lifecycle of its parent. |
| Privileges | Read only |
| Type | JDBCDataSourceTaskRuntimeMBean |
| Relationship type: | Containment. |
Get preexisting datasource Tasks
| Factory Methods | No explicit creator method. The child shares the lifecycle of its parent. |
| Privileges | Read only |
| Type | JDBCDataSourceTaskRuntimeMBean[] |
| Relationship type: | Containment. |
Get the runtime mbeans for all work managers defined in this component
| Factory Methods | No explicit creator method. The child shares the lifecycle of its parent. |
| Privileges | Read only |
| Type | WorkManagerRuntimeMBean[] |
| Relationship type: | Containment. |
This section describes the following attributes:
Average number of active connections in this instance of the data source.
Active connections are connections in use by an application. This value is only valid if the resource is configured to allow shrinking.
| Privileges | Read only |
| Type | int |
The number of connections currently in use by applications.
| Privileges | Read only |
| Type | int |
Highest number of active database connections in this instance of the data source since the data source was instantiated.
Active connections are connections in use by an application.
| Privileges | Read only |
| Type | int |
Private property that disables caching in proxies.
| Privileges | Read only |
| Type | boolean |
The cumulative total number of commit outcome query retries conducted before resolving the outcome or exceeding the retry seconds in this data source since the data source was deployed.
| Available Since | Release 12.2.1.3.0 |
| Privileges | Read only |
| Type | long |
The average amount of time, in milliseconds, that it takes to create a physical connection to the database.
The value is calculated as summary of all times to connect divided by the total number of connections.
| Privileges | Read only |
| Type | int |
The cumulative total number of database connections created in this data source since the data source was deployed.
| Privileges | Read only |
| Type | int |
The current count of JDBC connections in the connection pool in the data source.
| Privileges | Read only |
| Type | int |
Highest number of database connections available or in use (current capacity) in this instance of the data source since the data source was deployed.
| Privileges | Read only |
| Type | int |
The product name of the database that this data source is connected to.
| Privileges | Read only |
| Type | java.lang.String |
The product version of the database that this data source is connected to.
| Privileges | Read only |
| Type | java.lang.String |
The current deployment state of the module.
A module can be in one and only one of the following states. State can be changed via deployment or administrator console.
UNPREPARED. State indicating at this module is neither prepared or active.
PREPARED. State indicating at this module of this application is prepared, but not active. The classes have been loaded and the module has been validated.
ACTIVATED. State indicating at this module is currently active.
NEW. State indicating this module has just been created and is being initialized.
For more information, see:
| Privileges | Read only |
| Type | int |
The product name of the JDBC driver that this data source is configured to use.
| Privileges | Read only |
| Type | java.lang.String |
The version of the JDBC driver that this data source is configured to use.
| Privileges | Read only |
| Type | java.lang.String |
Indicates whether the data source is enabled or disabled:
true
if the data source is enabled.
false
if the data source is disabled.
| Privileges | Read only |
| Type | boolean |
The number of repurpose errors that have occurred since the datasource was deployed.
| Available Since | Release 12.2.1.3.0 |
| Privileges | Read only |
| Type | long |
The cumulative, running count of requests for a connection from this data source that could not be fulfilled.
| Privileges | Read only |
| Type | long |
The number of times that the data source attempted to refresh a database connection and failed.
Failures may occur when the database is unavailable or when the network connection to the database is interrupted.
| Privileges | Read only |
| Type | int |
Highest number of database connections that were idle and available to be used by an application at any time in this instance of the data source since the data source was deployed.
| Privileges | Read only |
| Type | int |
Highest number of database connections that were in use by applications or being tested by the system in this instance of the data source since the data source was deployed.
| Available Since | Release 12.2.1.3.0 |
| Privileges | Read only |
| Type | int |
The number of leaked connections. A leaked connection is a
connection that was reserved from the data source but was not
returned to the data source by calling close().
| Privileges | Read only |
| Type | int |
Returns the MBean info for this MBean.
Deprecated.
| Privileges | Read only |
| Type | javax.management.MBeanInfo |
Returns the identifier for this Component. The identifier is unique within the application.
Typical modules will use the URI for their id. Web Modules will return their context-root since the web-uri may not be unique within an EAR.
| Privileges | Read only |
| Type | java.lang.String |
The name of this configuration. WebLogic Server uses an MBean to implement and persist the configuration.
| Privileges | Read only |
| Type | java.lang.String |
The number of database connections that are currently idle and available to be used by applications in this instance of the data source.
| Privileges | Read only |
| Type | int |
The number of connections currently in use by applications or being tested in this instance of the data source.
| Privileges | Read only |
| Type | int |
Returns the ObjectName under which this MBean is registered in the MBean server.
Deprecated.
| Privileges | Read only |
| Type | weblogic.management.WebLogicObjectName |
Return the immediate parent for this MBean
| Privileges | Read/Write |
| Type |
The cumulative, running count of the number of times that the statement cache was accessed.
| Privileges | Read only |
| Type | long |
The cumulative, running count of the number of statements added to the statement cache.
Each connection in the connection pool has its own cache of statements. This number is the sum of the number of statements added to the caches for all connections in the connection pool.
| Privileges | Read only |
| Type | long |
The number of prepared and callable statements currently cached in the statement cache.
Each connection in the connection pool has its own cache of statements. This number is the sum of the number of statements in the caches for all connections in the connection pool.
| Privileges | Read only |
| Type | int |
The cumulative, running count of statements discarded from the cache.
Each connection in the connection pool has its own cache of statements. This number is the sum of the number of statements that were discarded from the caches for all connections in the connection pool.
| Privileges | Read only |
| Type | long |
The cumulative, running count of the number of times that statements from the cache were used.
| Privileges | Read only |
| Type | int |
The number of times that a statement request could not be satisfied with a statement from the cache.
| Privileges | Read only |
| Type | int |
The list of properties for a data source that are passed to the JDBC driver when creating database connections.
This is a privileged operation that can only be invoked by an authorized user.
| Privileges | Read only |
| Type | java.util.Properties |
Returns false if the MBean represented by this object has been unregistered.
Deprecated.
| Privileges | Read only |
| Type | boolean |
The number of times connections have been repurposed since the datasource was deployed.
| Available Since | Release 12.2.1.3.0 |
| Privileges | Read only |
| Type | long |
The cumulative, running count of requests for a connection from this data source.
| Privileges | Read only |
| Type | long |
The cumulative total number of commit outcomes successfully resolved as committed in this data source since the data source was deployed. This does not refer to the number of outcome query retries used to resolve the outcomes.
| Available Since | Release 12.2.1.3.0 |
| Privileges | Read only |
| Type | long |
The cumulative total number of commit outcomes successfully resolved as not committed in this data source since the data source was deployed. This does not refer to the number of outcome query retries used to resolve the outcomes.
| Available Since | Release 12.2.1.3.0 |
| Privileges | Read only |
| Type | long |
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. This state includes conditions when the database server is
not available and the data source is created (creation retry must
be enabled) or when all connections have failed connection tests
(on creation, on reserve, or periodic testing).
Suspended
- the data source has been disabled.
Shutdown
- the data source is shutdown and all database connections have been closed.
Overloaded
- all resources in pool are in use.
Unknown
- the data source state is unknown.
| Privileges | Read only |
| Type | java.lang.String |
Returns the type of the MBean.
| Privileges | Read only |
| Type | java.lang.String |
The cumulative total number of commit outcomes unsuccessfully resolved in this data source since the data source was deployed. This does not refer to the number of outcome query retries used to resolve the outcomes.
| Available Since | Release 12.2.1.3.0 |
| Privileges | Read only |
| Type | long |
The driver class name of the JDBC driver used to create database connections.
| Privileges | Read only |
| Type | java.lang.String |
The number of connection requests waiting for a database connection.
| Privileges | Read only |
| Type | int |
The cumulative, running count of requests for a connection from this data source that had to wait before getting a connection and eventually failed to get a connection.
Waiting connection requests can fail for a variety of reasons, including waiting for longer than the ConnectionReserveTimeoutSeconds.
| Privileges | Read only |
| Type | long |
Highest number of application requests concurrently waiting for a connection from this instance of the data source.
| Privileges | Read only |
| Type | int |
The cumulative, running count of requests for a connection from this data source that had to wait before getting a connection and eventually succeeded in getting a connection.
| Privileges | Read only |
| Type | long |
The cumulative, running count of requests for a connection from this data source that had to wait before getting a connection, including those that eventually got a connection and those that did not get a connection.
| Privileges | Read only |
| Type | long |
The highest number of seconds that an application waited for a connection (the longest connection reserve wait time) from this instance of the connection pool since the connection pool was instantiated.
This value is updated when a completed
getConnection request takes longer to return a
connection than any previous request.
| Privileges | Read only |
| Type | int |
This section describes the following operations:
For each connection in the connection pool, clears the statement cache of Prepared and Callable Statements.
| Operation Name | "clearStatementCache" |
| Parameters | null |
| Signature | null |
| Returns |
void
|
| Exceptions |
|
Prints out information about all the connections in the connection pool in the data source.
| Operation Name | "dumpPool" |
| Parameters | null |
| Signature | null |
| Returns |
void
|
| Exceptions |
|
Prints out profile information about the data source.
| Operation Name | "dumpPoolProfile" |
| Parameters | null |
| Signature | null |
| Returns |
void
|
| Exceptions |
|
Forcefully shuts down a data source that has a health state of
Running, including forcing the disconnection of all
current connection users.
If successful, the health state is set to
Shutdown.
This is a privileged operation that can only be invoked by an authorized user.
| Operation Name | "forceShutdown" |
| Parameters | null |
| Signature | null |
| Returns |
void
|
| Exceptions |
|
Forcefully suspends a data source that has the health state of
Running, including disconnecting all current
connection users. All current connections are closed and
recreated.
If successful, the health state is set to
Suspended.
This is a privileged operation that can only be invoked by an authorized user.
| Operation Name | "forceSuspend" |
| Parameters | null |
| Signature | null |
| Returns |
void
|
| Exceptions |
|
Specifies whether a data source with the given name exists.
This is a privileged operation that can only be invoked by an authorized user.
| Operation Name | "poolExists" |
| Parameters | Object [] { poolName }
where:
|
| Signature | String [] {
"java.lang.String" } |
| Returns |
boolean
|
| Exceptions |
|
Resets the connection pool in the data source by shutting down and recreating all available database connections in the pool.
Use when a data source is in the health state of
Unhealthy and needs to be reinitialized.
This is a privileged operation that can only be invoked by an authorized user.
| Operation Name | "reset" |
| Parameters | null |
| Signature | null |
| Returns |
void
|
| Exceptions |
|
Reset statistics counters to zero.
| Operation Name | "resetStatistics" |
| Parameters | null |
| Signature | null |
| Returns |
void
|
Restores all access to and operations on a data source that has
a health state of Suspended.
If successful, the health state is set to
Running.
This is a privileged operation that can only be invoked by an authorized user.
| Operation Name | "resume" |
| Parameters | null |
| Signature | null |
| Returns |
void
|
| Exceptions |
|
Shrinks the database connection pool in the data source to either the current number of reserved connections or the initial size of the connection pool, which ever is greater.
This is a privileged operation that can only be invoked by an authorized user.
| Operation Name | "shrink" |
| Parameters | null |
| Signature | null |
| Returns |
void
|
| Exceptions |
|
Gracefully, synchronously shuts down a data source that has a
health state of Running. A graceful (non-forced)
datasource shutdown operation involves first gracefully suspending
the data source and then releasing the associated resources
including the connections. See the description above for details of
gracefully suspending the datasource. After the datasource is
gracefully suspended, all remaining in-use connections are closed
and the datasource is marked as shut down.
If successful, the health state is set to
Shutdown.
This is a privileged operation that can only be invoked by an authorized user.
| Operation Name | "shutdown" |
| Parameters | null |
| Signature | null |
| Returns |
void
|
| Exceptions |
|
Gracefully, asynchronously shuts down a data source that has a
health state of Running. A graceful (non-forced)
datasource shutdown operation involves first gracefully suspending
the data source and then releasing the associated resources
including the connections. See the description above for details of
gracefully suspending the datasource. After the datasource is
gracefully suspended, all remaining in-use connections are closed
and the datasource is marked as shut down.
Setting IgnoreInUseConnectionsEnabled to false causes the operation to fail if in-use connections exist.
If successful, the health state is set to
Shutdown.
This is a privileged operation that can only be invoked by an authorized user.
| Operation Name | "shutdown" |
| Parameters | Object [] { operationSecs }
where:
|
| Signature | String [] {
"java.lang.Integer" } |
| Returns | JDBCDataSourceTaskRuntimeMBean |
| Exceptions |
|
Starts a data source that has a health state of
Shutdown.
If successful, the health state is set to
Running.
This is a privileged operation that can only be invoked by an authorized user.
| Operation Name | "start" |
| Parameters | null |
| Signature | null |
| Returns |
void
|
| Exceptions |
|
Synchronously, gracefully suspends a data source that has the
health state of Running and disables existing
connections. This operation immediately marks the data source as
suspended and no further connections are created. Idle (not
reserved) connections are marked as disabled. After a timeout
period for the suspend operation, all remaining connections in the
pool are marked as suspended and the following exception is thrown
for any operations on the connection, indicating that the data
source is suspended: java.sql.SQLRecoverableException: Connection
has been administratively disabled. Try later. If graceful suspend
is done as part of a graceful shutdown operation, connections are
immediately closed when no longer reserved or at the end of the
timeout period. If not done as part of a shutdown operation, these
connections remain in the pool and are not closed because the pool
may be resumed.
By default, the timeout period is 60 seconds. You can change the value of this timeout period by configuring or dynamically setting Inactive Connection Timeout Seconds to a non-zero value.
Setting IgnoreInUseConnectionsEnabled to false causes the operation to fail if in-use connections exist.
If successful, the health state is set to
Suspended.
This is a privileged operation that can only be invoked by an authorized user.
| Operation Name | "suspend" |
| Parameters | null |
| Signature | null |
| Returns |
void
|
| Exceptions |
|
Asynchronously, gracefully suspends a data source that has the
health state of Running and disables existing
connections. This operation immediately marks the data source as
suspended and no further connections are created. Idle (not
reserved) connections are marked as disabled. After a timeout
period for the suspend operation, all remaining connections in the
pool are marked as suspended and the following exception is thrown
for any operations on the connection, indicating that the data
source is suspended: java.sql.SQLRecoverableException: Connection
has been administratively disabled. Try later. These connections
remain in the pool and are not closed because the pool may be
resumed.
Setting IgnoreInUseConnectionsEnabled to false causes the operation to fail if in-use connections exist.
If successful, the health state is set to
Suspended.
This is a privileged operation that can only be invoked by an authorized user.
| Operation Name | "suspend" |
| Parameters | Object [] { operationSecs }
where:
|
| Signature | String [] {
"java.lang.Integer" } |
| Returns | JDBCDataSourceTaskRuntimeMBean |
| Exceptions |
|
Tests the connection pool in the data source by reserving and releasing a connection from it.
If the pool configuration attribute TestConnectionsOnReserve is enabled, the acquired connection is also tested as part of the reserve operation.
For more information, see:
| Operation Name | "testPool" |
| Parameters | null |
| Signature | null |
| Returns | String
|