IDE 15.0.1.0 : JDBC could not open database table
Baharuddin Masdar could not open a table with JDBC from DBeaver and RazorSQL against Informix 15.0.1.0, using JDBC driver 4.50.JC10W1. Art Kagel and Marcus Haarmann pointed to needing 15.0+ drivers for large tables; Art said the v15 CSDK is downloadable from the Developer Edition site. Oyvind Gjerstad gave the Maven jdbc 15.0.1.0 dependency, which Baharuddin confirmed worked. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I've tested with DBeaver & RazorSQL, both failed. DBeaver: RazorSQL: DBeaver database snapshot: ------------------------------ Baharuddin Masdar ------------------------------
Are you using the v15.0.1 CSDK drivers? Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ 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.
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
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 ------------------------------
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 www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ 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.
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 ------------------------------
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 ------------------------------