Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes EJB and other Java EE Technologies and the fly likes EJB3 and DBMS portability Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "EJB3 and DBMS portability" Watch "EJB3 and DBMS portability" New topic

EJB3 and DBMS portability

Carlos Gavidia

Joined: May 06, 2008
Posts: 7
Does EJB3 have mechanism that solve's DMBS portability issues? (so my app's code work with Oracle and SQL Server with no DBMS specific SQL statements, for example). I heard Hibernate does that, and i also heard both technologies(EJB3 and Hibernate) are similar.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32818

If you don't use DB specific SQL, it is portable. This is true regardless of technology (pure JDBC, EJB, Hibernate, etc.) It is also possible to write non-portable code using any technology. For example native queries in JPA.

Note that EJB 3 is JPA for the entity beans part. And Hibernate is an implementation of JPA.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
subject: EJB3 and DBMS portability
It's not a secret anymore!