These properties vary according to the database vendor requirements
for JDBC driver implementations. You must set the appropriate properties on
every data source that you configure. These settings are for Informix data
sources.
You can configure the following types of providers:
- Informix JDBC Driver
The Informix JDBC Driver
is a Type 4 JDBC driver that provides JDBC access to the Informix database.
Informix
JDBC Driver supports one phase data source:
com.informix.jdbcx.IfxConnectionPoolDataSource
Requires
JDBC driver files:
ifxjdbc.jar
ifxjdbcx.jar
Requires
DataStoreHelper class:
com.ibm.websphere.rsadapter.InformixDataStoreHelper
Requires
a valid authentication alias.
Requires properties:
- serverName The name of the Informix instance on the server.
Example: ol_myserver.
- portNumber The port on which the instances listen. Example: 1526.
- ifxIFXHOST Either the IP address or the host name of the machine
that is running the Informix database to which you want to connect. Example: myserver.mydomain.com.
To support IPv6: On AIX and
Solaris, IBM Informix Dynamic Server 10.00 with fix pack 1 supports the IPv6
standard. To enable IPv6 on your WebSphere Application Server connection with
one of these Informix releases, input your full IPv6 host name for the ifxIFXHOST
property.
- databaseName The name of the database from which the data source
obtains connections. Example: Sample.
- informixLockModeWait Although not required, this property enables
you to set the number of seconds that Informix software waits for a lock.
By default, Informix code throws an exception if it cannot immediately acquire
a lock. Example: 2.
- Informix JDBC Driver (XA)
The Informix JDBC
Driver (XA) is a Type 4 JDBC driver that provides XA-compliant JDBC access
to the Informix database.
Informix JDBC Driver (XA) supports two phase
data source:
com.informix.jdbcx.IfxXADataSource
Requires JDBC driver
files:
ifxjdbc.jar
ifxjdbcx.jar
To use SQLJ: This provider also requires
driver file ifxsqlj.jar if you plan to use SQLJ for
queries.
Requires
DataStoreHelper class:
com.ibm.websphere.rsadapter.InformixDataStoreHelper
Requires
a valid authentication alias.
Requires properties:
- serverName The name of the Informix instance on the server. Example: ol_myserver.
- portNumber The port on which the instances listen. Example: 1526.
- ifxIFXHOST Either the IP address or the host name of the machine
that is running the Informix database to which you want to connect. Example: myserver.mydomain.com.
To support IPv6: On AIX and
Solaris, IBM Informix Dynamic Server 10.00 with fix pack 1 supports the IPv6
standard. To enable IPv6 on your WebSphere Application Server connection with
one of these Informix releases, input your full IPv6 host name for the ifxIFXHOST
property.
- databaseName The name of the database from which the data source
obtains connections. Example: Sample.
- ifxIFX_XASPEC Turn on this property when multiple users access
the same database. Activating the property enforces tight coupling of XA transactions
within the same global transaction ID, and requires the transactions to share
lock space. These parameters help prevent transaction management errors from
occurring in cases of multiple client requests. Turn on the ifxIFX_XASPEC property
by assigning it the value of Y or y; either
character works because the setting is not case-specific. Turn the property
off by assigning it the value of N or n.
WebSphere Application Server ignores all other values. Your setting for the
property overrides the Informix database system setting.
- informixLockModeWait Although not required, this property enables
you to set the number of seconds that Informix software waits for a lock.
By default, Informix code throws an exception if it cannot immediately acquire
a lock. Example: 2.