O'Reilly logo

Spring Persistence with Hibernate by Ahmad Seddighi

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hibernate dialect

Although JDBC and SQL allow all Java applications to connect to all databases, we can't use special database features relying only on standard JDBC and SQL. In other words, although most interactions with all databases are treated similarly through the standard ANSI SQL, many database properties are essentially used differently, and we need to use a slightly different version of SQL to interact with them.

For example, databases may differ in the following ways:

  • Different databases may define identity columns differently
  • Different databases may support different column types
  • Different databases may use SQL syntaxes
  • Different databases may define foreign key columns differently
  • Not all databases support cascading delete

To solve this ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required