Skip navigation.
Downloads | Product Documentation | Support

Administration Console Online Help

# JDBC Data Sources

Column Display Related Tasks Related Topics

A JDBC data source is an object bound to the JNDI tree that provides database connectivity through a pool of JDBC connections. Applications can look up a data source on the JNDI tree and then borrow a database connection from a data source.

This page summarizes the JDBC data source objects that have been created in this domain.

#### Column Display

You can show fewer or additional data points on this page by expanding Customize this table and modifying the Column Display list. Each data point displays in its own table column.

The following table lists all of the data points that you can display in columns on this page.

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.
JNDI Name | The JNDI path to where this Data Source is bound. By default, the JNDI name is the name of the data source. 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.
Targets | The server and clusters to which the data source is targeted. MBean Attribute: `TargetInfoMBean.Targets`
Row Prefetch Enabled | Enables multiple rows to 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. 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. 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. 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.

Related Tasks

- Create JDBC data sources
- Delete JDBC data sources

Related Topics

- Configuring JDBC Data Sources
- Configuring and Deploying WebLogic JDBC Resources