EclipseLink with H2 server

Performance Result Summary

The final position of EclipseLink with H2 server in the speed performance tests is 23 out of 32,

The following charts show EclipseLink with H2 server 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

EclipseLink with H2 server Problems (Exceptions)

EclipseLink with H2 server has failed in the following tests (throwing the following stack traces):

  • Graph (Binary Tree) Test - Removal Operations - Few Entities (5/100)
    javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.1.v20100817-r8050): org.eclipse.persistence.exceptions.DatabaseException
    Internal Exception: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_NODE_CHILD2_ID: PUBLIC.NODE FOREIGN KEY(CHILD2_ID) REFERENCES PUBLIC.NODE(ID)"; SQL statement:
    DELETE FROM NODE WHERE (ID = ?) [23003-141]
    	at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    	at org.h2.message.DbException.get(DbException.java:167)
    	at org.h2.message.DbException.get(DbException.java:144)
    	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:381)
    	at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:398)
    	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:275)
    	at org.h2.table.Table.fireConstraints(Table.java:803)
    	at org.h2.table.Table.fireAfterRow(Table.java:820)
    	at org.h2.command.dml.Delete.update(Delete.java:79)
    	at org.h2.command.CommandContainer.update(CommandContainer.java:70)
    	at org.h2.command.Command.executeUpdate(Command.java:199)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:301)
    	at org.h2.server.TcpServerThread.run(TcpServerThread.java:138)
    	at java.lang.Thread.run(Unknown Source)
    
    Error Code: 23003
    Call: DELETE FROM NODE WHERE (ID = ?)
    	bind => [10129]
    Query: DeleteObjectQuery(10129)
    	at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102)
    	at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
    	at org.jpab.Test.doAction(Test.java:271)
    	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: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.1.v20100817-r8050): org.eclipse.persistence.exceptions.DatabaseException
    Internal Exception: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_NODE_CHILD2_ID: PUBLIC.NODE FOREIGN KEY(CHILD2_ID) REFERENCES PUBLIC.NODE(ID)"; SQL statement:
    DELETE FROM NODE WHERE (ID = ?) [23003-141]
    	at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    	at org.h2.message.DbException.get(DbException.java:167)
    	at org.h2.message.DbException.get(DbException.java:144)
    	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:381)
    	at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:398)
    	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:275)
    	at org.h2.table.Table.fireConstraints(Table.java:803)
    	at org.h2.table.Table.fireAfterRow(Table.java:820)
    	at org.h2.command.dml.Delete.update(Delete.java:79)
    	at org.h2.command.CommandContainer.update(CommandContainer.java:70)
    	at org.h2.command.Command.executeUpdate(Command.java:199)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:301)
    	at org.h2.server.TcpServerThread.run(TcpServerThread.java:138)
    	at java.lang.Thread.run(Unknown Source)
    
    Error Code: 23003
    Call: DELETE FROM NODE WHERE (ID = ?)
    	bind => [10129]
    Query: DeleteObjectQuery(10129)
    	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
    	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:797)
    	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:863)
    	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583)
    	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
    	at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:980)
    	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
    	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
    	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.deleteObject(DatasourceCallQueryMechanism.java:183)
    	at org.eclipse.persistence.internal.queries.StatementQueryMechanism.deleteObject(StatementQueryMechanism.java:101)
    	at org.eclipse.persistence.queries.DeleteObjectQuery.executeDatabaseQuery(DeleteObjectQuery.java:168)
    	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:736)
    	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:643)
    	at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)
    	at org.eclipse.persistence.queries.DeleteObjectQuery.executeInUnitOfWorkObjectLevelModifyQuery(DeleteObjectQuery.java:113)
    	at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)
    	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2909)
    	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1291)
    	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1273)
    	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1233)
    	at org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:329)
    	at org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:288)
    	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1425)
    	at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:546)
    	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1527)
    	at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:200)
    	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1148)
    	at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:84)
    	... 5 more
    Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_NODE_CHILD2_ID: PUBLIC.NODE FOREIGN KEY(CHILD2_ID) REFERENCES PUBLIC.NODE(ID)"; SQL statement:
    DELETE FROM NODE WHERE (ID = ?) [23003-141]
    	at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    	at org.h2.message.DbException.get(DbException.java:167)
    	at org.h2.message.DbException.get(DbException.java:144)
    	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:381)
    	at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:398)
    	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:275)
    	at org.h2.table.Table.fireConstraints(Table.java:803)
    	at org.h2.table.Table.fireAfterRow(Table.java:820)
    	at org.h2.command.dml.Delete.update(Delete.java:79)
    	at org.h2.command.CommandContainer.update(CommandContainer.java:70)
    	at org.h2.command.Command.executeUpdate(Command.java:199)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:301)
    	at org.h2.server.TcpServerThread.run(TcpServerThread.java:138)
    	at java.lang.Thread.run(Unknown Source)
    
    	at org.h2.engine.SessionRemote.done(SessionRemote.java:489)
    	at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:184)
    	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141)
    	at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127)
    	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:788)
    	... 31 more
    
  • Graph (Binary Tree) Test - Removal Operations - Many Entities (5000)
    javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.1.v20100817-r8050): org.eclipse.persistence.exceptions.DatabaseException
    Internal Exception: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_NODE_CHILD1_ID: PUBLIC.NODE FOREIGN KEY(CHILD1_ID) REFERENCES PUBLIC.NODE(ID)"; SQL statement:
    DELETE FROM NODE WHERE (ID = ?) [23003-141]
    	at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    	at org.h2.message.DbException.get(DbException.java:167)
    	at org.h2.message.DbException.get(DbException.java:144)
    	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:381)
    	at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:398)
    	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:275)
    	at org.h2.table.Table.fireConstraints(Table.java:803)
    	at org.h2.table.Table.fireAfterRow(Table.java:820)
    	at org.h2.command.dml.Delete.update(Delete.java:79)
    	at org.h2.command.CommandContainer.update(CommandContainer.java:70)
    	at org.h2.command.Command.executeUpdate(Command.java:199)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:301)
    	at org.h2.server.TcpServerThread.run(TcpServerThread.java:138)
    	at java.lang.Thread.run(Unknown Source)
    
    Error Code: 23003
    Call: DELETE FROM NODE WHERE (ID = ?)
    	bind => [10592]
    Query: DeleteObjectQuery(10592)
    	at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102)
    	at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
    	at org.jpab.Test.doAction(Test.java:271)
    	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: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.1.v20100817-r8050): org.eclipse.persistence.exceptions.DatabaseException
    Internal Exception: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_NODE_CHILD1_ID: PUBLIC.NODE FOREIGN KEY(CHILD1_ID) REFERENCES PUBLIC.NODE(ID)"; SQL statement:
    DELETE FROM NODE WHERE (ID = ?) [23003-141]
    	at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    	at org.h2.message.DbException.get(DbException.java:167)
    	at org.h2.message.DbException.get(DbException.java:144)
    	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:381)
    	at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:398)
    	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:275)
    	at org.h2.table.Table.fireConstraints(Table.java:803)
    	at org.h2.table.Table.fireAfterRow(Table.java:820)
    	at org.h2.command.dml.Delete.update(Delete.java:79)
    	at org.h2.command.CommandContainer.update(CommandContainer.java:70)
    	at org.h2.command.Command.executeUpdate(Command.java:199)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:301)
    	at org.h2.server.TcpServerThread.run(TcpServerThread.java:138)
    	at java.lang.Thread.run(Unknown Source)
    
    Error Code: 23003
    Call: DELETE FROM NODE WHERE (ID = ?)
    	bind => [10592]
    Query: DeleteObjectQuery(10592)
    	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
    	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:797)
    	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:863)
    	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583)
    	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
    	at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:980)
    	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
    	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
    	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.deleteObject(DatasourceCallQueryMechanism.java:183)
    	at org.eclipse.persistence.internal.queries.StatementQueryMechanism.deleteObject(StatementQueryMechanism.java:101)
    	at org.eclipse.persistence.queries.DeleteObjectQuery.executeDatabaseQuery(DeleteObjectQuery.java:168)
    	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:736)
    	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:643)
    	at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)
    	at org.eclipse.persistence.queries.DeleteObjectQuery.executeInUnitOfWorkObjectLevelModifyQuery(DeleteObjectQuery.java:113)
    	at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)
    	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2909)
    	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1291)
    	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1273)
    	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1233)
    	at org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:329)
    	at org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:288)
    	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1425)
    	at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:546)
    	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1527)
    	at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:200)
    	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1148)
    	at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:84)
    	... 5 more
    Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_NODE_CHILD1_ID: PUBLIC.NODE FOREIGN KEY(CHILD1_ID) REFERENCES PUBLIC.NODE(ID)"; SQL statement:
    DELETE FROM NODE WHERE (ID = ?) [23003-141]
    	at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    	at org.h2.message.DbException.get(DbException.java:167)
    	at org.h2.message.DbException.get(DbException.java:144)
    	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:381)
    	at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:398)
    	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:275)
    	at org.h2.table.Table.fireConstraints(Table.java:803)
    	at org.h2.table.Table.fireAfterRow(Table.java:820)
    	at org.h2.command.dml.Delete.update(Delete.java:79)
    	at org.h2.command.CommandContainer.update(CommandContainer.java:70)
    	at org.h2.command.Command.executeUpdate(Command.java:199)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:301)
    	at org.h2.server.TcpServerThread.run(TcpServerThread.java:138)
    	at java.lang.Thread.run(Unknown Source)
    
    	at org.h2.engine.SessionRemote.done(SessionRemote.java:489)
    	at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:184)
    	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141)
    	at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127)
    	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:788)
    	... 31 more
    

The following runs have been stopped due to being too slow

  • Element Collection Test - Retrieval Operations - Many Entities (5000)
  • Element Collection Test - Query Operations - Many Entities (5000)
  • Element Collection Test - Update Operations - Many Entities (5000)
  • Element Collection Test - Removal Operations - Many Entities (5000)

EclipseLink with H2 server compared to the alternatives

See head to head comparisons of EclipseLink with H2 server vs the following compatitors: