So, I want to share my experience and compare EclipseLink and Hibernate. Comparison EclipseLink and Hibernate as ORM framweworks for Oracle
Well, I don't like ORM in general, but it often required by management or so on... and in this case, if you have vendor lock in, and this vendor is Oracle, you have to think about EclipseLink as a perfect alternative to Hibernate.
Let's start
EclipseLinks is beter because... It's choosend by Sun Microsystems as standard JPA 2 implementation. It's a better support, bugs are fixed much more quickly; let's look at statistic (as for July 26, 2011):
Name | Number of bugs | Number of blockers | The oldest blocker |
---|---|---|---|
Hibernate | 156 | 49 | 29/Sep/2006 |
EclipseLink | 15 | 3 | 04/Jun/2010 |
It's Oracle-oriented additions which are incredible useful if you create Oracle oriented s/w and want to have all power of oracle in your orm.
The most important Oracle features in EclipseLink are:
1) Built-in Oracle hints support
Hints are important for sql optimization in Oracle and with EclipseLink you can add them through API. Also, EclipseLink will be automatically insert Hints if needs and their usage is clear for orm
2) Hierarchical Queries Support
PL/SQL has a useful featurs as Hierarchical Queries which can help you a lot if you work with hierarchical structures intensive. So, you don't need to write native sql anymore, just use API
3) Oracle Flashback Transaction Query
Historical queries during transaction available just from ORM
4) Stored Procedures/Functions Support
Well, Hibernate/JPA also have it. However, in EclipseLink you can use another way (JPA way is still available) with StoredFunctionCall class and related API. In others words, you can build stored procedure/function dynamical invocation. I guess, it is the easiest way to call SP from your java code
Next cool feature is Report Queries that means you can build queries with "reporting" possibilities (AVG, SUM, ROLL UP) with API instead of writing native SQL.
Summarize topic, I can recommend EclipseLink as a perfect ORM for Oracle lock-in project, because a lot of features will be available in this case. However you must keep in mind Hibernate has a lot of own features (versioning, shards, search, etc) and you must to think about your project requirements and pick up the most convenience tool.
Kocaeli
ВідповістиВидалитиDenizli
Bursa
istanbul
Van
D1PUR0
F5BB0
ВідповістиВидалитиAnkara Evden Eve Nakliyat
Osmaniye Parça Eşya Taşıma
Yenimahalle Fayans Ustası
Niğde Şehir İçi Nakliyat
Sakarya Parça Eşya Taşıma
Adıyaman Parça Eşya Taşıma
Bitcoin Nasıl Alınır
Kırşehir Lojistik
Hatay Parça Eşya Taşıma
A436E
ВідповістиВидалитиpharmacy steroids
oxandrolone anavar
parabolan
order sustanon
Sakarya Evden Eve Nakliyat
trenbolone enanthate
Yozgat Evden Eve Nakliyat
İzmir Evden Eve Nakliyat
masteron for sale
90AC2
ВідповістиВидалитиmaraş ücretsiz görüntülü sohbet uygulamaları
manisa ücretsiz sohbet odaları
ücretsiz sohbet
afyon bedava sohbet odaları
muğla mobil sohbet siteleri
karaman bedava sohbet odaları
Batman Sesli Mobil Sohbet
yalova canlı görüntülü sohbet siteleri
ığdır Görüntülü Sohbet Yabancı
C19D9
ВідповістиВидалитиKripto Para Kazanma Siteleri
MEME Coin Hangi Borsada
Threads İzlenme Hilesi
Periscope Beğeni Satın Al
Twitter Retweet Satın Al
Tiktok Beğeni Satın Al
Sohbet
Fuckelon Coin Hangi Borsada
Coin Madenciliği Siteleri
FC16A
ВідповістиВидалитиAtkaracalar
Şiran
Üzümlü
Damal
Toprakkale
Ağlı
Yahyalı
Kayapınar
Serik
RTYHGTHYT
ВідповістиВидалитиشركة كشف تسربات المياه بالقطيف
شركة تنظيف بخميس مشيط IgBEJSDaDz
ВідповістиВидалитиشركة تنظيف سجاد بخميس مشيط Mz1pvFNGxR
ВідповістиВидалитиافضل شركة تسليك مجاري بالاحساء CRxG6tp9L7
ВідповістиВидалитиشركة صيانة افران BtiikzaXCZ
ВідповістиВидалитиمكافحة حشرات 8SQDXFlGLZ
ВідповістиВидалитиشركة عزل اسطح بالجبيل DhEBslJbT1
ВідповістиВидалити