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

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 3.6.10
    • Fix Version/s: None
    • Component/s: hibernate-envers
    • Labels:
      None
    • Environment:
      Hibernate 3.6.10, 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.classic.ClassicQueryTranslatorFactory.
      This behaviour was described in the closed issue HH-6975
      .
      I wrote a test case with which the bug can be reproduced (see attachment) by executing just "mvn clean install" (prerequisite: create a user enverstest with passwort enverstest in a Oracle 11g instance name "xe" running on localhost and listening on port 1521). If executing the test with "-DpersistenceUnitName=ENVERSTEST-ORACLE_DEFAULT" the error does not occur, so we assume, that it is related to the ClassicQueryTranslatorFactory. The bug also does not occur with H2DB as database (run the test with -DpersistenceUnitName=ENVERSTEST-H2" for this).

        Attachments

          Issue links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: