This content has been marked as final.
Show 2 replies
-
1. Re: Oracle 932 Error with AuditQuery.forRevisionsOfEntity
adamw Jul 30, 2009 1:03 PM (in response to soudmaijer)No idea, sorry. I don't have an Oracle DB to test ;)
Adam -
2. Re: Oracle 932 Error with AuditQuery.forRevisionsOfEntity
suchong Aug 6, 2009 11:55 AM (in response to soudmaijer)Hey Adam,
I've got exactly the same problem:
Oracle 10 g
Hibernate 3.3.2
Enverse 1.2.1
Here is the query it wants to execute, with the following parameters {_p2=1, _p1=DEL, _p0=1}:
select e
from nl.test.TestCase_AUD e
where e.REVTYPE <> :_p1
and e.originalId.REV.id = (
select max(e2.originalId.REV.id)
from nl.test.TestCase_AUD e2
where e2.originalId.REV.id <= :_p0
and e.originalId.id = e2.originalId.id)
and e.originalId.id = :_p2
I think _p1 should be the value of the enum type org.hibernate.envers.RevisionType instead of DEL. this might be the cause of the following error:
Caused by: java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
Any idea??....