Install JDBC on IDS 14
Answered: green (solid confidence) — Asker was told to download the JDBC driver from the IBM developer-tools page or fetch the jar from Maven Central; he thanked the answerer, then found his real connection problem (-908) was a bad onconfig.
Advisory only.
Posted in 2021
Sh To asked how to install JDBC with IDS 14. SangGyu Jeong said it can be downloaded from the IBM Informix developer tools page; Oyvind Gjerstad advised fetching the jar or a Maven dependency (com.ibm.informix jdbc 4.50.4.1) from the Maven repository. Sh To then found the real problem was a Server Studio connection error -908, solved as a bad onconfig configuration.
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Java & JDBC Development
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
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 ------------------------------
Thanks a lot ------------------------------ Sh To ------------------------------
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 ------------------------------
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 ------------------------------
[Solved] Bad onconfig configuration Thanks ------------------------------ Sh To ------------------------------