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