Data source minimum required settings for Informix

Set the appropriate properties on every data source configured. These settings are for Informix data sources.

We can configure the following types of providers:

• Informix JDBC Driver

• Informix JDBC Driver (XA)

• Informix Using IBM JCC Driver

• Informix Using IBM JCC Driver (XA)

• Informix Using IBM DB2 JDBC Universal Driver

• Informix Using IBM DB2 JDBC Universal Driver (XA)

• 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 the following JDBC driver files:

  ifxjdbc.jar
  ifxjdbcx.jar

  Requires the following DataStoreHelper class:
  com.ibm.websphere.rsadapter.InformixDataStoreHelper

  Requires a valid authentication alias.

  Requires the following 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 running the Informix database to which 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 the WAS connection with one of these Informix releases, input the 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 the following 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 the following DataStoreHelper class:

  com.ibm.websphere.rsadapter.InformixDataStoreHelper

  Requires a valid authentication alias.

  Requires the following 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 running the Informix database to which 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 the WAS connection with one of these Informix releases, input the 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 the case 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.

• Informix Using IBM JCC Driver

  The Informix IBM JCC Driver is a one-phase commit provider for Informix that uses the IBM Data Server Driver for JDBC and SQLJ. The IBM Data Server Driver is JDBC 4.0 compliant and is the next generation of the Universal JCC driver.

  This provider is configurable in version 7.0 and later nodes.

  The following one-phase data source is supported:

  com.ibm.db2.jcc.DB2ConnectionPoolDataSource

  The following JDBC driver files are required:

  db2jcc4.jar
  db2jcc_license_cu.jar
  db2jcc_license_cisuz.jar

  as well as the following DataStoreHelper class:
  com.ibm.websphere.rsadapter.InformixJccDataStoreHelper

  This provider requires a valid authentication alias.

  The following properties are required:

  • serverName - The TCP/IP address or host name for the Informix server.

  • portNumber - The TCP/IP port number where the Informix server resides.

  • databaseName - The name of the database from which the data source obtains connections. Example: Sample.

• Informix Using IBM JCC Driver (XA)

  The Informix IBM JCC Driver (XA) is a two-phase commit provider for Informix that uses the IBM Data Server Driver for JDBC and SQLJ. The IBM Data Server Driver is JDBC 4.0 compliant and is the next generation of the Universal JCC driver.

  This provider is configurable in version 7.0 and later nodes.

  The following two-phase data source is supported:

  com.ibm.db2.jcc.DB2XADataSource

  The following JDBC driver files are required:

  db2jcc4.jar
  db2jcc_license_cu.jar
  db2jcc_license_cisuz.jar

  as well as the following DataStoreHelper class:
  com.ibm.websphere.rsadapter.InformixJccDataStoreHelper

  Avoid trouble: To use SQLJ for queries, this provider also requires driver file ifxsqlj.jar.gotcha

  This provider requires a valid authentication alias.

  The following properties are required:

  • serverName - The TCP/IP address or host name for the Informix server.

  • portNumber - The TCP/IP port number where the Informix server resides.

  • databaseName - The name of the database from which the data source obtains connections. Example: Sample.

  Avoid trouble: We cannot use Informix XA data sources with ANSI databases if SQL statements are issued in local transactions instead of global transactions. This scenario might occur within the application code or within a component of Application Server such as scheduler. The following message might be logged if you are experiencing this problem:

  java.sql.SQLException: Already in transaction.
         at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:398)
         at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3247)
         at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3556)
         at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2382)
         at com.informix.jdbcx.IfxXASqli.receiveMessage(IfxXASqli.java:120)
         at com.informix.jdbc.IfxSqli.X(IfxSqli.java:7926)
         at com.informix.jdbc.IfxSqli.a(IfxSqli.java:854)
         at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.java:749)
         at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:293)
         at com.informix.jdbc.IfxStatement.c(IfxStatement.java:1269)
         at com.informix.jdbc.IfxStatement.b(IfxStatement.java:423)
         at com.informix.jdbc.IfxStatement.executeUpdate(IfxStatement.java:277)
         at com.informix.jdbc.IfxSqliConnect.setTransactionIsolation(IfxSqliConnect.java:2565)

  gotcha

  To avoid this issue:

  • Switch to a non-ANSI database.

  • If the error is triggered by an application, update the application such that it always runs in a global transaction.

• Informix Using IBM DB2 JDBC Universal Driver

  The Informix JDBC Driver is a Type 4 JDBC driver that is JDBC 3.0 compliant and provides access to the Informix database.

  This provider supports the following one-phase data source:

  com.ibm.db2.jcc.DB2ConnectionPoolDataSource

  The following JDBC driver files are required:

  db2jcc.jar
  db2jcc_license_cu.jar
  db2jcc_license_cisuz.jar

  as well as the following DataStoreHelper class:
  com.ibm.websphere.rsadapter.InformixJccDataStoreHelper

  This provider requires a valid authentication alias.

  The following properties are required:

  • serverName - The TCP/IP address or host name for the Informix server.

  • portNumber - The TCP/IP port number where the Informix server resides.

  • databaseName - The name of the database from which the data source obtains connections. Example: Sample.

• Informix Using IBM DB2 JDBC Universal Driver (XA)

  The Informix Using JDBC Driver (XA) is a Type 4 JDBC driver that is JDBC 3.0 compliant and provides XA-compliant JDBC access to the Informix database.

  This provider supports the following two-phase data source:

  com.ibm.db2.jcc.DB2XADataSource

  The following JDBC driver files are required:

  db2jcc.jar
  db2jcc_license_cu.jar
  db2jcc_license_cisuz.jar

  as well as the following DataStoreHelper class:
  com.ibm.websphere.rsadapter.InformixJccDataStoreHelper

  This provider requires a valid authentication alias.

  The following properties are required:

  • serverName - The TCP/IP address or host name for the Informix server.

  • portNumber - The TCP/IP port number where the Informix server resides.

  • databaseName - The name of the database from which the data source obtains connections. Example: Sample.

  Avoid trouble: We cannot use Informix XA data sources with ANSI databases if SQL statements are issued in local transactions instead of global transactions. This scenario might occur within the application code or within a component of Application Server such as scheduler. The following message might be logged if you are experiencing this problem:

  java.sql.SQLException: Already in transaction.
         at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:398)
         at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3247)
         at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3556)
         at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2382)
         at com.informix.jdbcx.IfxXASqli.receiveMessage(IfxXASqli.java:120)
         at com.informix.jdbc.IfxSqli.X(IfxSqli.java:7926)
         at com.informix.jdbc.IfxSqli.a(IfxSqli.java:854)
         at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.java:749)
         at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:293)
         at com.informix.jdbc.IfxStatement.c(IfxStatement.java:1269)
         at com.informix.jdbc.IfxStatement.b(IfxStatement.java:423)
         at com.informix.jdbc.IfxStatement.executeUpdate(IfxStatement.java:277)
         at com.informix.jdbc.IfxSqliConnect.setTransactionIsolation(IfxSqliConnect.java:2565)

  gotcha

Related tasks

Configure a JDBC provider and data source

Configure a JDBC provider using the administrative console

Configure a data source using the administrative console

Create a JDBC provider and data source using the JMX API

Related information:

IBM Informix product family Web pages