Ubuntu installation failed

Question

During the installation of knowage  7.1.5 on Ubuntu 18.04, when tried to connect installed MySQL I received the error:

java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;

Did anyone have same issue? and how you resolved the problem&

Comments

Dear,

if you are using hsqldb as metadata DB I can tell you that is not certified for our environment as you can read in the documentation:
https://knowage-suite.readthedocs.io/en/master/installation-guide/requirements.html#database-schema-for-metadata

If you are trying to use it as a datasource try to use a different hsqldb driver.

Regards.

Davide

---

Hello,

I'm facing the same chingis issue. I've followed the video installation for linux user available on youtube. I've set the java_home varabiles and installed all the depedency (mysql, tomcat). I'm not using hsqldb but i've this kind of problem. Am I wrong with some installation steps?

Thank you for your reply.

Best regards,

Daniele M.

Answer 1

It is because of duplicate of hsqldb.jar in installer classpath. 

Workaround:

1. Run installer as normal
2. Right before config RDBMS steps. 
Database Management System Configuration
Use an already installed DBMS [1, Enter]
1
Select DBMS for metadata:
MariaDB [1, Enter]
MySQL [2]

3. Delete hsqldb.jar in temporary extracted installer dir (in my case: /home/apps/Knowage-7_2_0-CE-Installer-Unix-20200730.sh.14611.dir)

rm /home/apps/Knowage-7_2_0-CE-Installer-Unix-20200730.sh.14611.dir/user/hsqldb.jar

4. Continue installation