#1 jdbcsql doesn't work with OpenJDK 11

[Petr Slansky]

jdbcsql doesn't work with OpenJDK 11 (sudo apt install default-jdk, or sudo apt install openjdk-11-jdk)
I run Ubuntu 18.04.

user@test:~$ java -version
openjdk version "11.0.4" 2019-07-16
OpenJDK Runtime Environment (build 11.0.4+11-post-Ubuntu-1ubuntu218.04.3)
OpenJDK 64-Bit Server VM (build 11.0.4+11-post-Ubuntu-1ubuntu218.04.3, mixed mode, sharing)

user@test:~$ java -jar jdbcsql.zip
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/cli/ParseException
    at java.base/java.lang.Class.forName0(Native Method)
    at java.base/java.lang.Class.forName(Class.java:398)
    at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:56)
Caused by: java.lang.ClassNotFoundException: org.apache.commons.cli.ParseException
    at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:471)
    at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:588)
    at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
    ... 3 more

I tried it with OpenJDK 8 and it works (sudo apt install openjdk-8-jdk)

user@test:~$ java -version
openjdk version "1.8.0_222"
OpenJDK Runtime Environment (build 1.8.0_222-8u222-b10-1ubuntu1~18.04.1-b10)
OpenJDK 64-Bit Server VM (build 25.222-b10, mixed mode)

user@test:~$ java -jar jdbcsql.zip
jdbcsql execute queries in diferent databases such as mysql, oracle, postgresql and etc.
Query with resultset output over stdout in CSV format.

usage: jdbcsql [OPTION]... SQL
 -?,--help                         show this help, then exit
 -d,--dbname <DBNAME>              database name to connect
 -f,--csv-format <FORMAT>          Output CSV format (EXCEL, MYSQL,
                                   RFC-4180 and TDF). Default is RFC-4180
 -h,--host <HOSTNAME>              database server host
 -H,--hide-headers                 hide headers on output
 -m,--management-system <SYSTEM>   database management system (mysql,
                                   oracle, postgresql ...)
 -p,--port <PORT>                  database server port
 -P,--password <PASSWORD>          database password
 -s,--separator <SEPARATOR>        column separator (default: "\t")
 -U,--usernme <USERNAME>           database user name

I tried it with "IBM" Java and it works. (sudo apt install ibm-java80-jre)

user@test:~$ java -version
java version "1.8.0_211"
Java(TM) SE Runtime Environment (build 8.0.5.35 - pxa6480sr5fp35-20190418_01(SR5 FP35))
IBM J9 VM (build 2.9, JRE 1.8.0 Linux amd64-64-Bit Compressed References 20190417_414854 (JIT enabled, AOT enabled)
OpenJ9   - 777635f
OMR      - 16b77d7
IBM      - 72459d3)
JCL - 20190409_01 based on Oracle jdk8u211-b25

user@test:~$ java -jar jdbcsql.zip
jdbcsql execute queries in diferent databases such as mysql, oracle, postgresql and etc.
Query with resultset output over stdout in CSV format.

usage: jdbcsql [OPTION]... SQL
 -?,--help                         show this help, then exit
 -d,--dbname <DBNAME>              database name to connect
 -f,--csv-format <FORMAT>          Output CSV format (EXCEL, MYSQL,
                                   RFC-4180 and TDF). Default is RFC-4180
 -h,--host <HOSTNAME>              database server host
 -H,--hide-headers                 hide headers on output
 -m,--management-system <SYSTEM>   database management system (mysql,
                                   oracle, postgresql ...)
 -p,--port <PORT>                  database server port
 -P,--password <PASSWORD>          database password
 -s,--separator <SEPARATOR>        column separator (default: "\t")
 -U,--usernme <USERNAME>           database user name

[Atanas Dichev]

Thе version jdbcsql-1.0.zip is compatible with jdk 11.