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