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
  • 1.  Install JDBC on IDS 14

    Posted 04/07/21 02:43 AM
    Edited by System Admin 01/20/23 04:41 PM

    Hello,

     

    I'm a little confused.

    How do I install JDBC?

    In the IBM doc (6a), I can see that it's possible to install JDBC during the installation process of IDS 14,
    https://www.ibm.com/docs/en/informix-servers/14.10/14.10?topic=installing-preparing-installation in the typical installation.

    If yes, why not in custom install?

     

    On the other side, in this video

    https://youtu.be/xsylAz5U1sY?t=604

    I can see "No JDBC directory"

     

    And here,

    https://community.ibm.com/community/user/hybriddatamanagement/communities/community-home/digestviewer/viewthread?GroupId=4147&MessageKey=a59dc8cf-e1c2-4025-ae3e-cd7fb36d76b1&CommunityKey=cf5a1f39-c21f-4bc4-9ec2-7ca108f0a365&tab=digestviewer

    It said that it's possible to download from here

    https://mvnrepository.com/artifact/com.ibm.informix/jdbc/4.50.4.1

    This file

    jdbc-4.50.4.1.jar

     

    And finally
    https://www.ibm.com/docs/en/informix-servers/14.10/14.10?topic=driver-installing-jdbc-in-graphical-console-mode

    the command for install is

    java -jar dir/setup.jar -i console

    do I need to run like this?

    java -jar jdbc-4.50.4.1.jar  -i console

     

    So, what is the right/simple way for installing JDBC ?

    Thanks



    ------------------------------
    Sh To
    ------------------------------
    #Informix


  • 2.  RE: Install JDBC on IDS 14

    Posted 04/07/21 09:42 PM
    Hello. It can be downloaded through the Informix JDBC link on the site below.

    https://www.ibm.com/products/informix/developer-tools

    I just tried it and I was able to get the ibm.jdbc.4.50.JC5.ALL.tar file.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 3.  RE: Install JDBC on IDS 14

    Posted 04/08/21 12:27 AM
    Thanks a lot

    ------------------------------
    Sh To
    ------------------------------



  • 4.  RE: Install JDBC on IDS 14

    Posted 04/08/21 03:13 AM

    The simplest, especially if you are using maven for building, is to just get it from the main maven repository (https://repo1.maven.org/maven2), as part of the normal build procedure.

    Add this to pom.xml:

    <dependency>
    <groupId>com.ibm.informix</groupId>
    <artifactId>jdbc</artifactId>
    <version>4.50.4.1</version> <!-- or whatever version you are interested in -->
    <scope>compile</scope>  <!-- or test, depends on your requirements -->
    </dependency>

    Since it is available here, it is also possible to simply download the required jar file from, say
    https://repo1.maven.org/maven2/com/ibm/informix/jdbc/4.50.4.1/jdbc-4.50.4.1.jar



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



  • 5.  RE: Install JDBC on IDS 14

    Posted 04/08/21 03:57 AM
    Hello

    In fact I just have connection problem with Server Studio after i upgraded IDS to 14
    I thought that it was a JDBC problem.

    But it s not.
    Will try to figure out why it doesn't connect (error -908)

    Thanks

    ------------------------------
    Sh To
    ------------------------------



  • 6.  RE: Install JDBC on IDS 14

    Posted 04/12/21 03:53 AM
    [Solved]

    Bad onconfig configuration

    Thanks

    ------------------------------
    Sh To
    ------------------------------