Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Can someone help me to connect Informix IDS with Spring Boot?

  • 1.  Can someone help me to connect Informix IDS with Spring Boot?

    Posted Wed February 09, 2022 06:56 PM
    Dear colleagues:

    I am trying to connect an Informix IDS 7.31 TD9 engine in a project created with Spring Boot via JDBC, but I am not getting my goal.

    I first tried Maven's Informix dependencies, but they all give me the same error: "Connection refused".

    I note that when you create a Spring Boot project, many databases appear, but not Informix.

    I checked the Hibernate documentation, which is Spring Boot's default persistence layer, and Informix does support it based on what they show.

    Then I tried the IBM DB2 JCC Driver, which according to its documentation is used to connect both DB2 and Informix, following its examples, but it gives me an error, it says that the database cannot be opened. The message that appears is the following: "Exception java.net.ConnectException: Error opening server socket localhost/127.0.0.1 on port 1.526 with message: Connection refused: no further information. ERRORCODE=-4499, SQLSTATE= 08001".

    Does anyone know the way to solve this?

    Thank you in advance for your attention.

    Greetings.

    Gustavo Echenique

    ------------------------------
    Gustavo Echenique
    ------------------------------

    #Informix


  • 2.  RE: Can someone help me to connect Informix IDS with Spring Boot?

    Posted Wed February 09, 2022 07:23 PM
    Gustavo:
    The problem with using the DV2 connector is that you are trying to connect to IDS v7.31 which proceeds the acquisition of Informix by IBM so it does not support the DRDA protocol DB2 uses. Similarly while Hibernate does have a native Informix connector, recent releases may no longer support the older protocol that IDS 7.31 used. Informix's native protocol changed with v9.20 to support new data types.

    Can you upgrade to the current Informix release? Version 14.10

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------

    Original Message


  • 3.  RE: Can someone help me to connect Informix IDS with Spring Boot?

    Posted Wed February 09, 2022 10:37 PM
    Can you telnet 127.0.0.1 1526

    If that gives a connection refused you have a firewall issue or you are on binding to the port you will think you are

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC



    Original Message


  • 4.  RE: Can someone help me to connect Informix IDS with Spring Boot?

    Posted Thu February 10, 2022 05:48 PM
    Dear Paul, thank you very much for your answer.

    I have tried to connect with telnet to the address 127.0.0.1 1526 and it has refused the connection.
    Then I tried "telnet localhost 1526" and the connection was also rejected (obviously if it had been rejected with the IP, this was expected).
    Only when I entered the PC name "telnet desarrollo 1526" was it able to connect.

    However, I have created inbound and outbound firewall rules for this port, but when I try to telnet (with the first two options) it keeps refusing the connection.

    If I add the name of the PC (desarrollo) to the Spring project instead of localhost in aplication.properties, it doesn't start Hikari, it hangs, the same if I add the IP address of the machine.

    I'm very confused.

    ------------------------------
    Gustavo Echenique
    ------------------------------

    Original Message


  • 5.  RE: Can someone help me to connect Informix IDS with Spring Boot?

    Posted Thu February 10, 2022 06:11 PM

    What does desarrollo resolve to ?   Remember localhost != desarrollo

     

    If everything is on the same PC and with everything running look at netstat –an to see what ports are bound to the ip and 127.0.0.1

     

    What is in INFORMIXSQLHOSTS and/or setnet32

     




    Original Message


  • 6.  RE: Can someone help me to connect Informix IDS with Spring Boot?

    Posted Thu February 10, 2022 09:21 PM
    Hi Paul!

    I pass you the result of the netstat -a command.
    The name of the IDS service is the one that comes by default (turbo).
    In the listing, I see that the Development PC connects to other ports.
    In Setnet32 the hostname is declared as Development.

    TCP 127.0.0.1:1526 Desarrollo:0 LISTENING
    TCP 127.0.0.1:1526 Desarrollo:53497 ESTABLISHED
    TCP 127.0.0.1:1526 Desarrollo:53523 ESTABLISHED
    TCP 127.0.0.1:1526 Desarrollo:53524 ESTABLISHED
    TCP 127.0.0.1:5278 Desarrollo:0 LISTENING
    TCP 127.0.0.1:5279 Desarrollo:0 LISTENING
    TCP 127.0.0.1:5280 Desarrollo:0 LISTENING
    TCP 127.0.0.1:6341 Desarrollo:0 LISTENING
    TCP 127.0.0.1:6342 Desarrollo:0 LISTENING
    TCP 127.0.0.1:21327 Desarrollo:0 LISTENING
    TCP 127.0.0.1:49802 Desarrollo:49803 ESTABLISHED
    TCP 127.0.0.1:49803 Desarrollo:49802 ESTABLISHED
    TCP 127.0.0.1:53493 Desarrollo:54926 ESTABLISHED
    TCP 127.0.0.1:53497 Desarrollo:turbo ESTABLISHED
    TCP 127.0.0.1:53523 Desarrollo:turbo ESTABLISHED
    TCP 127.0.0.1:53524 Desarrollo:turbo ESTABLISHED


    ------------------------------
    Gustavo Echenique
    ------------------------------

    Original Message


  • 7.  RE: Can someone help me to connect Informix IDS with Spring Boot?

    Posted Thu February 10, 2022 09:38 PM
    So you are only listening on localhost so IP connection will fail. Edit sqlhosts or use setnet32 to use the ip instead 

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC



    Original Message


  • 8.  RE: Can someone help me to connect Informix IDS with Spring Boot?

    Posted Fri February 11, 2022 05:45 PM
    Hi Paul!
    I seem to have resolved the port directionality issue, since running the command netstat -a | findstr "1526", I get the following output:
    TCP 192.168.100.12:1526 Development:0 LISTENING

    What catches my attention is that I run Setnet32 as a normal user, the following data appears:

    But if I run it as administrator, the data is as follows, and it should be correct:

    When running the Spring project I am getting the following errors:
    Caused by: com.informix.asf.IfxASFException: Attempt to connect to database server (ol_gechenique) failed.
at com.informix.util.IfxErrMsg.getLocIfxASFException(IfxErrMsg.java:751) ~[jdbc-4.10.6.20151104.jar:4.1.0.SNAPSHOT]
at com.informix.asf.Connection.openSocket(Connection.java:1821) ~[jdbc-4.10.6.20151104.jar:4.1.0.SNAPSHOT]
at com.informix.asf.Connection.<init>(Connection.java:395) ~[jdbc-4.10.6.20151104.jar:4.1.0.SNAPSHOT]
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1404) ~[jdbc-4.10.6.20151104.jar:4.1.0.SNAPSHOT]
... 56 common frames omitted
Caused by: java.lang.IllegalArgumentException: hostname can't be null
at java.base/java.net.InetSocketAddress.checkHost(InetSocketAddress.java:159) ~[na:na]
at java.base/java.net.InetSocketAddress.<init>(InetSocketAddress.java:226) ~[na:na]
at com.informix.asf.Connection.getSocket(Connection.java:2160) ~[jdbc-4.10.6.20151104.jar:4.1.0.SNAPSHOT]
at com.informix.asf.Connection.openSocket(Connection.java:1783) ~[jdbc-4.10.6.20151104.jar:4.1.0.SNAPSHOT]
... 58 common frames omitted

​

    I have already checked the Windows registry (10) and in the Sqlhosts key, the data is correct, as in the second screen that I copied.



    ------------------------------
    Gustavo Echenique
    ------------------------------

    Original Message


  • 9.  RE: Can someone help me to connect Informix IDS with Spring Boot?

    Posted Fri February 11, 2022 05:57 PM
    That looks like -908 error, normally a mismatch between ip, port and/or INFORMIXSERVER. Easy to test using dbping or ilogin 

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC



    Original Message


  • 10.  RE: Can someone help me to connect Informix IDS with Spring Boot?

    Posted Fri February 11, 2022 08:12 PM
    Paul, the iLogin Demo connects and shows me the records of the Stores7 database, but now the SQL Editor does not connect to me, which it did until today.

    I don't know what to think or what to modify, I'm very confused. Never in my 21 years of working with Informix has anything like this happened to me.

    ------------------------------
    Gustavo Echenique
    ------------------------------

    Original Message


  • 11.  RE: Can someone help me to connect Informix IDS with Spring Boot?

    Posted Thu February 10, 2022 06:44 PM
    I'm guessing that your sqlhosts file has the name of the machine in the IP field and not 127.0.0.1 (localhost). That is why you can connect using the machine name which maps to its actual IP address and not to localhost.

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------

    Original Message


  • 12.  RE: Can someone help me to connect Informix IDS with Spring Boot?

    Posted Thu February 10, 2022 02:16 AM

    We are downloading Informix JDBC driver with maven but not with spring boot, and with newer IDS version, so this process works, at least. Hibernate is relying on whatever JDBC driver you are supplying, it does not have its own connector. It does take some configuration, though.
    "Connection refused" normally means that no-one is listening on the port you are connecting to. But it can also be local firewall issues. The telnet test mentioned by others is good to verify that you can actually connect. Maybe you can do a netstat -na | grep 1526 to verify that your Informix instance is listening on this port? 



    ------------------------------
    Øyvind Gjerstad
    Developer/Architect
    PostNord AS
    ------------------------------

    Original Message