Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | JDBC Driver Specific Properties | Informix | Informix JDBC Driver Type 4
 
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 Software AG 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.