MatchConnections Usethis option to switch on/o connection
matchingfor the pool. It can be set to false if the
administratorknows that the connections in the
poolwill always be homogeneous and hence a
connectionpicked from the pool need not be
matchedby the resource adapter. Default value is
false.
MaxConnection Usage Specifythe number of times a connection should be
reusedby the pool. Once a connection is reused for
thespecied number of times, it will be closed. This
isuseful, for instance, to avoid statement-leaks. The
defaultvalue of 0 implies that no connections will be
reused.
Congurationsfor Specic JDBC Drivers
EnterpriseServer is designed to support connectivity to any database management system with
acorresponding JDBC driver. The following JDBC driver and database combinations are
supported.These combinations have been tested with Enterprise Server and are found to be
JavaEE compatible.
“JavaDB Type 4 Driver” on page 53
“SunGlassFish JDBC Driver for DB2 Databases” on page 54
“SunGlassFish JDBC Driver for Oracle 8.1.7 and 9.x Databases” on page 54
“SunGlassFish JDBC Driver for Microsoft SQL Server Databases” on page 55
“SunGlassFish JDBC Driver for Sybase Databases” on page 55
“IBMDB2 8.1 Type 2 Driver” on page 56
“JConnectType 4 Driver for Sybase ASE 12.5 Databases” on page 56
“MySQLType 4 Driver ” on page 57
OtherJDBC drivers can be used with Enterprise Server , but Java EE compliance tests have not
beencompleted with these drivers. Although Sun oers no product support for these drivers,
Sunoers limited support of the use of these drivers with Enterprise Server .
“InetOraxo JDBC Driver for Oracle 8.1.7 and 9.x Databases” on page 57
“InetMerlia JDBC Driver for Microsoft SQL Server Databases” on page 58
“InetSybelux JDBC Driver for Sybase Databases” on page 59
“OracleThin Type 4 Driver for Oracle 8.1.7 and 9.x Databases” on page 59
“OCIOracle Type 2 Driver for Oracle 8.1.7 and 9.x Databases” on page 60
“IBMInformix Type 4 Driver” on page 61
“CloudScape5.1 Type 4 Driver” on page 61
Fordetails about how to integrate a JDBC driver and how to use the Administration Console or
thecommand line interface to implement the conguration, see the Sun GlassFish Enterprise
Server2.1 Administration Guide.
CongurationsforSpecic JDBC Drivers
SunGlassFishEnterprise Ser ver2.1 Administration Guide • December 200852