Hibernate 4
Was trying to have a small working PoC on Multi-tenancy in Hibernate 4.
All the Hibernate 4 dependencies have been 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, the 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 got some references over the net and found that the problem is due to the hsqldb.
Changed the dependency to the following
<dependency>
<groupId>org.hsqldb</groupId>
<artifactId>hsqldb</artifactId>
<version>2.2.8</version>
</dependency>
and it started working….