Administration Console Online Help

Previous Next Open TOC in new window
Content starts here

JDBC Data Source: Configuration: General

Configuration Options     Related Tasks     Related Topics

Applications get a database connection from a data source by looking up the data source on the Java Naming and Directory Interface (JNDI) tree and then requesting a connection. The data source provides the connection to the application from its pool of database connections.

This page enables you to define general configuration options for this JDBC data source.

Configuration Options

Name Description
Name

A unique name that identifies this data source in the WebLogic domain.

MBean Attribute (Does not apply to application modules) :
JDBCDataSourceBean.Name

Changes take effect after you redeploy the module or restart the server.

Datasource Type

The data source type. Valid types are:

  • GENERIC - generic data source

  • MDS - multi data source

  • AGL - Active GridLink data source

  • UCP - Universal Connection Pool data source

  • PROXY - proxy for multiple tenant data sources

MBean Attribute (Does not apply to application modules) :
JDBCDataSourceBean.DatasourceType

Changes take effect after you redeploy the module or restart the server.

JNDI Name

The JNDI path to where this data source is bound. By default, the JNDI name is the name of the data source.

To specify multiple JNDI names for the data source, enter each JNDI name on a separate line.

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

MBean Attribute (Does not apply to application modules) :
JDBCDataSourceParamsBean.JNDINames

Changes take effect after you redeploy the module or restart the server.

Row Prefetch Enabled

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

This parameter applies only to the deprecated JDBC over RMI.

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.

MBean Attribute (Does not apply to application modules) :
JDBCDataSourceParamsBean.RowPrefetch

Changes take effect after you redeploy the module or restart the server.

Row Prefetch Size

If row prefetching is enabled, specifies the number of result set rows to prefetch for a client.

This parameter applies only to the deprecated JDBC over RMI.

The optimal prefetch size 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.

MBean Attribute (Does not apply to application modules) :
JDBCDataSourceParamsBean.RowPrefetchSize

Minimum value: 2

Maximum value: 65536

Changes take effect after you redeploy the module or restart the server.

Stream Chunk Size

Specifies the data chunk size for steaming data types.

This parameter applies only to the deprecated JDBC over RMI.

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

MBean Attribute (Does not apply to application modules) :
JDBCDataSourceParamsBean.StreamChunkSize

Minimum value: 1

Maximum value: 65536

Changes take effect after you redeploy the module or restart the server.

Proxy Switching Properties

Specifies the switching properties passed to the switching callback method for a Proxy data source.

MBean Attribute (Does not apply to application modules) :
JDBCDataSourceParamsBean.ProxySwitchingProperties

Proxy Switching Callback

The name of the switching callback class for a Proxy data source.

This class implements the weblogic.jdbc.extensions.DataSourceSwitchingCallback interface.

MBean Attribute (Does not apply to application modules) :
JDBCDataSourceParamsBean.ProxySwitchingCallback

Changes take effect after you redeploy the module or restart the server.

Related Tasks

Related Topics


Back to Top