CODEWITHSUNDEEP
hibernateoracle10goracle12c
user3778137
user3778137

Reputation:

Using Hibernate Oracle10g dialect for Oracle12c

Hibernate version 4.3.0 does not support Oracle 12c dialect. Oracle 10g dialect works for 12c but is there a downside of doing this?. Does using mismatched dialect and database version impact performance?, The quality of the SQL's fired?

Upvotes: 1

Views: 6307

Answers (1)

Naros
Naros

Reputation: 21113

You are free to take the source of Oracle12cDialect and add it to your application's source with any modifications to make it compliant with Hibernate 4.3. All you need to do is to manually add the hibernate.dialect property and specify the name of your custom Oracle 12 dialect class.

The Oracle12cDialect in Hibernate 5.2 provides the following differences from 10g:

  • Accounts for Oracle's deprecated support for LONGVARBINARY to prefer BLOB.
  • It uses a SQL2008 compliant limit handler implementation where-as the 10g doesn't.
  • Recommends native identifier generation as sequence
  • Specifies its own identity support algorithm.

Upvotes: 2

Related Questions