Hello,
we use an Oracle 11g Database. Up to now we have used ojdbc6.jar as the
jdbc driver. The customer wishes to update to ojdbc7.jar.
With Hibernate 4.3, ojdbc6.jar and
<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />
the application works as expected. However when we switch to ojdbc7.jar
does not work any more. No exception is thrown. Simply an empty List is returned.
When I trace the Hibernate SQL with bound parameters and execute the SQL directly it returns the expected result.
I have tried to update to Hibernate 5.3 and
<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle12cDialect" />
to no avail. The error still persists.
Any ideas how to fix this?