JDBC connection to HDR group (databases)
Posted in 2011
Folks, IDS11.50 FC8, Redhat Linux. CSDK 3.70 FC1 IBM Informix JDBC Driver Version 3.70.JC1 We tried to use JDBC to conenct to a HDR databases( primary/secondary) . We specified the server as group name ( not primary or secondary server name) for automatic failover purpose( see attached error). Our sqlhosts files has, g_goesr group - - i=26 nsofgoesrp_tcp onsoctcp franklin-dat online9136 g=g_goesr nsofgoesrs_tcp onsoctcp stephanie-dat online9146 g=g_goesr The Connection clause is wrong format ? Any answer? Thanks, Frank java gov.noaa.cls.dbtest.ConnectionTest jdbc:informix-sqli:informixserver=g_goesr;SQLH_TYPE=FILE;SQLH_FILE=/usr/informix /etc/sqlhosts java.sql.SQLException: Message text will be provided in later releases java.lang.NullPointerException at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:488) at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1378) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorI mpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorA ccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:254) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154) at gov.noaa.cls.dbtest.ConnectionTest.loop(ConnectionTest.java:48) at gov.noaa.cls.dbtest.ConnectionTest.main(ConnectionTest.java:28) Caused by: java.lang.NullPointerException * at com.informix.asf.Connection.prepareIP_PortInfo(Connection.java:2089)* at com.informix.asf.Connection.prepareForConnect(Connection.java:2020) at com.informix.asf.Connection.<init>(Connection.java:327) at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1004) ... 9 more --0015175885403f390904b2fb7d86