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.
8
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
2
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!
1