CODEWITHSUNDEEP
jpa-2.0java-ee-6ibm-midrange
mjn
mjn

Reputation: 36664

Java EE 6 JPA 2.0 provider for DB2/400?

For Java EE development in an IBM iSeries (aka AS/400) environment, I would like to use JPA 2.0. Is there a JPA 2.0 provider with support for DB2/400 databases?

Update: target deployment environment will be JBoss AS 6 and 7.

Upvotes: 2

Views: 1251

Answers (1)

Mikko Maunu
Mikko Maunu

Reputation: 42114

Yes, it is possible. With your target environment (JBoss AS 6 and 7) you already have JPA 2.0 capable Hibernate runtime, so I assume that Hibernate is the persistence provider you want to use.

  • If you do not have JDBC driver yet, find one matching to DB2 version: drivers
  • If you use Hibernate, then dialect is org.hibernate.dialect.DB2Dialect. If you plan to use some other persistence provider, probably you can find information about dialect from the documentation.

Opposite to to what you present in your comment, at least Hibernate does not choose right dialect based to driver. There is no one-to-one mapping between driver and dialect. For example with MySQL dialect depends about table type (innoDb/MyISAM) and version of MySQL, and all of them can be used with same version of Connector/J.

Upvotes: 2

Related Questions