Home
Client APIs and tools
You can use the HCL Informix® implementation of client APIs to develop applications for Informix database servers.
Informix® JDBC Driver Guide
The Informix® JDBC Driver Programmer's Guide describes how to install, load, and use Informix JDBC Driver to connect to the Informix database from within a Java™ application or applet.
Connect to the database
Connections to the servers of a high-availability cluster
Using the JDBC driver, Java™ applications can connect to HCL Informix® database servers in a high-availability cluster. Java applications can also connect to HCL Informix Connection Managers, which can handle failover for high-availability clusters and redirect connections to cluster servers.

Client APIs and tools
You can use the HCL Informix® implementation of client APIs to develop applications for Informix database servers.
- Change Data Capture API Programmer's Guide
  The Informix® Change Data Capture API Programmer's Guide describes how to program applications to process changed data from HCL Informix databases using the Informix Change Data Capture API.
- Embedded SQLJ for HCL Informix®
  The Informix® Embedded SQLJ User's Guide contains information about using Informix Embedded SQLJ.
- ESQL/C Guide
  The Informix® ESQL/C Programmer's Manual explains how to use Informix ESQL/C, the Informix implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
- GLS User's Guide
  The Informix® GLS User's Guide describes the Global Language Support (GLS) feature available in Informix products.
- API
  The Informix® GLS API Programmer's Guide describes the global language support (GLS) application programming interface (API) available in Informix ESQL/C and HCL Informix DataBlade® modules.
- Informix® Object Interface for C++ Guide
  The Informix® Object Interface for C++ Programmer's Guide describes how to develop HCL Informix client applications by using the object-oriented C++ programming language.
- Informix® ODBC Driver Guide
  The Informix® ODBC Driver Programmer's Manual serves as a user guide and reference for Informix ODBC Driver, which is the Informix implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
- .NET provider options
  The Data Server Provider for .NET DB2® provider option is the preferred Informix® provider for developing new applications.
- Informix® JDBC Driver Guide
  The Informix® JDBC Driver Programmer's Guide describes how to install, load, and use Informix JDBC Driver to connect to the Informix database from within a Java™ application or applet.
  - Getting started
  - Connect to the database
    - Load HCL Informix® JDBC Driver
    - A DataSource object
    - The DriverManager.getConnection() method
    - Informix® environment variables with the Informix® JDBC Driver
    - Dynamically reading the Informix® sqlhosts file
    - Connections to the servers of a high-availability cluster
      Using the JDBC driver, Java™ applications can connect to HCL Informix® database servers in a high-availability cluster. Java applications can also connect to HCL Informix Connection Managers, which can handle failover for high-availability clusters and redirect connections to cluster servers.
      - Properties for connecting to high-availability cluster servers through HCL Informix® Connection Managers
        A JDBC application can connect to Connection Manager, just as the application might connect to a database server. Application connection requests are then redirected to the most appropriate server in a high-availability cluster.
      - Properties for connecting to high-availability cluster servers through SQLHOST file group entries
        You can define sqlhost group entries, so that your application connection attempt is always directed to the primary server of a high-availability cluster, even if failover occurs.
      - Properties for connecting directly to an HDR pair of servers
        You can define your client application's connection URL or DataSource so that your application connects directly to an HDR pair of servers. If a connection attempt to the primary server fails, the client application can attempt to connect to the HDR secondary server.
      - Checks for read-only status of high-availability secondary servers
        You can write applications to check for read-only server status, so that update operations are not attempted on read-only secondary servers.
      - Connection retry attempts to HDR secondary servers
        You can write applications so that if a connection is lost during query operations, Informix® JDBC Driver returns a new connection to the secondary database server and the application reruns the queries.
    - An HTTP proxy server
    - Other multitier solutions
    - Encryption options
    - Using single sign-on access control with the Informix® JDBC Driver
    - PAM authentication method
    - Close the connection
  - Perform database operations
  - Work with Informix® types
  - Work with opaque types
  - Globalization and date formats
  - Push data feature
  - Tuning and troubleshooting
  - Appendixes
- Informix International Language Supplement (ILS) User Guide
  These topics include information about the translated user interface files for Informix® UNIX™ products, locales, and code set conversion tables
- Informix® OLE DB Provider Guide
  The Informix® OLE DB Provider Programmer's Guide describes the software requirements for using Informix OLE DB Provider, show how to install and configure the provider for your use, and explain how to use Informix OLE DB Provider to enable client applications, such as ActiveX Data Object (ADO) applications and web pages, to access data on the Informix server.

Connections to the servers of a high-availability cluster

Using the JDBC driver, Java™ applications can connect to HCL Informix® database servers in a high-availability cluster. Java™ applications can also connect to HCL Informix® Connection Managers, which can handle failover for high-availability clusters and redirect connections to cluster servers.

To connect your Java™ application to the servers of a high-availability cluster, you must set properties in the connection URL or DataSource. If the application performs update operations on secondary servers, configure the application to initially check for read-only server status.

When you configure HCL Informix® Connection Managers to handle connections between your Java™ application server and high-availability cluster, you get the following benefits:

You can direct connection requests to the most appropriate secondary server through rule-based redirection policies.
You can manage failover for your high-availability clusters, automatically promoting a secondary server to the role of primary server if the primary server fails.
You can prioritize connections between a specific application server and the primary server of your high-availability cluster when you install and configure HCL Informix® Connection Managers on the same hosts as your Java™ application servers.
When database servers are behind a firewall, HCL Informix® Connection Managers can act as proxy servers, and handle client/server communication.

You can use high-availability secondary servers with connection pooling. For more information, see High-Availability Data Replication with connection pooling.

Demonstration programs are available in the hdr directory within the demo directory where Informix® JDBC Driver is installed. For details about the files, see Sample code files.