Trying to load informix driver using sqlline 1.0.2

[palmerj]

On Ubuntu 22.04:

sqlline -d com.informix.jdbc.IfxDriver -u "jdbc:informix-sqli://hostname:port/database:INFORMIXSERVER=db_int" --verbose=yes
[warning] /usr/bin/sqlline: Unable to locate postgresql-jdbc4 in /usr/share/java
[warning] /usr/bin/sqlline: Unable to locate mariadb-java-client in /usr/share/java
[warning] /usr/bin/sqlline: Unable to locate jtds in /usr/share/java
issuing: !connect jdbc:informix-sqli://hostname:port/database:INFORMIXSERVER=db_int '' '' com.informix.jdbc.IfxDriver
Connecting to jdbc:informix-sqli://hostname:port/database:INFORMIXSERVER=db_int
java.lang.ClassNotFoundException: com.informix.jdbc.IfxDriver
        at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)
        at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
        at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)
        at java.base/java.lang.Class.forName0(Native Method)
        at java.base/java.lang.Class.forName(Class.java:315)
        at sqlline.SqlLine$DatabaseConnection.connect(Unknown Source)
        at sqlline.SqlLine$DatabaseConnection.getConnection(Unknown Source)
        at sqlline.SqlLine$Commands.connect(Unknown Source)
        at sqlline.SqlLine$Commands.connect(Unknown Source)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at sqlline.SqlLine$ReflectiveCommandHandler.execute(Unknown Source)
        at sqlline.SqlLine.dispatch(Unknown Source)
        at sqlline.SqlLine.initArgs(Unknown Source)
        at sqlline.SqlLine.begin(Unknown Source)
        at sqlline.SqlLine.mainWithInputRedirection(Unknown Source)
        at sqlline.SqlLine.main(Unknown Source)
sqlline version 1.0.2 by Marc Prud'hommeaux

I've even tried setting the classpath to ensure the classes are picked up: export CLASSPATH=$CLASSPATH:/home/ssm-user/jdbc-4.50.4.1.jar:/home/ssm-user/bson-4.2.0.jar

Any ideas?

[snuyanzin]

sqlline version 1.0.2 by Marc Prud'hommeaux

is there a reason why you are using so old version?

[palmerj]

It was packaged for use in Ubuntu.