Register / Login
Win a copy of
The Little Book of Impediments (e-book only)
this week in the
Agile and Other Processes
Object Relational Mapping
Subquery in Hibernate 2.0
posted 8 years ago
I am using following subquery in Hibernate:It comes up with the error: missing right paranthesis
select serialNo.id from Area area where area.pkgId=3 and area.modifiedTS in(select max(a.modifiedTS) from Area a where a.pkgId=3 group by a.serialNumber)
Underlying database is Oracel 9.0. The above query executes in oracle but i couldnt figure out why it is not working in hiberate.
Any help is appreciated.
Missing IN or OUT parameter at index:: 1
A Tricky Stored Procedure
scope of alias in subquery
How can I write a subquery for the given queries?
how to use variable with oracle like