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

Question

I'm getting this error on CentOS 6.10 x64 for v6.40 & 6.3.1

An error occurred:
java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
Error log: /opt/install4jError2164568107528988552.log
java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
        at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.install4j.runtime.installer.helper.Install4jClassLoader$CustomCodeInvoker.invoke(Install4jClassLoader.java:165)
        at com.install4j.runtime.installer.helper.Install4jClassLoader.invokeInCustomClassLoader(Install4jClassLoader.java:156)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.createConnection(AbstractJdbcAction.java:139)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.withConnection(AbstractJdbcAction.java:201)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.withStatement(AbstractJdbcAction.java:176)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.withResultSet(AbstractJdbcAction.java:153)
        at com.install4j.runtime.beans.actions.jdbc.CheckJdbcConnectionAction.executeJdbcCall(CheckJdbcConnectionAction.java:32)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.execute(AbstractJdbcAction.java:95)
        at com.install4j.runtime.beans.actions.SystemInstallOrUninstallAction.install(SystemInstallOrUninstallAction.java:29)
        at com.install4j.runtime.installer.ContextImpl$7.executeAction(ContextImpl.java:1668)
        at com.install4j.runtime.installer.ContextImpl$7.fetchValue(ContextImpl.java:1659)
        at com.install4j.runtime.installer.ContextImpl$7.fetchValue(ContextImpl.java:1656)
        at com.install4j.runtime.installer.helper.comm.actions.FetchObjectAction.execute(FetchObjectAction.java:14)
        at com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionDirect(HelperCommunication.java:274)
        at com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionInt(HelperCommunication.java:249)
        at com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionChecked(HelperCommunication.java:187)
        at com.install4j.runtime.installer.helper.comm.HelperCommunication.fetchObjectChecked(HelperCommunication.java:170)
        at com.install4j.runtime.installer.ContextImpl.performActionIntStatic(ContextImpl.java:1656)
        at com.install4j.runtime.installer.InstallerContextImpl.performActionInt(InstallerContextImpl.java:151)
        at com.install4j.runtime.installer.ContextImpl.performAction(ContextImpl.java:1103)
        at com.install4j.runtime.installer.controller.Controller.executeAction(Controller.java:368)
        at com.install4j.runtime.installer.controller.Controller.executeActions(Controller.java:334)
        at com.install4j.runtime.installer.controller.Controller.handleCommand(Controller.java:195)
        at com.install4j.runtime.installer.controller.Controller.start(Controller.java:94)
        at com.install4j.runtime.installer.Installer.runInProcess(Installer.java:59)
        at com.install4j.runtime.installer.Installer.main(Installer.java:46)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:65)
        at com.install4j.runtime.launcher.UnixLauncher.main(UnixLauncher.java:57)

java home

# env | grep -i java
JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.212.b04-0.el6_10.x86_64/jre/bin

How do  solve this?

Answer 1

me too. is there any fix?

Answer 2

Did you added the hsqldb jar into the TOMCAT_HOME/lib directory? Looks like its trying to use those classes.

Answer 3

Did you find a fix for this? I'm getting the same error with 7.x.x setup.

Answer 4

Hi guys!

There is a problem in installer, try to choose mysql instead of mariadb. It helped me

Answer 5

Yup getting this error too. I tried in 6.4.1 and 7.1.7. Ubuntu 18.04 environment

Answer 6

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