#3 it is difficult to add new drivers

[Petr Slansky]

I use jisql utility to access JDBC databases from CLI, I use it for long time. I tried jdbcsql to compare it with jisql. I see it is difficult to add new database drivers to jdbcsql, archive has to be unziped, some configuration file edited, etc. It is difficult and it could be done in better way.
jisql have optional parameters those allow to use any JDBC driver in an easy way...

https://www.xigole.com/software/jisql/jisql.jsp
https://sourceforge.net/projects/jisql/

BTW, jisql has no problem with OpenJDK 11...

[Atanas Dichev]

My idea is all files to be capsulate in one jar/zip.
It's easy to copy, move and etc.

[Petr Slansky]

I understand that idea. Anyway, there could be an optional parameters that will allow to use external JDBC driver. It will allow easy test of newer version of JDBC driver or to allow to work in situation that part of servers were already updated to newer version of database and need different version of JDBC driver. With current design man has to create several versions of jdbcsql archive.

[Petr Slansky]

I am not java programmer and I needed several tries to find that I can experiement with different JDBC drivers without modification of "jar" archive. An example, how to test the latest postgresql JDBC driver.

I extracted jdbcsql.zip to new directory (like jdbcsql-test) and I moved to that directory:

mkdir jdbcsql-test; cd jdbcsql-test; unzip ../jdbcsql.zip

I can start jdbcsql directly and I can test my new postgresql JDBC driver (that is in ../jisql/jdbc directory)

java -cp .:commons-cli-1.2.jar:commons-csv-1.1.jar:../jisql/jdbc/postgresql-42.2.6.jar com.azsoftware.jdbcsql.Run -m postgresql -h ....... "SELECT COUNT(*) FROM pg_settings;"

Now I see, that I miss another parameter to see driver version. jisql has option "-driverinfo" . Because jdbcsql hides JDBC drivers in the jar archive, option to find details about embedded JDBC driver is really missing...

One more note. I cannot run "jar" archive with OpenJDK 11, it reports some error, I have to use OpenJDK 8. When I run jdbcsql directly as descibed few lines back (java -cp ... com.azsoftware.jdbcsql.Run -m postgresql ...), it works even with OpenJDK 11! So it looks like there is some compatibility problem in your jar file...

[Atanas Dichev]

Download the new version jdbcsql-1.0.zip. This version is compatible with jdk 11.