org.hibernate.dialect.PostgreSQLDialect is deprecated

Question

I've just added configuration for Hibernate to my application and IntelliJ Idea is complaining that this dialect is deprecated:

<property name="hibernate.dialect">
   org.hibernate.dialect.PostgreSQLDialect
</property> 

Does not seem to be a clear solution on the internet, any suggestions?

Answer 1

You need to use org.hibernate.dialect.PostgreSQL82Dialect instead.

This is documented in PostgreSQLDialect Javadoc:

Deprecated.
use PostgreSQL82Dialect instead

Note however that you should use the dialect that best matches the PostgreSQL JDBC driver you are using (list here). For example, if you are using PostgreSQL 9.4 or later, use PostgreSQL94Dialect instead.