Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
