Fusion Middleware Control Help for WebLogic Server

Create a JDBC UCP Data Source: Connection Properties

Buttons     Configuration Options     

Use this page to define the connection properties for this UCP data source.

Buttons

Name	Description
Generate Properties	Click the Generate Properties button to enter the information required for WebLogic Server to create the fully qualified URL for your JDBC connections.
Test Database Connection	Click the Test Database Connection button to test this database connection.

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.
Type	Specifies if the data source is accessible within the domain, a partition, or a resource group template.
Driver Class Name	The full package name of JDBC driver class used to create the physical database connections in the connection pool in the data source. For example: oracle.jdbc.OracleDriver The driver must be the name of a class that implements the java.sql.Driver interface. Check the driver documentation to find the full pathname. Note that the driver class must be in the classpath of any server to which the data source is deployed. MBean Attribute (Does not apply to application modules) : JDBCDriverParamsBean.DriverName 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.
Password	The password attribute passed to the JDBC driver when creating physical database connections. The value is stored in an encrypted form in the descriptor file and when displayed in an administration console. MBean Attribute (Does not apply to application modules) : JDBCDriverParamsBean.Password Changes take effect after you redeploy the module or restart the server.
Test Table Name	The name of the database table to use when testing physical database connections. This name is required when you specify a Test Frequency and enable Test Reserved Connections. The default SQL code used to test a connection is select count(*) from TestTableName Most database servers optimize this SQL to avoid a table scan, but it is still a good idea to set the Test Table Name to the name of a table that is known to have few rows, or even no rows. If the Test Table Name begins with SQL, then the rest of the string following that leading token will be taken as a literal SQL statement that will be used to test connections instead of the standard query. For example: SQL BEGIN; Null; END; For an Oracle database, you can reduce the overhead of connection testing by setting Test Table Name to SQL PINGDATABASE which uses the pingDatabase() method to test the Oracle connection. For any JDBC 4.0 database, it is possible to use "SQL ISVALID" to use the isValid() method on the connection. MBean Attribute (Does not apply to application modules) : JDBCConnectionPoolParamsBean.TestTableName
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 driver properties whose values are derived at runtime from the named system property.