Update HSQLDB version [SPR-10947]

[spring-projects-issues]

Rob Winch opened SPR-10947 and commented

We are still using hsqldb:hsqldb:1.8.0.10, but there is a new version with new group id is available org.hsqldb:hsqldb:2.3.0

Currently when using embedded database support, a NoSuchMethodException is thrown.

We should consider dropping support for 1.8 (which was last updated in 2009) and update to allow supporting the latest version.

---

Referenced from: commits d9c4470

[spring-projects-issues]

Juergen Hoeller commented

We don't seem to have a hard dependency on HSQLDB API in our codebase... We rather just have JDBC URLs and SQL statements in several HSQL adapter classes, and we're using HSQLDB in some of our integration tests.

As far as I could tell with a few local runs, our build basically works when running against HSQLDB 2.3.0. The spring-orm tests hang and there are a few SQL syntax errors in spring-jdbc and spring-test. However, none of those suggest an incompatibility in our HSQLDB support - it's just in our tests, with some SQL statement separators apparently not supported in 2.3.0 anymore.

I couldn't reproduce the NoSuchMethodError locally. According to several online forums, it can apparently be caused by having both HSQLDB 2.3 and 1.8 jars on the classpath. Due to the difference in the repository group ("hsqldb" vs "org.hsqldb"), Maven wouldn't resolve the mismatch automatically.

As a consequence, I'm turning this into a minor build-related to-do for 4.0 RC2. It's really just about having our tests based on a recent version of HSQLDB.

Juergen

[spring-projects-issues]

Rob Winch commented

Juergen Hoeller Thanks for the response. It is quite likely that my issue was due to having multiple hsqldb's on my classpath as I was knee deep in trying to resolve another problem at the time.