Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Within the world of developers/firms specializing in building/deploying solutions built around software built/sold by Oracle (aka "Oracle houses"), what ORM middleware is considered as the "industry standard" (if any), based on your experience?

We have limited experience on Oracle's stack, so would appreciate insights from folks who have more experience in it. This might impact our product roadmap.

share|improve this question

closed as not a real question by gnat, Martijn Pieters, thorsten müller, Walter, JeffO Mar 29 '13 at 23:13

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

what is "Oracle houses"? – gnat Mar 29 '13 at 7:14
1) Can someone explain the close votes? This is a real question as relates to our (sw) business's strategy. We would be very interested in learning from people's insights before we jump the gun. 2) @gnat: A firm that specializes in making solution built around Oracle based software – DeepSpace101 Mar 29 '13 at 16:48
What is "Oracle based software"? – gnat Mar 29 '13 at 16:49
@gnat: So pedantic it is. While you're at it, others managed to offer more productive answers that actually helped us with our concern. – DeepSpace101 Mar 29 '13 at 17:47
@Sid - I can see how this question is important to you, but unless there's only one choice for an Oracle ORM, I don't see how you can expect anyone to tell you what is the best one. Check the FAQ's. – JeffO Mar 29 '13 at 23:13

Using .NET you're able to use EF with the Oracle Data Provider. You can also use nhibernate for a RDBMS agnostic framework.

If you're in the Java world you have a few big ORM choices: Hibernate, TopLink and I've also come across Apache OpenJPA being used. In my experience with Java, Hibernate tends to be used more often and I've not commercially seen TopLink used before.

For an Oracle house, the typical stack would be:

  • Java / JEE
  • An application server, I typically see Jetty or Tomcat
  • Hibernate
  • Spring
  • Eclipse for development
  • Maven for building
share|improve this answer
A true Oracle house would be using WebLogic for the app server, and TopLink/JPA for the ORM layer. If they're really drinking the kool-aid, they'll also be using JDeveloper as their IDE. – TMN Mar 29 '13 at 19:29
Thats a good point. I guess the places I've worked who are all Oracle aren't as Oracle as I thought. – Sam Mar 30 '13 at 4:34

Depends on the client language used. If you use C# to access an Oracle DB, you might use EF (and suffer the performance problems it has with Oracle, not sure if they were introduced deliberately :) ).

If you use Java you might want to use Hibernate. If you're an all-Oracle shop this is probably what you'll end up using.

There are others, and any of them are available for use with an Oracle DB, nHibernate for example!

share|improve this answer
An all Oracle shop would probably prefer TopLink to Hibernate (which would be a very good reason to not be an all Oracle shop). – Yannis Mar 28 '13 at 23:43

Not the answer you're looking for? Browse other questions tagged or ask your own question.