Sun Microsystems 820433510 manual Configurations for Specific Jdbc Drivers

Configurations for Specific JDBC Drivers

Match Connections	Use this option to switch on/off connection
	matching for the pool. It can be set to false if the
	administrator knows that the connections in the
	pool will always be homogeneous and hence a
	connection picked from the pool need not be
	matched by the resource adapter. Default value is
	false.
Max Connection Usage	Specify the number of times a connection should be
	reused by the pool. Once a connection is reused for
	the specified number of times, it will be closed. This
	is useful, for instance, to avoid statement-leaks. The
	default value of 0 implies that no connections will be
	reused.

Configurations for Specific JDBC Drivers

Enterprise Server is designed to support connectivity to any database management system with a corresponding JDBC driver. The following JDBC driver and database combinations are supported. These combinations have been tested with Enterprise Server and are found to be Java EE compatible.

■“Java DB Type 4 Driver” on page 53

■“Sun GlassFish JDBC Driver for DB2 Databases” on page 54

■“Sun GlassFish JDBC Driver for Oracle 8.1.7 and 9.x Databases” on page 54

■“Sun GlassFish JDBC Driver for Microsoft SQL Server Databases” on page 55

■“Sun GlassFish JDBC Driver for Sybase Databases” on page 55

■“IBM DB2 8.1 Type 2 Driver” on page 56

■“JConnect Type 4 Driver for Sybase ASE 12.5 Databases” on page 56

■“MySQL Type 4 Driver ” on page 57

Other JDBC drivers can be used with Enterprise Server , but Java EE compliance tests have not been completed with these drivers. Although Sun offers no product support for these drivers, Sun offers limited support of the use of these drivers with Enterprise Server .

■“Inet Oraxo JDBC Driver for Oracle 8.1.7 and 9.x Databases” on page 57

■“Inet Merlia JDBC Driver for Microsoft SQL Server Databases” on page 58

■“Inet Sybelux JDBC Driver for Sybase Databases” on page 59

■“Oracle Thin Type 4 Driver for Oracle 8.1.7 and 9.x Databases” on page 59

■“OCI Oracle Type 2 Driver for Oracle 8.1.7 and 9.x Databases” on page 60

■“IBM Informix Type 4 Driver” on page 61

■“CloudScape 5.1 Type 4 Driver” on page 61

For details about how to integrate a JDBC driver and how to use the Administration Console or the command line interface to implement the configuration, see the Sun GlassFish Enterprise Server 2.1 Administration Guide.

52 Sun GlassFish Enterprise Server 2.1 Administration Guide • December 2008