Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Subquery in Hibernate 2.0  RSS feed

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


modifiedTS timestamp
id number
pkgId number
serialNumber varchar2

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

It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!