Editing a JDBC Connection Pool
TheEdit JDBC Connection Pool page provides the means to change all of the settings for an
existingpool except its name.
1. Changegeneral settings.
Thevalues of the general settings depend on the specic JDBC driver that is installed. These
settingsare the names of classes or interfaces in the Java programming language.
Parameter Description
DataSourceClass Name Thevendor-specic class name that implements the DataSource and/or
XADataSourceAPIs. This class is in the JDBC driver.
ResourceType Choicesinclude javax.sql.DataSource (local transactions only),
javax.sql.XADataSource(global transactions), and
java.sql.ConnectionPoolDataSource(local transactions, possible
performanceimprovements).
2. Changepool settings.
Aset of physical database connections reside in the pool. When an application requests a
connection,the connection is removed from the pool, and when the application releases the
connection,it is returned to the pool.
Parameter Description
Initialand Minimum Pool Size Theminimum number of connections in the pool. This value also
determinesthe number of connections placed in the pool when the pool is
rstcreated.
MaximumPool Size Themaximum number of connections in the pool.
PoolResize Quantity Whenthe pool scales up and scales down towards the maximum and
minimumpool sizes respectively, it is resized in batches. This value
determinesthe number of connections in the batch. Making this value too
largedelays connection creation and recycling; making it too small will be
lessecient.
IdleTimeout Themaximum time in seconds that a connection can remain idle in the
pool.After this time expires, the connection is removed from the pool.
MaxWait Time Theamount of time the application requesting a connection will wait before
gettinga connection timeout. Because the default wait time is long, the
applicationmight appear to hang indenitely.
3. Changeconnection validation settings.
WorkingwithJDBC Connection Pools
SunGlassFishEnterprise Ser ver2.1 Administration Guide • December 200848