JDBCDataSourceMBean

Overview

This MBean defines a non-transactional JDBC data source.

Deprecated. 9.0.0.0 Replaced by JDBCSystemResourceMBean

Related MBeans

This section describes attributes that provide access to other MBeans.

Targets

You must select a target on which an MBean will be deployed from this list of the targets in the current domain on which this item can be deployed. Targets must be either servers or clusters. The deployment will only occur once if deployments overlap.

Attributes

This section describes the following attributes:

CachingDisabled

Private property that disables caching in proxies.

ConnectionWaitPeriod

The number of seconds that the system will wait for a free connection to become available if a request is received when there are no free connections in the connection pool. (Requires that you enable the system to wait for connections.)

A WebLogic Server server thread is occupied while waiting for a free connection, which can result in a decrease in system throughput. Therefore, the recommended way to handle the situation is to increase the number of connections in the connection pool.

For more information, see:

• getWaitForConnectionEnabled

DeploymentOrder

A priority that the server uses to determine when it deploys an item. The priority is relative to other deployable items of the same type.

For example, the server prioritizes and deploys all EJBs before it prioritizes and deploys startup classes.

Items with the lowest Deployment Order value are deployed first. There is no guarantee on the order of deployments with equal Deployment Order values. There is no guarantee of ordering across clusters.

JNDIName

The JNDI path to where this Data Source is bound.

Applications that look up the JNDI path will get a javax.sql.DataSource instance that corresponds to this Data Source. Note that the old style usage of DriverManager.getConnection() or Driver.connect() has been deprecated in favor of looking up a Data Source to obtain a connection.

JNDINameSeparator

The JNDI Seperator is used to seperate JNDIName list for this DataSource.

Applications that look up the JNDI path will get a javax.sql.DataSource instance that corresponds to this DataSource.

MBeanInfo

Returns the MBean info for this MBean.

Deprecated.

Name

The user-specified name of this MBean instance.

This name is included as one of the key properties in the MBean's javax.management.ObjectName:
Name=user-specified-name

Notes

Optional information that you can include to describe this configuration.

WebLogic Sever saves this note in the domain's configuration file (config.xml) as XML PCDATA. All left angle brackets (<) are converted to the XML entity <. Carriage returns/line feeds are preserved.

Note:

If you create or edit a note from the Administration Console, the Administration Console does not preserve carriage returns/line feeds.

ObjectName

Returns the ObjectName under which this MBean is registered in the MBean server.

Deprecated.

Parent

Return the immediate parent for this MBean

PoolName

The PoolName attribute applies to legacy data source configurations only. Do not set a PoolName for a WebLogic Server 9.0 or later JDBC data source.

For JDBC data source configurations before WebLogic Server 9.0, the PoolName is the name of the JDBC connection pool that is associated with this data source. Calls from applications to getConnection() on this Data Source return a connection from the associated connection pool.

Registered

Returns false if the MBean represented by this object has been unregistered.

Deprecated.

RowPrefetchEnabled

Specifies whether multiple rows should be "prefetched" (that is, sent from the server to the client) in one server access.

When an external client accesses a database using JDBC through WebLogic Server, row prefetching improves performance by fetching multiple rows from the server to the client in one server access. WebLogic Server ignores this setting and does not use row prefetching when the client and WebLogic Server are in the same JVM.

RowPrefetchSize

Specifies the number of result set rows to prefetch for a client.

The optimal value depends on the particulars of the query. In general, increasing this number will increase performance, until a particular value is reached. At that point further increases do not result in any significant performance increase. Very rarely will increased performance result from exceeding 100 rows. The default value should be reasonable for most situations.

StreamChunkSize

Specifies the data chunk size for steaming data types.

Streaming data types (for example resulting from a call to getBinaryStream()) will be pulled in sized chunks from WebLogic Server to the client as needed.

Type

Returns the type of the MBean.

WaitForConnectionEnabled

Specifies whether the system waits for a connection to become available if a request is made when all connections in the connection pool are in use. Oracle recommends that you do not use this feature in a production environment.

A WebLogic Server server thread is occupied while waiting for a free connection, which can result in a decrease in system throughput. Therefore, the recommended way to handle the situation is to increase the number of connections in the connection pool.

Operations

This section describes the following operations:

addTarget

You can add a target to specify additional servers on which the deployment can be deployed. The targets must be either clusters or servers.

freezeCurrentValue

If the specified attribute has not been set explicitly, and if the attribute has a default value, this operation forces the MBean to persist the default value.

Unless you use this operation, the default value is not saved and is subject to change if you update to a newer release of WebLogic Server. Invoking this operation isolates this MBean from the effects of such changes.

Note:

To insure that you are freezing the default value, invoke the restoreDefaultValue operation before you invoke this.

This operation has no effect if you invoke it on an attribute that does not provide a default value or on an attribute for which some other value has been set.

Deprecated. 9.0.0.0

isSet

Returns true if the specified attribute has been set explicitly in this MBean instance.

removeTarget

Removes the value of the addTarget attribute.

For more information, see:

• addTarget

restoreDefaultValue

If the specified attribute has a default value, this operation removes any value that has been set explicitly and causes the attribute to use the default value.

Default values are subject to change if you update to a newer release of WebLogic Server. To prevent the value from changing if you update to a newer release, invoke the freezeCurrentValue operation.

This operation has no effect if you invoke it on an attribute that does not provide a default value or on an attribute that is already using the default.

Deprecated. 9.0.0.0

unSet

Restore the given property to its default value.