Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.
+5 votes
1 view

I am installing the 6.2RC on my ubuntu18.04 server with mysql via installer.

I already installed 6.1 and it works then i stopped that and tried to install the RC on a new directory and i am getting this error after i select mysql and entered the credentials. java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
 

Thank you 

Environment knowage 6.2, Ubuntu, mysql
in Installer by (290 points)
Same issue installing version 6.2 RC. I'm also using mysql as backend.
I have the same issue in Centos 6. Installing version 6.2 RC on Mysql 5.7

Please, you it solved?

Thank you

Juan
I'm having the same issue with Knowage 6.4.1

My environment is OpenSuse 42.3, MariaDB 10.4.7, JDK 1.8.0_221

Tried a lot of stuff, all the fixes in the forum, etc. always the same error.

I would appreciate any tips.

Thanks

Gabriel

4 Answers

+3 votes
Dear

We've installed knowage 6.2 on Ubuntu 18, could you download the last version ?

best Regards

Angelo
by (20.7k points)
I am trying with 6.2 (on Ubuntu 14.04 I admit) and I am having the same error.

Is this due to a missing/misaligned hsldbXXX.jar?

Thanks for any hint
Hi, same error with ubuntu 18.04 and on another machine with lubuntu.

All requirements are good (jdk, classpath, mariadb/mysql, etc...)

Any help ?

Thank you.
0 votes
Hi,

I am getting the same error.

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)

Thanks in advance
by (220 points)
0 votes

Hello,

I am having the same frustrating message from about five days now. I am pretty sure enviroment was properly set up: Ubuntu 18.04 - Oracle Java  1.8.0_191 and Mysql 5.7.

I am going to install Knowage-6_2_1-CE-Installer-Unix-20180926.
I am having the same error with each 6.2 version I can download from your repository, while I can successfully install any 6.1 version.
Please can you provide a check list to find out the missing or wrong configuration step?

I have also another question: in the setup wizard I choose the Mysql Database enviroment, but the installer is looking for hsqldb JDBC driver. Is this right?

Thank you very much
Enzo Stefanazzi

=====================================================
Exception:

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)
   .....

System properties:

java.runtime.name=Java(TM) SE Runtime Environment
exe4j.moduleName=/home/enzo/java/knowage/setup/Knowage-6_2_1-CE-Installer-Unix-20180926.sh
sun.boot.library.path=/usr/lib/jvm/java-8-oracle/jre/lib/amd64
java.vm.version=25.191-b12
java.vm.vendor=Oracle Corporation
java.vendor.url=http://java.oracle.com/
path.separator=:
java.vm.name=Java HotSpot(TM) 64-Bit Server VM
file.encoding.pkg=sun.io
user.country=IT
sun.java.launcher=SUN_STANDARD
sun.os.patch.level=unknown
install4j.exeDir=/home/enzo/java/knowage/setup/
java.vm.specification.name=Java Virtual Machine Specification
user.dir=/home/enzo/java/knowage/setup/Knowage-6_2_1-CE-Installer-Unix-20180926.sh.3843.dir
java.runtime.version=1.8.0_191-b12
java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment
i4jv=0
java.endorsed.dirs=/usr/lib/jvm/java-8-oracle/jre/lib/endorsed
os.arch=amd64
java.io.tmpdir=/tmp
line.separator=

java.vm.specification.vendor=Oracle Corporation
os.name=Linux
exe4j.totalDataLength=1966151757
sun.java2d.noddraw=true
sun.jnu.encoding=UTF-8
java.library.path=/home/enzo/java/knowage/setup/Knowage-6_2_1-CE-Installer-Unix-20180926.sh.3843.dir/user::/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
sun.awt.enableExtraMouseButtons=true
java.specification.name=Java Platform API Specification
java.class.version=52.0
sun.management.compiler=HotSpot 64-Bit Tiered Compilers
os.version=4.15.0-39-generic
i4j.vpt=true
install4j.cwd=/home/enzo/java/knowage/setup
user.home=/home/enzo
user.timezone=Europe/Rome
java.awt.printerjob=sun.print.PSPrinterJob
file.encoding=UTF-8
install4j.jvmDir=/usr/lib/jvm/java-8-oracle/jre
java.specification.version=1.8
java.class.path=i4jruntime.jar
user.name=enzo
java.vm.specification.version=1.8
sun.java.command=com.install4j.runtime.launcher.UnixLauncher launch 0   com.install4j.runtime.installer.Installer
java.home=/usr/lib/jvm/java-8-oracle/jre
sun.arch.data.model=64
user.language=it
java.specification.vendor=Oracle Corporation
awt.toolkit=sun.awt.X11.XToolkit
java.vm.info=mixed mode
java.version=1.8.0_191
java.ext.dirs=/usr/lib/jvm/java-8-oracle/jre/lib/ext:/usr/java/packages/lib/ext
sun.boot.class.path=/usr/lib/jvm/java-8-oracle/jre/lib/resources.jar:/usr/lib/jvm/java-8-oracle/jre/lib/rt.jar:/usr/lib/jvm/java-8-oracle/jre/lib/sunrsasign.jar:/usr/lib/jvm/java-8-oracle/jre/lib/jsse.jar:/usr/lib/jvm/java-8-oracle/jre/lib/jce.jar:/usr/lib/jvm/java-8-oracle/jre/lib/charsets.jar:/usr/lib/jvm/java-8-oracle/jre/lib/jfr.jar:/usr/lib/jvm/java-8-oracle/jre/classes
install4j.appDir=/home/enzo/java/knowage/setup/
java.vendor=Oracle Corporation
file.separator=/
java.vendor.url.bug=http://bugreport.sun.com/bugreport/
sun.font.fontmanager=sun.awt.X11FontManager
sun.io.unicode.encoding=UnicodeLittle
sun.cpu.endian=little
install4j.showProxyConfig=true
install4j.systemLanguage=it
install4j.keepLog=true
sun.desktop=gnome
sun.cpu.isalist=

by (200 points)
0 votes

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

by (1.0k points)
...