Choose benchmark test, operation and batch mode:

When one or more of the All filters is selected - only average normalized results are displayed. Please read Running and Results for more details.

Speed comparison of JPA database update operations per second (higher is better)

 Derby
embedded		H2
embedded		HSQLDB
embedded		SQLite
embedded		DB4O
embedded		ObjectDB
embedded		Derby
server		H2
server		MySQL
server		PostgreSQL
server		ObjectDB
server
DataNucleus2,1984,7215,183 5.6 5901,1932541,072 
EclipseLink3,2527,8828,156failed  2,3042,2182123,197 
Hibernate2,2905,4106,75639.6  1,4691,6323062,714 
OpenJPA22.823.34.9   21.716.924.12,435 
ObjectDB     50,250    9,986

Performance comparison chart - The Y-Axis represents normalized score in logarithmic scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB

Performance comparison chart - The Y-Axis represents normalized score in linear scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB

Best and Worst JPA/Database Performer in this comparison

The Most Efficient (the Fastest):

1. ObjectDB embedded100
2. ObjectDB server19.9
3. EclipseLink with HSQLDB embedded16.2
4. EclipseLink with H2 embedded15.7
5. Hibernate with HSQLDB embedded13.4
6. Hibernate with H2 embedded10.8
7. DataNucleus with HSQLDB embedded10.3
8. DataNucleus with H2 embedded9.4
9. EclipseLink with Derby embedded6.5
10. EclipseLink with PostgreSQL server6.4
11. Hibernate with PostgreSQL server5.4
12. OpenJPA with PostgreSQL server4.8
13. EclipseLink with Derby server4.6
14. Hibernate with Derby embedded4.6
15. EclipseLink with H2 server4.4
16. DataNucleus with Derby embedded4.4
17. Hibernate with H2 server3.2

The Least Efficient (the Slowest):

18. Hibernate with Derby server2.9
19. DataNucleus with H2 server2.4
20. DataNucleus with PostgreSQL server2.1
21. DataNucleus with Derby server1.2
22. Hibernate with MySQL server0.61
23. DataNucleus with MySQL server0.51
24. EclipseLink with MySQL server0.42
25. Hibernate with SQLite embedded0.079
26. OpenJPA with MySQL server0.048
27. OpenJPA with H2 embedded0.046
28. OpenJPA with Derby embedded0.045
29. OpenJPA with Derby server0.043
30. OpenJPA with H2 server0.034
31. DataNucleus with DB4O embedded0.011
32. OpenJPA with HSQLDB embedded0.0098
33. EclipseLink with SQLite embedded0.0000

Problems (Exceptions) in these tests

  • EclipseLink with SQLite embedded
    Local Exception Stack: 
Exception [EclipseLink-3002] (Eclipse Persistence Services - 2.1.1.v20100817-r8050): org.eclipse.persistence.exceptions.ConversionException
Exception Description: The object [1,807,200,000], of class [class java.lang.Integer], from mapping [org.eclipse.persistence.mappings.DirectToFieldMapping[birthDate-->PERSONBASE.BIRTHDATE]] with descriptor [RelationalDescriptor(org.jpab.ext.PersonExtExt --> [DatabaseTable(PERSONBASE)])], could not be converted to [class java.util.Date].
	at org.eclipse.persistence.exceptions.ConversionException.couldNotBeConverted(ConversionException.java:71)
	at org.eclipse.persistence.internal.helper.ConversionManager.convertObjectToUtilDate(ConversionManager.java:761)
	at org.eclipse.persistence.internal.helper.ConversionManager.convertObject(ConversionManager.java:101)
	at org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform.convertObject(DatasourcePlatform.java:157)
	at org.eclipse.persistence.mappings.converters.TypeConversionConverter.convertDataValueToObjectValue(TypeConversionConverter.java:119)
	at org.eclipse.persistence.mappings.foundation.AbstractDirectMapping.getAttributeValue(AbstractDirectMapping.java:675)
	at org.eclipse.persistence.mappings.foundation.AbstractDirectMapping.valueFromRow(AbstractDirectMapping.java:1263)
	at org.eclipse.persistence.mappings.foundation.AbstractDirectMapping.buildCloneFromRow(AbstractDirectMapping.java:1234)
	at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildAttributesIntoWorkingCopyClone(ObjectBuilder.java:1338)
	at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildWorkingCopyCloneFromRow(ObjectBuilder.java:1466)
	at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectInUnitOfWork(ObjectBuilder.java:558)
	at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObject(ObjectBuilder.java:502)
	at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObject(ObjectBuilder.java:454)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.buildObject(ObjectLevelReadQuery.java:721)
	at org.eclipse.persistence.queries.ReadAllQuery.registerResultInUnitOfWork(ReadAllQuery.java:723)
	at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:420)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1074)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:736)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1034)
	at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:380)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1112)
	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:1247)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:479)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:714)
	at org.jpab.Test.retireveEntities(Test.java:382)
	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)