1

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?

Improve this question
2
  • Possible duplicate of hibernate dialect for oracle 12c Commented Feb 18, 2017 at 5:27
  • 2
    @Leozeo The question you have suggested does not talk about the implications of using different versions of dialect and database. It only says that oracle 10g dialect works for Oracle 12c database which I have already mentioned using in the question Commented Feb 18, 2017 at 5:36

1 Answer 1

Reset to default
2

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.
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Has anyone managed to extract the 12c dialect from Hibernate 5 and merged with with Hibernate 4 ?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.