Configurations for Specific JDBC Drivers

■xa-driver-does-not-support-non-tx-operations - Set to the value true. Optional: only needed if both non-XA and XA connections are retrieved from the same connection pool. Might degrade performance.

As an alternative to setting this property, you can create two connection pools, one for non-XA connections and one for XA connections.

IBM Informix Type 4 Driver

Configure the connection pool using the following settings:

■Name: Use this name when you configure the JDBC resource later.

■Resource Type: Specify the appropriate value.

■Database Vendor: Informix

■DataSource Classname:Specify one of the following:

com.informix.jdbcx.IfxDataSource

com.informix.jdbcx.IfxXADataSource

■Properties:

■serverName - Specify the Informix database server name.

■portNumber - Specify the port number of the database server.

■user - Set as appropriate.

■password - Set as appropriate.

■databaseName - Set as appropriate. This is optional.

■IfxIFXHost - Specify the host name or IP address of the database server.

CloudScape 5.1 Type 4 Driver

The JAR files for the CloudScape driver aredb2j.jar, db2jtools.jar, db2jcview.jar, jh.jar, db2jcc.jar, and db2jnet.jar. Configure the connection pool using the following settings:

■Name: Use this name when you configure the JDBC resource later.

■Resource Type: Specify the appropriate value.

■Database Vendor: Cloudscape

■DataSource Classname: com.ibm.db2.jcc.DB2DataSource

■Properties:

■user - Set as appropriate.

■password - Set as appropriate.

■databaseName - Set as appropriate.

Chapter 3 • JDBC Resources

61

Page 61
Image 61
Sun Microsystems 820433510 manual IBM Informix Type 4 Driver, CloudScape 5.1 Type 4 Driver