[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6975) SQL error "expected NUMBER got BINARY" when calling AuditReader.find()

[Verrier (JIRA)]

SQL error "expected NUMBER got BINARY" when calling AuditReader.find()
----------------------------------------------------------------------

                 Key: HHH-6975
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6975
             Project: Hibernate ORM
          Issue Type: Bug
          Components: envers
    Affects Versions: 3.6.5
         Environment: Hibernate version: 3.6.5.Final
Database platform: Oracle
Application server: Weblogic 11g
            Reporter: Verrier
            Priority: Blocker


When calling AuditReader.find(), I've a SQLError "expected NUMBER got BINARY". It seams it comes from Java class EntitiesAtRevisionQuery.java (line 91). It tries to compare the content of the column "REVTYPE" in the audit table (which is of NUMBER type) to the content of the constant "RevisionType.DEL" (which is of BYTE type). I think it could be fix by replacing "RevisionType.DEL" with "RevisionType.DEL.getRepresentation()"

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira