Search code examples
hibernatedb2liferaydialect

Which hibernate.dialect for DB2?

I use Liferay 6.2 and DB2 10.5.

I would like to set the hibernate.dialect property.

Here I can find the dialect depending on DB2 distribution

DB2         org.hibernate.dialect.DB2Dialect
DB2 AS/400  org.hibernate.dialect.DB2400Dialect
DB2 OS390   org.hibernate.dialect.DB2390Dialect

But I can not find anywhere the mapping between DB2 version and those names: AS/400 or OS390 or just DB2.

Which dialect should I choose ?

Thanks

Solution

  • After digging more into AS/400 and OS/390, I must obviously use org.hibernate.dialect.DB2Dialectbecause AS/400 was introduced in 1988 and OS/390 in 1995.