Solved : ERROR: HHH000231: Schema export unsuccessful java.sql.SQLTransientConnectionException: java.net.ConnectException: Connection refused: connect

I was getting following error after setting up the Spring hibernate application

ERROR: HHH000231: Schema export unsuccessful java.sql.SQLTransientConnectionException: java.net.ConnectException: Connection refused: connect

configuration was picking up correct for HSQL but connection refused caused because my HSQL DB was not running in server mode.

I have started HSQL DB by running following batch"runServer.bat" and it got fix the problem.

F:\Database\hsqldb-2.2.9\hsqldb-2.2.9\hsqldb\bin\runServer.bat

Cheers
Kapil

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