Hibernate with HSQLDB embedded

Performance Result Summary

The final position of Hibernate with HSQLDB embedded in the speed performance tests is 3 out of 32,

The following charts show Hibernate with HSQLDB embedded relatively to other tested JPA/DBMS combinations.

Position #1 on the X-Axis (the fastest) is about 100 times faster than position #32 (the slowest).
In the chart below the Y-Axis represents result score (maximum 100) in logarithmic scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB
In the chart below the Y-Axis represents result score (maximum 100) in linear scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB

Hibernate with HSQLDB embedded Problems (Exceptions)

Hibernate with HSQLDB embedded has failed in the following tests (throwing the following stack traces):

  • Graph (Binary Tree) Test - Retrieval Operations - Few Entities (5/100)
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1235)
    	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1168)
    	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:250)
    	at org.jpab.node.NodeTest.retireveEntities(NodeTest.java:130)
    	at org.jpab.Test.doAction(Test.java:250)
    	at org.jpab.Runner$RetrieveAction.run0(Runner.java:540)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    	at org.hibernate.loader.Loader.doList(Loader.java:2452)
    	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
    	at org.hibernate.loader.Loader.list(Loader.java:2187)
    	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
    	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
    	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
    	... 5 more
    Caused by: java.sql.SQLException: data type cast needed for parameter or null literal
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source)
    	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
    	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
    	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
    	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1616)
    	at org.hibernate.loader.Loader.doQuery(Loader.java:717)
    	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
    	at org.hibernate.loader.Loader.doList(Loader.java:2449)
    	... 13 more
    Caused by: org.hsqldb.HsqlException: data type cast needed for parameter or null literal
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.FunctionSQL.resolveTypes(Unknown Source)
    	at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    	at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveExpressionTypes(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveTypes(Unknown Source)
    	at org.hsqldb.QueryExpression.resolve(Unknown Source)
    	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
    	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
    	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
    	at org.hsqldb.Session.compileStatement(Unknown Source)
    	at org.hsqldb.StatementManager.compile(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 22 more
    
  • Graph (Binary Tree) Test - Retrieval Operations - Many Entities (5000)
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1235)
    	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1168)
    	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:250)
    	at org.jpab.node.NodeTest.retireveEntities(NodeTest.java:130)
    	at org.jpab.Test.doAction(Test.java:250)
    	at org.jpab.Runner$RetrieveAction.run0(Runner.java:540)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    	at org.hibernate.loader.Loader.doList(Loader.java:2452)
    	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
    	at org.hibernate.loader.Loader.list(Loader.java:2187)
    	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
    	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
    	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
    	... 5 more
    Caused by: java.sql.SQLException: data type cast needed for parameter or null literal
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source)
    	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
    	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
    	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
    	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1616)
    	at org.hibernate.loader.Loader.doQuery(Loader.java:717)
    	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
    	at org.hibernate.loader.Loader.doList(Loader.java:2449)
    	... 13 more
    Caused by: org.hsqldb.HsqlException: data type cast needed for parameter or null literal
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.FunctionSQL.resolveTypes(Unknown Source)
    	at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    	at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveExpressionTypes(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveTypes(Unknown Source)
    	at org.hsqldb.QueryExpression.resolve(Unknown Source)
    	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
    	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
    	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
    	at org.hsqldb.Session.compileStatement(Unknown Source)
    	at org.hsqldb.StatementManager.compile(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 22 more
    
  • Graph (Binary Tree) Test - Update Operations - Few Entities (5/100)
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1235)
    	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1168)
    	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:250)
    	at org.jpab.node.NodeTest.retireveEntities(NodeTest.java:130)
    	at org.jpab.Test.doAction(Test.java:250)
    	at org.jpab.Runner$UpdateAction.run0(Runner.java:564)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    	at org.hibernate.loader.Loader.doList(Loader.java:2452)
    	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
    	at org.hibernate.loader.Loader.list(Loader.java:2187)
    	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
    	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
    	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
    	... 5 more
    Caused by: java.sql.SQLException: data type cast needed for parameter or null literal
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source)
    	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
    	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
    	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
    	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1616)
    	at org.hibernate.loader.Loader.doQuery(Loader.java:717)
    	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
    	at org.hibernate.loader.Loader.doList(Loader.java:2449)
    	... 13 more
    Caused by: org.hsqldb.HsqlException: data type cast needed for parameter or null literal
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.FunctionSQL.resolveTypes(Unknown Source)
    	at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    	at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveExpressionTypes(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveTypes(Unknown Source)
    	at org.hsqldb.QueryExpression.resolve(Unknown Source)
    	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
    	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
    	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
    	at org.hsqldb.Session.compileStatement(Unknown Source)
    	at org.hsqldb.StatementManager.compile(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 22 more
    
  • Graph (Binary Tree) Test - Update Operations - Many Entities (5000)
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1235)
    	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1168)
    	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:250)
    	at org.jpab.node.NodeTest.retireveEntities(NodeTest.java:130)
    	at org.jpab.Test.doAction(Test.java:250)
    	at org.jpab.Runner$UpdateAction.run0(Runner.java:564)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    	at org.hibernate.loader.Loader.doList(Loader.java:2452)
    	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
    	at org.hibernate.loader.Loader.list(Loader.java:2187)
    	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
    	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
    	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
    	... 5 more
    Caused by: java.sql.SQLException: data type cast needed for parameter or null literal
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source)
    	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
    	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
    	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
    	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1616)
    	at org.hibernate.loader.Loader.doQuery(Loader.java:717)
    	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
    	at org.hibernate.loader.Loader.doList(Loader.java:2449)
    	... 13 more
    Caused by: org.hsqldb.HsqlException: data type cast needed for parameter or null literal
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.FunctionSQL.resolveTypes(Unknown Source)
    	at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    	at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveExpressionTypes(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveTypes(Unknown Source)
    	at org.hsqldb.QueryExpression.resolve(Unknown Source)
    	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
    	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
    	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
    	at org.hsqldb.Session.compileStatement(Unknown Source)
    	at org.hsqldb.StatementManager.compile(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 22 more
    
  • Graph (Binary Tree) Test - Removal Operations - Few Entities (5/100)
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1235)
    	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1168)
    	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:250)
    	at org.jpab.node.NodeTest.retireveEntities(NodeTest.java:130)
    	at org.jpab.Test.doAction(Test.java:250)
    	at org.jpab.Runner$RemoveAction.run0(Runner.java:577)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    	at org.hibernate.loader.Loader.doList(Loader.java:2452)
    	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
    	at org.hibernate.loader.Loader.list(Loader.java:2187)
    	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
    	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
    	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
    	... 5 more
    Caused by: java.sql.SQLException: data type cast needed for parameter or null literal
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source)
    	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
    	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
    	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
    	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1616)
    	at org.hibernate.loader.Loader.doQuery(Loader.java:717)
    	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
    	at org.hibernate.loader.Loader.doList(Loader.java:2449)
    	... 13 more
    Caused by: org.hsqldb.HsqlException: data type cast needed for parameter or null literal
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.FunctionSQL.resolveTypes(Unknown Source)
    	at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    	at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveExpressionTypes(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveTypes(Unknown Source)
    	at org.hsqldb.QueryExpression.resolve(Unknown Source)
    	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
    	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
    	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
    	at org.hsqldb.Session.compileStatement(Unknown Source)
    	at org.hsqldb.StatementManager.compile(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 22 more
    
  • Graph (Binary Tree) Test - Removal Operations - Many Entities (5000)
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1235)
    	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1168)
    	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:250)
    	at org.jpab.node.NodeTest.retireveEntities(NodeTest.java:130)
    	at org.jpab.Test.doAction(Test.java:250)
    	at org.jpab.Runner$RemoveAction.run0(Runner.java:577)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    	at org.hibernate.loader.Loader.doList(Loader.java:2452)
    	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
    	at org.hibernate.loader.Loader.list(Loader.java:2187)
    	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
    	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
    	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
    	... 5 more
    Caused by: java.sql.SQLException: data type cast needed for parameter or null literal
    	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    	at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source)
    	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
    	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
    	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
    	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1616)
    	at org.hibernate.loader.Loader.doQuery(Loader.java:717)
    	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
    	at org.hibernate.loader.Loader.doList(Loader.java:2449)
    	... 13 more
    Caused by: org.hsqldb.HsqlException: data type cast needed for parameter or null literal
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.error.Error.error(Unknown Source)
    	at org.hsqldb.FunctionSQL.resolveTypes(Unknown Source)
    	at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    	at org.hsqldb.ExpressionLogical.resolveTypes(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveExpressionTypes(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source)
    	at org.hsqldb.QuerySpecification.resolveTypes(Unknown Source)
    	at org.hsqldb.QueryExpression.resolve(Unknown Source)
    	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
    	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
    	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
    	at org.hsqldb.Session.compileStatement(Unknown Source)
    	at org.hsqldb.StatementManager.compile(Unknown Source)
    	at org.hsqldb.Session.execute(Unknown Source)
    	... 22 more
    

Hibernate with HSQLDB embedded compared to the alternatives

See head to head comparisons of Hibernate with HSQLDB embedded vs the following compatitors: