Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Subquery in Hibernate 2.0

 
sudha swami
Ranch Hand
Posts: 186
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am using following subquery in Hibernate:It comes up with the error: missing right paranthesis

Table:
-----

Area
----
modifiedTS timestamp
id number
pkgId number
serialNumber varchar2

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.

regards
sudha
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic