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.  IDE 15.0.1.0 : JDBC could not open database table

    Posted Wed February 25, 2026 09:22 AM

    I've tested with DBeaver & RazorSQL, both failed.

    DBeaver:

    RazorSQL:

    DBeaver database snapshot:



    ------------------------------
    Baharuddin Masdar
    ------------------------------


  • 2.  RE: IDE 15.0.1.0 : JDBC could not open database table

    Posted Wed February 25, 2026 10:39 AM
    Are you using the v15.0.1 CSDK drivers?

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.







    Original Message


  • 3.  RE: IDE 15.0.1.0 : JDBC could not open database table

    Posted Wed February 25, 2026 11:05 AM
    Hi, 
    Pls state what version of JDBC driver you are using, and if the type of table is a "small" (compatible with older clients)
    or "large" (need 15.0+ drivers) one.
    If possible, write a small java program and get the full error (-242 does not mean anything useful
    without the ISAM error code).


    MARCUS HAARMANN



    Original Message


  • 4.  RE: IDE 15.0.1.0 : JDBC could not open database table

    Posted Thu February 26, 2026 05:55 AM

    Hi Marcus,

    For DBeaver, it's "Informix JDBC Driver for Informix Dynamic Server 4.50.JC10W1"

    Where do I possibly download the 15.0+ drivers?

    Thank you

    -bahar



    ------------------------------
    Baharuddin Masdar
    ------------------------------

    Original Message


  • 5.  RE: IDE 15.0.1.0 : JDBC could not open database table

    Posted Thu February 26, 2026 07:16 AM
    Baharuddin:

    Go to www.informix.com, click on the <Try Developer Edition> button, log in with your IBM ID, possibly answer a question of two about why you are going there, then you can download the v15 CSDK from that site. It is the trial site, but since the CSDK is free anyway the CSDK packages there are production releases.

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.







    Original Message


  • 6.  RE: IDE 15.0.1.0 : JDBC could not open database table

    Posted Fri February 27, 2026 02:16 AM

    If you are into java development and use maven as build tool, you can use this dependency:

    <!-- Source: https://mvnrepository.com/artifact/com.ibm.informix/jdbc -->
    <dependency>
        <groupId>com.ibm.informix</groupId>
        <artifactId>jdbc</artifactId>
        <version>15.0.1.0</version>
        <scope>compile</scope>
    </dependency>

    It will then be downloaded to your local maven repository.

    This also means that the jar file actually is available in your typical maven repository, for instance here:
    https://repo1.maven.org/maven2/com/ibm/informix/jdbc/15.0.1.0/jdbc-15.0.1.0.jar



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

    Original Message


  • 7.  RE: IDE 15.0.1.0 : JDBC could not open database table

    Posted 20 days ago

    Hi Øyvind Gjerstad,

    Thank you. The maven jdbc-15.0.1.0.jar works perfect. 

    Sorry for late reply, since I was on another project and need to find time to re-test this.

    best regards,

    -bahar



    ------------------------------
    Baharuddin Masdar
    ------------------------------

    Original Message


Related Content