IBM Support

How to get version of Informix JDBC Driver

Troubleshooting


Problem

How to get the version of Informix JDBC driver without writing any code

Resolving The Problem


INTRODUCTION

Most customers using Informix products are used to having an option which gives them the version of the product being used. This is usually done at the command line using the "-V" option or using a special utility.

For example: esql -V would give the version of esql or the utility ifx_getversion can be used to display the version of the ClientSDK.

It is also possible to obtain the version of the JDBC driver contained in the ifxjdbc.jar file from the command line.


BEFORE YOU BEGIN

Make sure you have set the CLASSPATH variable correctly to include the location of ifxjdbc.jar ( or ifxjdbc-g.jar ) and that your PATH has the JDK in it.


STEPS

Execute the following

    java com.informix.jdbc.Version

The following examples shows sample output.
    % java com.informix.jdbc.Version
    IBM Informix JDBC Driver Version 2.21.JC5


COMMON PROBLEM

Symptom :
Exception in thread "main" java.lang.NoClassDefFoundError: com/informix/jdbc/Version

Resolution:
Make sure that ifxjdbc.jar is in your CLASSPATH. If you see ifxjdbc.jar in the CLASSPATH, make sure that ifxjdbc.jar exists in the location specified.

[{"Product":{"code":"SSVT2J","label":"Informix Tools"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Informix JDBC","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF025","label":"Platform Independent"},{"code":"PF008","label":"DYNIX\/ptx"},{"code":"PF010","label":"HP-UX"},{"code":"PF015","label":"IRIX"},{"code":"PF016","label":"Linux"},{"code":"PF026","label":"Reliant UNIX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"1.0;1.1;1.2;1.3;1.4;1.5;1.6;2.0;2.1;2.2;2.3;2.4;2.5;2.6;2.7;2.8;2.9;3.0;4.0;4.1;4.2;5.1;6.0;7.2;7.3","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 June 2018

UID

swg21189718