Connecting to a high-availability cluster through IBM Informix Connection Managers

Hi, I have a connection problem using java applications with jdbc through IBM Informix Connection Managers The situation is the following: I have a high-availability cluster (c1) that is composed of two servers. The user name on all cluster servers is user1 . The password on all cluster servers is pass1 . cm1 , on host1 uses the following configuration file for client redirection and failover NAME cm1 CLUSTER c1 { INFORMIXSERVER g_produ SLA oltp_1 DBSERVERS=PRIMARY \\ WORKERS=8 FOC ORDER=HDR PRIORITY=1 CMALARMPROGRAM ${INFORMIXDIR}/etc/cmalarmprogram.sh } cm2 , on host2 uses the following configuration file for client redirection and failover NAME cm2 CLUSTER c1 { INFORMIXSERVER g_produ SLA oltp_2 DBSERVERS=PRIMARY \\ WORKERS=8 FOC ORDER=HDR PRIORITY=2 CMALARMPROGRAM ${INFORMIXDIR}/etc/cmalarmprogram.sh } The sqlhost file is: produ_tcp group - - c=1,e=oltp_2 oltp_1 onsoctcp host1 9910 g=produ_tcp oltp_2 onsoctcp host2 9910 g=produ_tcp The url is: jdbc:informix-sqli://INFORMIXSERVER=produ_tcp;SQLH_TYPE=FILE;SQLH_FILE=sqlhosts;USER=user1;PASSWORD=pass1;INFORMIXCONRETRY=2; INFORMIXCONTIME=10;LOGINTIMEOUT=10when establishing the connection generates the error FAILED: failed to connect! ERROR: Invalid connection-type. java.sql.SQLException: Invalid connection-type. at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1404) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39) at java.lang.reflect.Constructor.newInstance(Constructor.java:516) at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243) at java.sql.DriverManager.getConnection(DriverManager.java:317) at java.sql.DriverManager.getConnection(DriverManager.java:273) at CreateDB.main(CreateDB.java:65) Caused by: com.informix.asf.IfxASFRemoteException: at com.informix.asf.Connection.recvConnectionResponse(Connection.java:664) at com.informix.asf.Connection.establishConnection(Connection.java:1520) at com.informix.asf.Connection.<init>(Connection.java:395) at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1398) Note: if the informix user is used in the connection, errors are not generated ------------------------------ Arnulfo Martinez Ruiz ------------------------------ #Informix

Arnulfo If the user: informix can connect to the database server using the same connection string and sqlhosts file, then I would hazard a guess that the issue lies either with... user: user1 not being able to locate the sqlhosts file user: user1 not having permission to read the sqlhosts file ...with reference to the sqlhosts file set using the SQLH_FILE variable in the JDBC connection string. I 'd start by comparing the environment settings for the two users, I would also make the following changes for your Connection Manager configuration... Set FOC ORDER=HDR to FOC ORDER=ENABLED in your cmsm.cfg file on your CM servers Set HA_FOC_ORDERto HDR from the default setting in your database server $ ONCONFIG file ...before restarting your Connection Manager. If you cannot change HA_FOC_ORDERwith onmode -wor -m , then you will have to restart your database server as well. ------------------------------ Kirit Rana ------------------------------