wood burning stoves 2.0*
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
Author

EJB3 and DBMS portability

Carlos Gavidia
Greenhorn

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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30085
    
149

Carlos,
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.


[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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: EJB3 and DBMS portability
 
Similar Threads
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException:
Persistence : Portability
Hibernate Search in Action and native SQL dialects
General join fetch
difference between hibernate and ejb