JDBC

In the JDBC Connection Pool—>Configuration—>General tab, you specify the general attributes of a connection pool necessary for connecting to a database. A connection pool contains a group of JDBC connections that are created when the connection pool is registered, usually when starting up WebLogic Server or when deploying on a new server. Your application borrows a connection from the connection pool, uses it, then returns it to the connection pool by closing it.

Table 10-4

Attribute Label	Description	Value Constraints
Name	The name of this connection pool. MBean: weblogic.management. configuration. JDBCConnectionPoolMBean Attribute: Name
URL	The database URL used to create the connections in this Connection Pool. MBean: weblogic.management. configuration. JDBCConnectionPoolMBean Attribute: URL
Driver Classname	The full package name of the JDBC driver class used to create the physical connections between WebLogic Server and the DBMS for this connection pool. For example: com.pointbase.jdbc.jdbcUniversalDriver It must be the name of a class that implements the java.sql.Driver interface. Check the documentation for the JDBC driver to find the full pathname. MBean: weblogic.management. configuration. JDBCConnectionPoolMBean Attribute: DriverName
Properties	The list of properties passed to the the JDBC Driver to use when creating physical database connections. The list consists of attribute=value tags. Enter each pair on a separate line. For example user=scott server=myDB MBean: weblogic.management. configuration. JDBCConnectionPoolMBean Attribute: Properties
Password	The database password used to create the physical database connections. This password overrides the password that you enter in the Properties field. See Using the JDBC Connection Pool Assistant MBean: weblogic.management. configuration. JDBCConnectionPoolMBean Attribute: Password	Encrypted: yes
Open String Password	This password is used in an openString to create physical XA database connections. The value is stored in an encrypted form in the config.xml file. If set, this value overrides any password value in the openString defined in Properties. If your JDBC driver requires it, you must create the remainder of the openString in the properties field. MBean: weblogic.management. configuration. JDBCConnectionPoolMBean Attribute: XAPassword	Encrypted: yes