• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Will the Java portablity of JPA work to Microsoft?

 
Namitha karupaiya
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If I create a database application using JPA with MySQL database, is it possible to port it to Microsoft SQL Server?

(If this is possible, I wonder how it is possible? Is Microsoft providing a JPA implementation for SQL Server?)
 
Vijitha Kumara
Bartender
Pie
Posts: 3930
21
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Namitha karupaiya wrote:If I create a database application using JPA with MySQL database, is it possible to port it to Microsoft SQL Server?

Yes, Of course that's the hole point of JPA (portability across different DBs and/or different persistence providers).
... Is Microsoft providing a JPA implementation for SQL Server?)

No. It's the vendor (your JPA provider) takes care of that.
 
Namitha karupaiya
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There is one implementation (according to my knowledge) for JPA which is Eclipselink, is that it for all databases? How this works?
 
Ulf Dittmer
Rancher
Posts: 42969
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hibernate and OpenJPA are other implementations of JPA besides EclipseLink. Somewhere in the JPA setup (generally in the persistence.xml file) you need to up some properties that tell the implementation which DB you're using.
 
Tim McGuire
Ranch Hand
Posts: 820
IntelliJ IDE Tomcat Server VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Namitha karupaiya wrote:There is one implementation (according to my knowledge) for JPA which is Eclipselink, is that it for all databases? How this works?

EclipseLink is the reference implementation for JPA (the same way that Tomcat is the reference implementation for Servlet Container). Just like there are other Servlet Containers that properly implement the Servlet Container specs, there are other products (like Hibernate) that implement JPA.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic