JDBC connection to HDR group (databases)
Posted in 2011
Topics: High Availability & Replication, Connectivity: ODBC / JDBC / .NET, Networking & sqlhosts Configuration, Java & JDBC Development
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