We're updating the issue view to help you get more done. 

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

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).

Environment

Hibernate 3.6.10, Oracle 11g XE

Status

Assignee

Unassigned

Reporter

S

Components

Affects versions

3.6.10

Priority

Major