Don't give up yet. Paste your full stack trace to get a solution.
java.sql.SQLException: This function is not supported
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.notSupported(Unknown Source)
You have a different solution? A short tip here would help you and many other users who saw this issue last week.