Fusion Middleware Control Help for WebLogic Server

Create a JDBC Data Source: Review

Use this page to create a JDBC data source. 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 reserve a database connection from a data source.

Configuration Options

Name	Description
Data Source 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.
Scope	Specifies if the data source is accessible within the domain, a partition, or a resource group template.
Type	The type of data source: Generic, GridLink, UCP, Proxy, or Multi Data Source.
Driver Class Name	Select that driver that you want to use to create physical database connections. The data source pools the database connections for use and reuse by your applications. * indicates that the driver is explicitly supported by Oracle WebLogic Server. If your driver is not listed, select "other."
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.
Database URL	The URL of the database to connect to. The format of the URL varies by JDBC driver. The URL is passed to the JDBC driver to create the physical database connections. MBean Attribute (Does not apply to application modules) : JDBCDriverParamsBean.Url Changes take effect after you redeploy the module or restart the server.
Properties	The list of properties passed to the JDBC driver that are used to create physical database connections. For example: server=dbserver1. List each property=value pair on a separate line. To enable driver-level features, add the driver property and its value to the Properties list. WebLogic Server sets driver-level properties in the Properties list on the driver's ConnectionPoolDataSource object. Note: For security reasons, when WebLogic Server is running in Production mode, you cannot specify database passwords in this properties list. Data source deployment will fail if a password is specified in the properties list. To override this security check, use the command line argument "weblogic.management.allowClearTextPasswords" when starting the server. MBean Attribute (Does not apply to application modules) : JDBCDriverParamsBean.Properties Changes take effect after you redeploy the module or restart the server.
System Properties	The list of system properties passed to the JDBC driver that are used to create physical database connections. For example: server=dbserver1. List each property=value pair on a separate line. MBean Attribute (Does not apply to application modules) : JDBCPropertyBean.SysPropValue Changes take effect after you redeploy the module or restart the server.
Transaction Options	Summary of transaction options selected for this data source. The transaction protocol for a JDBC data source determines how connections from the data source are handled during transaction processing. Transactions within a JDBC data source are either global (XA) and non-global (local).
Targets	The servers or clusters on which this JDBC data source will be deployed.