Informix

Informix JDBC Driver Type 4

DataSource

Transaction Type DataSource Class
NO_TRANSACTION, LOCAL_TRANSACTION 
com.informix.jdbcx.IfxDataSource
Note: If you use the com.informix.jdbcx.IfxDataSource DataSource class with Integration Server, you must disable the WmTomcat package. Be aware that disabling the WmTomcat package also disables support for any JSPs. For general information about setting dependencies, see Adapter for JDBC Package Management. For more detailed information see IBM webMethods Designer Online Help for your release.
XA_TRANSACTION 
com.informix.jdbcx.IfxXADataSource

Transaction Isolation Level Setting

Specify the transaction isolation level properties in the Other Properties field:

Parameter Description
TransactionIsolation Phantom read does not function when you set the transaction isolation level to 4. For example: 
TransactionIsolation=4;

Other Properties

Specify the parameters in the Other Properties field:

Parameter Description
IfxIFXHOST Machine name of the database server. Applicable for all transaction types. 
IfxIFXHOST=hostname

Required Connection Property Fields

Driver Name Server Name User Password Database Name Port Number Network Protocol
Informix JDBC 2.21 Type 4 for Informix v. 7.31 and 9.x Yes Yes Yes Yes Yes No

For more information about limitations, see Limitations.

Limitations

Driver Database/

Adapter IS Operating System/

Platform Affected

Limitation Description
Informix Driver for JDBC Version 2.21 type 4 Informix 7.31 and 9.x
  • This driver does not support multiple results sets. If you configure the adapter to use multiple result sets, all the rows in the result will be stored in the first Result Set you specified when you configured the adapter.
  • With Informix 9.3 and 9.4 using XA_TRANSACTION, you cannot update LONGVARCHAR data type columns with a null value.
  • With Informix 9.3 and 9.4 using XA_TRANSACTION, you cannot update BOOLEAN data type columns with a NOT NULL value.