SqLeo connect to DB but no info is delivered out.

[emezeta]

Hello,
SQLeo seems ok to get a db connection by setting up driver, etc. When we try to achieve, either schema o data information from database, it failure with some exception error messages, usually 'java.lang.NullPointerException' on scrren pop-up. SQLeo don't brake down, you can continue normal execution.

system ref.:

SQLeoVQB.2019.01.rc1 on Ubuntu 18.04 LTS
PostgreSql: pg_ctl (PostgreSQL) 9.6.19
Db Diver: PostgreSQL JDBC Driver, org.postgresql.jdbc, 42.2.14
Java: openjdk "11.0.8" 2020-07-14                                                                        

also postgresql-8.4-701.jdbc4.jar, similar results

Some output error traces in attach.
Thanks you.

[PAscal]

Hello,
when using java 11, there is a specific command line for startup:

see
https://sourceforge.net/p/sqleo/code/HEAD/tree/trunk/sqleo-start-Metal-Default-Java11.txt

that is:
java -cp "SQLeoVQB.jar;lib/*" com.sqleo.environment.Application

could you try it please and tell us ?

Regards
PAscal

[emezeta]

Thanks PAscal,
The output is:

~/setups/apps/SQLeoVQB.2019.01.rc1$ java -cp "SQLeoVQB.jar;lib/*" com.sqleo.environment.Application
Error: Could not find or load main class com.sqleo.environment.Application
Caused by: java.lang.ClassNotFoundException: com.sqleo.environment.Application

The ./lib folder contents:
~/setups/apps/SQLeoVQB.2019.01.rc1$ ls -l lib/

 173707 set 17  2017 csvjdbc-1.0-32.jar
  78030 ene 23  2019 javax.activation-JAF1.2.0.jar
 125632 ene 13  2019 jaxb-api-2.3.0.jar
 255502 ene 23  2019 jaxb-core-2.3.0.jar
 963660 ene 13  2019 jaxb-impl-2.3.0.jar
 932808 jul 22 20:22 postgresql-42.2.14.jar
 510170 set 21 12:40 postgresql-8.4-701.jdbc4.jar

[PAscal]

hummm strange ...
on my virtual 18.04.1-Ubuntu x86_64 machine:

installing java:
sudo apt install openjdk-11-jre-headless
...

checking java version:
java -version
openjdk version "11.0.8" 2020-07-14
OpenJDK Runtime Environment (build 11.0.8+10-post-Ubuntu-0ubuntu118.04.1)
OpenJDK 64-Bit Server VM (build 11.0.8+10-post-Ubuntu-0ubuntu118.04.1, mixed mode, sharing)

unziping package from sourceforge and launching same command:
ub64@ub64-Virtual-Machine:~/Downloads/SQLeoVQB.2019.01.rc1$ java -cp "SQLeoVQB.jar:lib/*" com.sqleo.environment.Application
SystemLookAndFeel: javax.swing.plaf.metal.MetalLookAndFeel
SQLeoUsingLookAndFeel: [The Java(tm) Look and Feel - javax.swing.plaf.metal.MetalLookAndFeel]
Loading resources...
Loading window...
HTTP status: 200
Server version:2019.01.rc1

could you confirm that your command is
java -cp "SQLeoVQB.jar:lib/" com.sqleo.environment.Application
and not
java -cp "SQLeoVQB.jar;lib/" com.sqleo.environment.Application

as described in file found in zip package
'sqleo-how to start.HELP

[Anonymous]

Old and presumably wrong configuration file causing the strange evil, finally solved.

rm -rf ~/.sqleo.config 

save may the day, month and year...
Thank you so much for your help. SQLeo is great, as you are guys!

ps. take it easy, I'm a little exaggerated ;)