IBM Support

How to configure an Informix JDBC connection string to connect to a group

Question & Answer


Question

What needs to be included in an Informix connection string to connect to the database server using a group?

Answer

To connect to an Informix database via a group, your Informix JDBC connection string should include the following parameters:
jdbc:informix-sqli://informixserver=<group_name>;database=<dbname>;user=<username>;password=<password>;SQLH_TYPE=FILE;SQLH_FILE=<absolute_path_to_your_sqlhosts_file>";

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSVT2J","label":"Informix Tools"},"Component":"Informix JDBC driver","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"3.70;4.10;4.50","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
21 January 2021

UID

ibm11104555