Uploaded image for project: 'Hibernate ORM'
  1. HHH-8497

AuditReader.find() causes SQL error ORA-00932 with oracle when using ClassicQueryTranslatorFactory

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.2.5
    • Fix Version/s: 4.3.0.CR1, 4.2.8
    • Component/s: hibernate-envers
    • Labels:
    • Environment:
      Hibernate 4.2.5.Final, Oracle 11g XE
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

    • Last commented by a user?:
      true
    • Sprint:

      Description

      Calling AuditReader.find() for a certain revision causes a ORA-00932 error with the message "ORA-00932: inconsistent datatypes: expected NUMBER got BINARY" (see surefire-report in attachment) when property hibernate.query.factory_class is set to org.hibernate.hql.internal.classic.ClassicQueryTranslatorFactory

      The behaviour does not occur, when ClassicQueryTranslatorFactory is not used. The testcase provided with this report can be executed with the new translator factory by providing -DpersistenceUnitName=ENVERSTEST-ORACLE_DEFAULT; The error does also not occur when using H2 (-DpersistenceUnitName=ENVERSTEST-H2).
      To run the provided test with oracle a user "enverstest" with password "enverstest" has to be created. It is also likely that the JDBC URL in persistence.xml has to be changed. The test can be executed under control of maven with "mvn clean install".

      I reported the same behaviour for Hibernate 3.6.10 as HHH-8482 Closed . There's also an earlier report as HHH-6975 Closed .

        Attachments

          Issue links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: