File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 32089

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]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
It is sorta covered in the JavaRanch Style Guide.
subject: EJB3 and DBMS portability