API tools faq
paste
Advertisement
alexeev

eclipselink vs batoo vs datanucleus vs hibernate

alexeev
Feb 17th, 2013
621
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.19 KB | None | 0 0
raw download clone embed print report
  1. ###
  2. full review: http://alexeev-net.blogspot.de/2013/02/jpa-provider-competition.html
  3. ###
  4. codebase: http://jpab.org
  5. ###
  6. DB: in-memory-HSQLDB 2.2.9
  7. ###
  8. JPA Vendors:
  9. - eclipselink 2.4.1
  10. - batoo 2.0.1.0-RTM
  11. - datanucleus 3.1.4
  12. - hibernate 4.1.9.Final
  13. #####
  14. TAB separated results:
  15.  
  16. test batch_size operation batoo* datanucleus eclipselink hibernate
  17.  
  18.  
  19.  
  20. BasicTest small_batch Persist 38424,04334 8612,208595 22088,69665 6701,578987
  21. BasicTest small_batch Retrieve 65181,89467 13792,25847 43390,35914 12307,44994
  22. BasicTest small_batch Update 18156,72569 5853,080145 15302,93108 4360,445223
  23. BasicTest small_batch Remove 47685,95652 2666,627995 28584,17705 7823,382297
  24.  
  25.  
  26.  
  27.  
  28. BasicTest large_batch Persist 16857,15588 11898,55422 30971,59528 10573,28745
  29. BasicTest large_batch Retrieve 118516,9236 36736,15625 114930,1109 25294,55692
  30. BasicTest large_batch Update 18162,91905 8452,56858 23200,89873 7577,253094
  31. BasicTest large_batch Remove 48090,14131 2666,618928 55978,09967 20511,68975
  32.  
  33.  
  34.  
  35.  
  36. CollectionTest small_batch Persist 20661,05383 4800,668991 17533,2703 4561,891264
  37. CollectionTest small_batch Retrieve 32058,26543 10715,89577 23452,12925 3072,374473
  38. CollectionTest small_batch Update 13521,39763 4341,303363 11233,79401 1984,571909
  39. CollectionTest small_batch Remove 20515,78011 2666,620468 12263,74893 2320,283135
  40.  
  41.  
  42.  
  43.  
  44. CollectionTest large_batch Persist 8549,046716 5374,586764 19426,75043 7595,138136
  45. CollectionTest large_batch Retrieve 51426,43482 27476,02468 43800,65236 3489,176861
  46. CollectionTest large_batch Update 18390,81098 7282,96313 16907,27326 2548,719597
  47. CollectionTest large_batch Remove 19480,88933 2666,620707 14864,65434 3148,55668
  48.  
  49.  
  50.  
  51.  
  52. ExtTest small_batch Persist 38963,4515 8696,998634 21825,27901 6943,177086
  53. ExtTest small_batch Retrieve 54337,21622 12343,60363 39600,19004 12500,41001
  54. ExtTest small_batch Update 17163,85332 5163,280212 14683,25638 4352,40299
  55. ExtTest small_batch Remove 41324,70422 2666,625258 27102,86224 7725,140523
  56.  
  57.  
  58.  
  59.  
  60. ExtTest large_batch Persist 11604,00153 28579,80969 11212,54359
  61. ExtTest large_batch Retrieve 33560,514 102282,7715 25615,5658
  62. ExtTest large_batch Update 8031,73094 23083,31829 7761,717926
  63. ExtTest large_batch Remove 2666,61465 49599,65401 20577,40514
  64.  
  65.  
  66.  
  67.  
  68. IndexTest small_batch Persist 20943,12194 8765,374627 23357,78401 5520,168701
  69. IndexTest small_batch Retrieve 62616,63889 14090,95751 46179,90519 12336,01011
  70. IndexTest small_batch Update 11220,51909 5690,766298 15729,14908 3558,249869
  71. IndexTest small_batch Remove 34741,09479 2666,618004 29560,85257 6597,954928
  72.  
  73.  
  74.  
  75.  
  76. IndexTest large_batch Persist 12538,24148 11823,80417 33727,26855 8238,678925
  77. IndexTest large_batch Retrieve 115697,1221 36206,71484 115774,1636 25091,13358
  78. IndexTest large_batch Update 11910,85287 8304,500104 22410,63285 5514,235782
  79. IndexTest large_batch Remove 41850,98037 2666,619715 49935,93903 14794,22592
  80.  
  81.  
  82.  
  83.  
  84. NodeTest small_batch Persist 40935,90451 17982,17967 29895,40312 21294,65595
  85. NodeTest small_batch Retrieve 73761,65803 91009,91861 332008,2064 4264,165221
  86. NodeTest small_batch Update 22597,77112 13161,98912 29509,37332 3629,556477
  87. NodeTest small_batch Remove 31730,50923 13401,80137 36321,17549 3902,05723
  88.  
  89.  
  90.  
  91.  
  92. NodeTest large_batch Persist 5390,565869 17078,55078 27767,72833 22719,25384
  93. NodeTest large_batch Retrieve 78480,66763 105485,87 323594,9146 4347,007238
  94. NodeTest large_batch Update 6010,665099 13019,17246 32261,81731 3799,653
  95. NodeTest large_batch Remove 2811,592279 13645,68409 42365,15061 4122,582191
  96.  
  97.  
  98.  
  99.  
  100. BasicTest_5_Threads small_batch Persist 28950,55821 13082,57713 23111,71195 11210,39034
  101. BasicTest_5_Threads small_batch Retrieve 79876,99758 29669,02982 69864,65111 20889,78891
  102. BasicTest_5_Threads small_batch Update 16949,09929 8167,550178 18886,303 7515,159287
  103. BasicTest_5_Threads small_batch Remove 22676,16561 49163,63361 11640,76869
  104.  
  105.  
  106.  
  107.  
  108. BasicTest_5_Threads large_batch Persist 14234,01976 12949,64757 26184,11749 9995,601385
  109. BasicTest_5_Threads large_batch Retrieve 140870,7863 58663,88477 154533,2147 40709,31241
  110. BasicTest_5_Threads large_batch Update 18599,38751 9726,266856 23072,0574 8760,271641
  111. BasicTest_5_Threads large_batch Remove 23382,63166 58050,89958 33689,25901
  112.  
  113. ###
  114. *Notes: Batoo is unstable on some tests. Example Stacktrace:
  115.  
  116. 2013-02-17 03:50 BatooJPA HSQLDB-embedded ExtTest 1 5 100000 Persist javax.persistence.PersistenceException: Flush failed||| at org.batoo.jpa.core.impl.manager.EntityManagerImpl.flush(EntityManagerImpl.java:542)||| at org.batoo.jpa.core.impl.manager.EntityTransactionImpl.commit(EntityTransactionImpl.java:106)||| at org.jpab.Test.persist(Test.java:217)||| at org.jpab.Test.persist(Test.java:200)||| at org.jpab.Runner$PersistAction.run0(Runner.java:537)||| at org.jpab.Runner$TestAction.run(Runner.java:516)||| at java.lang.Thread.run(Unknown Source)|||Caused by: java.sql.SQLException: user lacks privilege or object not found: PERSONBASE Query: INSERT INTO PersonBase|||(middleName, lastName, zip, phone, lastLoginDate, street, state, loginCount, country, city, joinDate, id, email, birthDate, DTYPE, firstName)|||VALUES||| (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [NYU, KXEMWBA, 10601, 160959051731430, 1969-08-22, UZPZLBVRRMPSIWCW, HE, 93, KMGSYUAZEVGKRZC, EVACDIYYSTDEX, 1951-10-23, 1, RXPK@HFWTPOUO.VFK, 1944-06-17, PersonExtExt, DEFNSMETUTX]||| at org.batoo.jpa.jdbc.dbutils.QueryRunner.convertSqlException(QueryRunner.java:161)||| at org.batoo.jpa.jdbc.dbutils.QueryRunner.update(QueryRunner.java:395)||| at org.batoo.jpa.jdbc.dbutils.QueryRunner.update(QueryRunner.java:435)||| at org.batoo.jpa.jdbc.EntityTable.performInsert(EntityTable.java:270)||| at org.batoo.jpa.core.impl.model.EntityTypeImpl.performInsert(EntityTypeImpl.java:1787)||| at org.batoo.jpa.core.impl.manager.SessionImpl.doUpdates(SessionImpl.java:252)||| at org.batoo.jpa.core.impl.manager.SessionImpl.flush(SessionImpl.java:416)||| at org.batoo.jpa.core.impl.manager.EntityManagerImpl.flush(EntityManagerImpl.java:537)||| ... 6 more|||
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!