Over a million developers have joined DZone.
Platinum Partner

Resolving a HSQLDB Exception in Hibernate 4

The Performance Zone is brought to you in partnership with New Relic. Quickly learn how to use Docker and containers in general to create packaged images for easy management, testing, and deployment of software.

Recently I was trying to have a small working PoC on a multi-tenancy in Hibernate 4.

All the Hibernate 4 dependencies were declared in the pom.xml including the hsqldb.

<dependency>
<groupId>hsqldb</groupId>
<artifactId>hsqldb</artifactId>
<version>1.8.0.10</version>
</dependency>

When the application was tested, it threw the following exception:

org.hibernate.exception.GenericJDBCException: This function is not supported
Caused by: java.sql.SQLException: This function is not supported

Then, as usual, I got some references over the net and found that the problem is due to the hsqldb.

So I changed the dependency to the following:

<dependency>
<groupId>org.hsqldb</groupId>
<artifactId>hsqldb</artifactId>
<version>2.2.8</version>
</dependency>

And it started working!


The Performance Zone is brought to you in partnership with New Relic. Read more about providing a framework that gets you started on the right path to move your IT services to cloud computing, and give you an understanding as to why certain applications should not move to the cloud.

Topics:

Published at DZone with permission of Jagannathan Asokan , DZone MVB .

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}