Hibernate HSQL Exception : This function is not supported

I was testing hibernate with HSQL ..  and during the runnning my program 

I found following exception : 

Caused by: 

org.hibernate.exception.GenericJDBCException: This function is not supported
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert 

(StandardSQLExceptionConverter.java:54)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert 

(SqlExceptionHelper.java:125)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert 

(SqlExceptionHelper.java:110)
    at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler. 

continueInvocation(ConnectionProxyHandler.java:146)
    at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.

 invoke(AbstractProxyHandler.java:81)
    at $Proxy23.prepareStatement(Unknown Source)

Solution  : 

I found HSQL version was old with the comptibility i was using 1.8.. 

and to solve this problem i have upgraded HSQL version to 2.2.9.

And then able to run the programe succefully . 

Cheers 

Kapil