Will the Java portablity of JPA work to Microsoft?

[Namitha karupaiya]

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]

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]

There is one implementation (according to my knowledge) for JPA which is Eclipselink, is that it for all databases? How this works?

[Ulf Dittmer]

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]

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.