DataNucleus with H2 server

Performance Result Summary

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

The following charts show DataNucleus 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

DataNucleus with H2 server Problems (Exceptions)

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

  • Multithreading Test - Persistence Operations - Many Entities (5000)
    Fetch of object "org.jpab.basic.Person@18005a9" using statement "SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ?" failed : Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-141]
    org.datanucleus.exceptions.NucleusDataStoreException: Fetch of object "org.jpab.basic.Person@18005a9" using statement "SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ?" failed : Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-141]
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:384)
    	at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.fetchObject(RDBMSPersistenceHandler.java:319)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadFieldsFromDatastore(JDOStateManagerImpl.java:1928)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadUnloadedFieldsInFetchPlan(JDOStateManagerImpl.java:1672)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.detach(JDOStateManagerImpl.java:3655)
    	at org.datanucleus.ObjectManagerImpl.detachAll(ObjectManagerImpl.java:2032)
    	at org.datanucleus.jpa.EntityManagerImpl.clear(EntityManagerImpl.java:136)
    	at org.jpab.Test.persist(Test.java:225)
    	at org.jpab.Test.persist(Test.java:198)
    	at org.jpab.Runner$PersistAction.run0(Runner.java:528)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-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.table.RegularTable.doLock(RegularTable.java:478)
    	at org.h2.table.RegularTable.lock(RegularTable.java:416)
    	at org.h2.table.TableFilter.lock(TableFilter.java:139)
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:554)
    	at org.h2.command.dml.Query.query(Query.java:241)
    	at org.h2.command.CommandContainer.query(CommandContainer.java:80)
    	at org.h2.command.Command.executeQuery(Command.java:132)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:279)
    	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.executeQuery(CommandRemote.java:152)
    	at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    	at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:463)
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:318)
    	... 11 more
    Nested Throwables StackTrace:
    org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-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.table.RegularTable.doLock(RegularTable.java:478)
    	at org.h2.table.RegularTable.lock(RegularTable.java:416)
    	at org.h2.table.TableFilter.lock(TableFilter.java:139)
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:554)
    	at org.h2.command.dml.Query.query(Query.java:241)
    	at org.h2.command.CommandContainer.query(CommandContainer.java:80)
    	at org.h2.command.Command.executeQuery(Command.java:132)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:279)
    	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.executeQuery(CommandRemote.java:152)
    	at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    	at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:463)
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:318)
    	at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.fetchObject(RDBMSPersistenceHandler.java:319)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadFieldsFromDatastore(JDOStateManagerImpl.java:1928)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadUnloadedFieldsInFetchPlan(JDOStateManagerImpl.java:1672)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.detach(JDOStateManagerImpl.java:3655)
    	at org.datanucleus.ObjectManagerImpl.detachAll(ObjectManagerImpl.java:2032)
    	at org.datanucleus.jpa.EntityManagerImpl.clear(EntityManagerImpl.java:136)
    	at org.jpab.Test.persist(Test.java:225)
    	at org.jpab.Test.persist(Test.java:198)
    	at org.jpab.Runner$PersistAction.run0(Runner.java:528)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    
  • Multithreading Test - Retrieval Operations - Many Entities (5000)
    Fetch of object "org.jpab.basic.Person@18005a9" using statement "SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ?" failed : Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-141]
    org.datanucleus.exceptions.NucleusDataStoreException: Fetch of object "org.jpab.basic.Person@18005a9" using statement "SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ?" failed : Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-141]
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:384)
    	at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.fetchObject(RDBMSPersistenceHandler.java:319)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadFieldsFromDatastore(JDOStateManagerImpl.java:1928)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadUnloadedFieldsInFetchPlan(JDOStateManagerImpl.java:1672)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.detach(JDOStateManagerImpl.java:3655)
    	at org.datanucleus.ObjectManagerImpl.detachAll(ObjectManagerImpl.java:2032)
    	at org.datanucleus.jpa.EntityManagerImpl.clear(EntityManagerImpl.java:136)
    	at org.jpab.Test.persist(Test.java:225)
    	at org.jpab.Test.persist(Test.java:198)
    	at org.jpab.Runner$PersistAction.run0(Runner.java:528)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-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.table.RegularTable.doLock(RegularTable.java:478)
    	at org.h2.table.RegularTable.lock(RegularTable.java:416)
    	at org.h2.table.TableFilter.lock(TableFilter.java:139)
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:554)
    	at org.h2.command.dml.Query.query(Query.java:241)
    	at org.h2.command.CommandContainer.query(CommandContainer.java:80)
    	at org.h2.command.Command.executeQuery(Command.java:132)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:279)
    	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.executeQuery(CommandRemote.java:152)
    	at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    	at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:463)
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:318)
    	... 11 more
    Nested Throwables StackTrace:
    org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-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.table.RegularTable.doLock(RegularTable.java:478)
    	at org.h2.table.RegularTable.lock(RegularTable.java:416)
    	at org.h2.table.TableFilter.lock(TableFilter.java:139)
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:554)
    	at org.h2.command.dml.Query.query(Query.java:241)
    	at org.h2.command.CommandContainer.query(CommandContainer.java:80)
    	at org.h2.command.Command.executeQuery(Command.java:132)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:279)
    	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.executeQuery(CommandRemote.java:152)
    	at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    	at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:463)
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:318)
    	at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.fetchObject(RDBMSPersistenceHandler.java:319)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadFieldsFromDatastore(JDOStateManagerImpl.java:1928)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadUnloadedFieldsInFetchPlan(JDOStateManagerImpl.java:1672)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.detach(JDOStateManagerImpl.java:3655)
    	at org.datanucleus.ObjectManagerImpl.detachAll(ObjectManagerImpl.java:2032)
    	at org.datanucleus.jpa.EntityManagerImpl.clear(EntityManagerImpl.java:136)
    	at org.jpab.Test.persist(Test.java:225)
    	at org.jpab.Test.persist(Test.java:198)
    	at org.jpab.Runner$PersistAction.run0(Runner.java:528)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    
  • Multithreading Test - Query Operations - Many Entities (5000)
    Fetch of object "org.jpab.basic.Person@18005a9" using statement "SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ?" failed : Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-141]
    org.datanucleus.exceptions.NucleusDataStoreException: Fetch of object "org.jpab.basic.Person@18005a9" using statement "SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ?" failed : Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-141]
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:384)
    	at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.fetchObject(RDBMSPersistenceHandler.java:319)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadFieldsFromDatastore(JDOStateManagerImpl.java:1928)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadUnloadedFieldsInFetchPlan(JDOStateManagerImpl.java:1672)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.detach(JDOStateManagerImpl.java:3655)
    	at org.datanucleus.ObjectManagerImpl.detachAll(ObjectManagerImpl.java:2032)
    	at org.datanucleus.jpa.EntityManagerImpl.clear(EntityManagerImpl.java:136)
    	at org.jpab.Test.persist(Test.java:225)
    	at org.jpab.Test.persist(Test.java:198)
    	at org.jpab.Runner$PersistAction.run0(Runner.java:528)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-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.table.RegularTable.doLock(RegularTable.java:478)
    	at org.h2.table.RegularTable.lock(RegularTable.java:416)
    	at org.h2.table.TableFilter.lock(TableFilter.java:139)
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:554)
    	at org.h2.command.dml.Query.query(Query.java:241)
    	at org.h2.command.CommandContainer.query(CommandContainer.java:80)
    	at org.h2.command.Command.executeQuery(Command.java:132)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:279)
    	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.executeQuery(CommandRemote.java:152)
    	at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    	at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:463)
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:318)
    	... 11 more
    Nested Throwables StackTrace:
    org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-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.table.RegularTable.doLock(RegularTable.java:478)
    	at org.h2.table.RegularTable.lock(RegularTable.java:416)
    	at org.h2.table.TableFilter.lock(TableFilter.java:139)
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:554)
    	at org.h2.command.dml.Query.query(Query.java:241)
    	at org.h2.command.CommandContainer.query(CommandContainer.java:80)
    	at org.h2.command.Command.executeQuery(Command.java:132)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:279)
    	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.executeQuery(CommandRemote.java:152)
    	at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    	at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:463)
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:318)
    	at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.fetchObject(RDBMSPersistenceHandler.java:319)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadFieldsFromDatastore(JDOStateManagerImpl.java:1928)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadUnloadedFieldsInFetchPlan(JDOStateManagerImpl.java:1672)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.detach(JDOStateManagerImpl.java:3655)
    	at org.datanucleus.ObjectManagerImpl.detachAll(ObjectManagerImpl.java:2032)
    	at org.datanucleus.jpa.EntityManagerImpl.clear(EntityManagerImpl.java:136)
    	at org.jpab.Test.persist(Test.java:225)
    	at org.jpab.Test.persist(Test.java:198)
    	at org.jpab.Runner$PersistAction.run0(Runner.java:528)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    
  • Multithreading Test - Update Operations - Few Entities (5/100)
    java.lang.IllegalStateException: Table object has not been been initialised : PERSON
    	at org.datanucleus.store.rdbms.table.AbstractTable.assertIsInitialized(AbstractTable.java:625)
    	at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2935)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectMemberOfSourceInStatement(SQLStatementHelper.java:617)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(SQLStatementHelper.java:546)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfCandidateInStatement(SQLStatementHelper.java:504)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileResult(QueryToSQLMapper.java:679)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:362)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:754)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:381)
    	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)
    
  • Multithreading Test - Update Operations - Many Entities (5000)
    Fetch of object "org.jpab.basic.Person@18005a9" using statement "SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ?" failed : Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-141]
    org.datanucleus.exceptions.NucleusDataStoreException: Fetch of object "org.jpab.basic.Person@18005a9" using statement "SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ?" failed : Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-141]
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:384)
    	at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.fetchObject(RDBMSPersistenceHandler.java:319)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadFieldsFromDatastore(JDOStateManagerImpl.java:1928)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadUnloadedFieldsInFetchPlan(JDOStateManagerImpl.java:1672)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.detach(JDOStateManagerImpl.java:3655)
    	at org.datanucleus.ObjectManagerImpl.detachAll(ObjectManagerImpl.java:2032)
    	at org.datanucleus.jpa.EntityManagerImpl.clear(EntityManagerImpl.java:136)
    	at org.jpab.Test.persist(Test.java:225)
    	at org.jpab.Test.persist(Test.java:198)
    	at org.jpab.Runner$PersistAction.run0(Runner.java:528)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-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.table.RegularTable.doLock(RegularTable.java:478)
    	at org.h2.table.RegularTable.lock(RegularTable.java:416)
    	at org.h2.table.TableFilter.lock(TableFilter.java:139)
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:554)
    	at org.h2.command.dml.Query.query(Query.java:241)
    	at org.h2.command.CommandContainer.query(CommandContainer.java:80)
    	at org.h2.command.Command.executeQuery(Command.java:132)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:279)
    	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.executeQuery(CommandRemote.java:152)
    	at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    	at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:463)
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:318)
    	... 11 more
    Nested Throwables StackTrace:
    org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-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.table.RegularTable.doLock(RegularTable.java:478)
    	at org.h2.table.RegularTable.lock(RegularTable.java:416)
    	at org.h2.table.TableFilter.lock(TableFilter.java:139)
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:554)
    	at org.h2.command.dml.Query.query(Query.java:241)
    	at org.h2.command.CommandContainer.query(CommandContainer.java:80)
    	at org.h2.command.Command.executeQuery(Command.java:132)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:279)
    	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.executeQuery(CommandRemote.java:152)
    	at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    	at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:463)
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:318)
    	at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.fetchObject(RDBMSPersistenceHandler.java:319)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadFieldsFromDatastore(JDOStateManagerImpl.java:1928)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadUnloadedFieldsInFetchPlan(JDOStateManagerImpl.java:1672)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.detach(JDOStateManagerImpl.java:3655)
    	at org.datanucleus.ObjectManagerImpl.detachAll(ObjectManagerImpl.java:2032)
    	at org.datanucleus.jpa.EntityManagerImpl.clear(EntityManagerImpl.java:136)
    	at org.jpab.Test.persist(Test.java:225)
    	at org.jpab.Test.persist(Test.java:198)
    	at org.jpab.Runner$PersistAction.run0(Runner.java:528)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    
  • Multithreading Test - Removal Operations - Few Entities (5/100)
    java.lang.IllegalStateException: Table object has not been been initialised : PERSON
    	at org.datanucleus.store.rdbms.table.AbstractTable.assertIsInitialized(AbstractTable.java:625)
    	at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2935)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectMemberOfSourceInStatement(SQLStatementHelper.java:617)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(SQLStatementHelper.java:546)
    	at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfCandidateInStatement(SQLStatementHelper.java:504)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileResult(QueryToSQLMapper.java:679)
    	at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:362)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:754)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:249)
    	at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:736)
    	at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:136)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:390)
    	at org.datanucleus.jpa.JPAQuery.setParameter(JPAQuery.java:53)
    	at org.jpab.Test.retireveEntities(Test.java:381)
    	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)
    
  • Multithreading Test - Removal Operations - Many Entities (5000)
    Fetch of object "org.jpab.basic.Person@18005a9" using statement "SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ?" failed : Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-141]
    org.datanucleus.exceptions.NucleusDataStoreException: Fetch of object "org.jpab.basic.Person@18005a9" using statement "SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ?" failed : Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-141]
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:384)
    	at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.fetchObject(RDBMSPersistenceHandler.java:319)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadFieldsFromDatastore(JDOStateManagerImpl.java:1928)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadUnloadedFieldsInFetchPlan(JDOStateManagerImpl.java:1672)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.detach(JDOStateManagerImpl.java:3655)
    	at org.datanucleus.ObjectManagerImpl.detachAll(ObjectManagerImpl.java:2032)
    	at org.datanucleus.jpa.EntityManagerImpl.clear(EntityManagerImpl.java:136)
    	at org.jpab.Test.persist(Test.java:225)
    	at org.jpab.Test.persist(Test.java:198)
    	at org.jpab.Runner$PersistAction.run0(Runner.java:528)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-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.table.RegularTable.doLock(RegularTable.java:478)
    	at org.h2.table.RegularTable.lock(RegularTable.java:416)
    	at org.h2.table.TableFilter.lock(TableFilter.java:139)
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:554)
    	at org.h2.command.dml.Query.query(Query.java:241)
    	at org.h2.command.CommandContainer.query(CommandContainer.java:80)
    	at org.h2.command.Command.executeQuery(Command.java:132)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:279)
    	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.executeQuery(CommandRemote.java:152)
    	at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    	at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:463)
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:318)
    	... 11 more
    Nested Throwables StackTrace:
    org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "PERSON"; SQL statement:
    SELECT A0.BIRTHDATE,A0.CITY,A0.COUNTRY,A0.EMAIL,A0.FIRSTNAME,A0.JOINDATE,A0.LASTLOGINDATE,A0.LASTNAME,A0.LOGINCOUNT,A0.MIDDLENAME,A0.PHONE,A0."STATE",A0.STREET,A0.ZIP FROM PERSON A0 WHERE A0.ID = ? [50200-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.table.RegularTable.doLock(RegularTable.java:478)
    	at org.h2.table.RegularTable.lock(RegularTable.java:416)
    	at org.h2.table.TableFilter.lock(TableFilter.java:139)
    	at org.h2.command.dml.Select.queryWithoutCache(Select.java:554)
    	at org.h2.command.dml.Query.query(Query.java:241)
    	at org.h2.command.CommandContainer.query(CommandContainer.java:80)
    	at org.h2.command.Command.executeQuery(Command.java:132)
    	at org.h2.server.TcpServerThread.process(TcpServerThread.java:279)
    	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.executeQuery(CommandRemote.java:152)
    	at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    	at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:463)
    	at org.datanucleus.store.rdbms.request.FetchRequest.execute(FetchRequest.java:318)
    	at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.fetchObject(RDBMSPersistenceHandler.java:319)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadFieldsFromDatastore(JDOStateManagerImpl.java:1928)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.loadUnloadedFieldsInFetchPlan(JDOStateManagerImpl.java:1672)
    	at org.datanucleus.jdo.state.JDOStateManagerImpl.detach(JDOStateManagerImpl.java:3655)
    	at org.datanucleus.ObjectManagerImpl.detachAll(ObjectManagerImpl.java:2032)
    	at org.datanucleus.jpa.EntityManagerImpl.clear(EntityManagerImpl.java:136)
    	at org.jpab.Test.persist(Test.java:225)
    	at org.jpab.Test.persist(Test.java:198)
    	at org.jpab.Runner$PersistAction.run0(Runner.java:528)
    	at org.jpab.Runner$TestAction.run(Runner.java:507)
    	at java.lang.Thread.run(Thread.java:619)
    

DataNucleus with H2 server compared to the alternatives

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