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?
Asked
Active
Viewed 5,950 times
1
-
Possible duplicate of [hibernate dialect for oracle 12c](http://stackoverflow.com/questions/31698651/hibernate-dialect-for-oracle-12c) – Atul Feb 18 '17 at 05: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 – Feb 18 '17 at 05:36
1 Answers
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
LONGVARBINARYto preferBLOB. - 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.
Naros
- 19,928
- 3
- 41
- 71
-
Has anyone managed to extract the 12c dialect from Hibernate 5 and merged with with Hibernate 4 ? – Houcem Berrayana Dec 19 '17 at 08:38