DataNucleus with Derby server

Performance Result Summary

The final position of DataNucleus with Derby server in the speed performance tests is 24 out of 33,

The following charts show DataNucleus with Derby server relatively to other tested JPA/DBMS combinations.

Position #1 on the X-Axis (the fastest) is about 100 times faster than position #33 (the slowest).

In the chart below the Y-Axis represents result score (maximum 100) in logarithmic scale - higher is better:

Move the cursor over bars - for details. Click a bar - to switch a page.

In the chart below the Y-Axis represents result score (maximum 100) in linear scale - higher is better:

Move the cursor over bars - for details. Click a bar - to switch a page.

DataNucleus with Derby server Problems (Exceptions)

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

Multithreading Test - Query 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:656)
at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2961)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.getSQLTableMappingForPrimaryExpression(QueryToSQLMapper.java:2275)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.processPrimaryExpression(QueryToSQLMapper.java:2146)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.processInvokeExpression(QueryToSQLMapper.java:2700)
at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compilePrimaryExpression(AbstractExpressionEvaluator.java:200)
at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileUnaryExpression(AbstractExpressionEvaluator.java:169)
at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileAdditiveMultiplicativeExpression(AbstractExpressionEvaluator.java:148)
at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileRelationalExpression(AbstractExpressionEvaluator.java:123)
at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileOrAndExpression(AbstractExpressionEvaluator.java:65)
at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.evaluate(AbstractExpressionEvaluator.java:46)
at org.datanucleus.query.expression.Expression.evaluate(Expression.java:335)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileFilter(QueryToSQLMapper.java:461)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:381)
at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:800)
at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:279)
at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:800)
at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:146)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:437)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:57)
at org.jpab.Test.query(Test.java:314)
at org.jpab.Runner$QueryAction.run0(Runner.java:562)
at org.jpab.Runner$TestAction.run(Runner.java:517)
at java.lang.Thread.run(Thread.java:662)

Multithreading Test - Query Operations - Many Entities (5000)

java.lang.IllegalStateException: Table object has not been been initialised : PERSON
at org.datanucleus.store.rdbms.table.AbstractTable.assertIsInitialized(AbstractTable.java:656)
at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2961)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.getSQLTableMappingForPrimaryExpression(QueryToSQLMapper.java:2275)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.processPrimaryExpression(QueryToSQLMapper.java:2146)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.processInvokeExpression(QueryToSQLMapper.java:2700)
at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compilePrimaryExpression(AbstractExpressionEvaluator.java:200)
at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileUnaryExpression(AbstractExpressionEvaluator.java:169)
at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileAdditiveMultiplicativeExpression(AbstractExpressionEvaluator.java:148)
at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileRelationalExpression(AbstractExpressionEvaluator.java:123)
at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.compileOrAndExpression(AbstractExpressionEvaluator.java:65)
at org.datanucleus.query.evaluator.AbstractExpressionEvaluator.evaluate(AbstractExpressionEvaluator.java:46)
at org.datanucleus.query.expression.Expression.evaluate(Expression.java:335)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileFilter(QueryToSQLMapper.java:461)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:381)
at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:800)
at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:279)
at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:800)
at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:146)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:437)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:57)
at org.jpab.Test.query(Test.java:314)
at org.jpab.Runner$QueryAction.run0(Runner.java:562)
at org.jpab.Runner$TestAction.run(Runner.java:517)
at java.lang.Thread.run(Thread.java:662)

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:656)
at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2961)
at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectMemberOfSourceInStatement(SQLStatementHelper.java:644)
at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(SQLStatementHelper.java:573)
at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfCandidateInStatement(SQLStatementHelper.java:531)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileResult(QueryToSQLMapper.java:759)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:400)
at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:800)
at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:279)
at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:800)
at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:146)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:437)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:57)
at org.jpab.Test.retireveEntities(Test.java:380)
at org.jpab.Test.doAction(Test.java:251)
at org.jpab.Runner$UpdateAction.run0(Runner.java:574)
at org.jpab.Runner$TestAction.run(Runner.java:517)
at java.lang.Thread.run(Thread.java:662)

Multithreading Test - Update Operations - Many Entities (5000)

java.lang.IllegalStateException: Table object has not been been initialised : PERSON
at org.datanucleus.store.rdbms.table.AbstractTable.assertIsInitialized(AbstractTable.java:656)
at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2961)
at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectMemberOfSourceInStatement(SQLStatementHelper.java:644)
at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(SQLStatementHelper.java:573)
at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfCandidateInStatement(SQLStatementHelper.java:531)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileResult(QueryToSQLMapper.java:759)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:400)
at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:800)
at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:279)
at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:800)
at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:146)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:437)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:57)
at org.jpab.Test.retireveEntities(Test.java:380)
at org.jpab.Test.doAction(Test.java:251)
at org.jpab.Runner$UpdateAction.run0(Runner.java:574)
at org.jpab.Runner$TestAction.run(Runner.java:517)
at java.lang.Thread.run(Thread.java:662)

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:656)
at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2961)
at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectMemberOfSourceInStatement(SQLStatementHelper.java:644)
at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(SQLStatementHelper.java:573)
at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfCandidateInStatement(SQLStatementHelper.java:531)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileResult(QueryToSQLMapper.java:759)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:400)
at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:800)
at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:279)
at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:800)
at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:146)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:437)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:57)
at org.jpab.Test.retireveEntities(Test.java:380)
at org.jpab.Test.doAction(Test.java:251)
at org.jpab.Runner$RemoveAction.run0(Runner.java:587)
at org.jpab.Runner$TestAction.run(Runner.java:517)
at java.lang.Thread.run(Thread.java:662)

Multithreading Test - Removal Operations - Many Entities (5000)

java.lang.IllegalStateException: Table object has not been been initialised : PERSON
at org.datanucleus.store.rdbms.table.AbstractTable.assertIsInitialized(AbstractTable.java:656)
at org.datanucleus.store.rdbms.table.ClassTable.getMemberMapping(ClassTable.java:2961)
at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectMemberOfSourceInStatement(SQLStatementHelper.java:644)
at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(SQLStatementHelper.java:573)
at org.datanucleus.store.rdbms.sql.SQLStatementHelper.selectFetchPlanOfCandidateInStatement(SQLStatementHelper.java:531)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compileResult(QueryToSQLMapper.java:759)
at org.datanucleus.store.rdbms.query.QueryToSQLMapper.compile(QueryToSQLMapper.java:400)
at org.datanucleus.store.rdbms.query.JPQLQuery.compileQueryFull(JPQLQuery.java:800)
at org.datanucleus.store.rdbms.query.JPQLQuery.compileInternal(JPQLQuery.java:279)
at org.datanucleus.store.query.Query.setImplicitParameter(Query.java:800)
at org.datanucleus.store.rdbms.query.JPQLQuery.setImplicitParameter(JPQLQuery.java:146)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:437)
at org.datanucleus.api.jpa.JPAQuery.setParameter(JPAQuery.java:57)
at org.jpab.Test.retireveEntities(Test.java:380)
at org.jpab.Test.doAction(Test.java:251)
at org.jpab.Runner$RemoveAction.run0(Runner.java:587)
at org.jpab.Runner$TestAction.run(Runner.java:517)
at java.lang.Thread.run(Thread.java:662)

DataNucleus with Derby server compared to the alternatives

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