topic Connect to HSQL 2.50 in Installing and Upgrading

Connect to HSQL 2.50

Aldo1 — Fri, 15 Nov 2024 22:22:19 GMT

I'm in a situation where I need to connect to HSQL (HyperSQL) version 2.5 from Talend Open Studio 8.0

I created a, HSQL Server Db Connection and it auto-downloaded the driver from the repository. I know I have the configuration correct because every time I click the [Test Connection] button, I see an error message pop up on my HSQL Server process saying that I'm trying to connect with a 2.1 JDBC driver and the server version is 2.5.

If I look out on the Talend repository, I see that my Open Studio already downloaded what looks to be the "latest & greatest" driver they have for HSQL.

hsqldb-6.0.0.jar (Dated September 2020)

HSQL was using a 2.1 JDBC drivers around 2010.

So unless I'm mistaken, somewhere in that 2020 Talend jar file they compiled a 10 year-old 2.1 JDBC driver. . I did some experimentation and finally got Open Studio to connect to the HSQL server if I downgrade it all the way back to 2.3.3 (which came out in 2015). Unfortunately, a 2.3.3 HSQL server will not read a database created by a 2.5 server.

From the Modules view, it looks like every HSQL component is stored in that same single driver. Is there a way to use a more current Jar file for the connection... while Open Studio uses it's own jar file for everything else?

Re: Connect to HSQL 2.50

Anonymous — Mon, 14 Nov 2022 01:39:29 GMT

To use a more current hsqldb.jar, please download the jar from https://mvnrepository.com/artifact/org.hsqldb/hsqldb, re-name it to hsqldb.jar, then import it in the below Talend Modules view in the studio, it will override the old one, Thanks

Re: Connect to HSQL 2.50

Anonymous — Mon, 14 Nov 2022 03:57:27 GMT

Hello,

To override the existing library with the new version, please follow the instructions available in the Help Center.

https://help.talend.com/r/en-US/8.0/studio-user-guide-open-studio-for-data-integration/overriding-external-modules-by-customizing-mvn-uri

Best regards

Sabrina