Problem(Abstract)
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.
e. set CLASSPATH=c:\informix\ifxjdbc.jar
http://www-01.ibm.com/support/docview.wss?uid=swg21189718
'Informix > informix reference' 카테고리의 다른 글
Extracting hours, minutes or seconds from the difference of two datetime values (0) | 2014.05.13 |
---|---|
How to retrieve IBM Informix Server Configuration File settings from sysmaster (0) | 2014.04.24 |
SQL to find list of the tables in a particular chunk (0) | 2014.03.06 |
Chunk limitations (0) | 2014.01.14 |
Dynamic turning on and off of SQL Explain (0) | 2014.01.02 |