BMC Software, Inc., Confidential and Proprietary Information
Managing WebLogic Components and Services 7-13
Table 7-4 Create New JDBC Pool dialog box fields (WebLogic Server 6.x and 7.0) (Part 1 of 2)
Field Name Action
Pool Name name of the pool used within WebLogic; this name must be unique,
for example, NewJDBCpool
URL address used to locate the database to which the ppol connects;
there are three parts to this URL (example, jdbc:cloudscape:demo):
• protocol
• database type
• database name
JDBC Driver name of the driver specific to your database type; this is supplied by
the JDBC driver vendor (see vendor documentation for details)
Properties the list of properties passed to the 2-tier JDBC driver for use in
creating database connections (such as username and server)
ACL Name name of the ACL used to control access to this connection pool
Password password for connecting to the database
Initial Capacity number of physical database connections to create in a new pool
Max Capacity maximum number of physical database connections in the pool;
different JDBC drivers and database servers may limit this number
Capacity Increment number of connections to add when the pool size is increased
Login Delay Seconds number of seconds to delay before creating each connection in the
pool; this delay occurs on initial creation and throughout the lifetime of
the pool whenever a database connection is created
Allow Shrinking? flag indicating that JDBC pool is allowed to shrink to InitialCapacity
Shrink Period Minutes number of minutes to wait before shrinking an incremented pool
Refresh Period Minutes connection refresh interval; number of minutes between testing
connections using TestTableName; failed connections are reopened;
if TestTableName is not set, the the test is not performed
Support Local Transaction flag indicating whether XA driver supports SQL with no global
transactions; this is ignored for non-XA drivers
Prepared Statement Cache
Size
size of the prepared statement cache; number of prepared
statements from a connection stored for future use; set to 0 to disable
Test Reserved Conn. flag indicating whether connections in the pool should be tested; the
WebLogic Server tests a connection after giving it to the client, adding
a small delay in serving connection requests but ensuring that clients
receive working connections (assuming database is available and
accessible
