Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Oracle inline view

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

Peetzore

Post subject: Oracle inline view

Posted: Wed Apr 04, 2007 10:06 am

Newbie

Joined: Mon Feb 20, 2006 6:31 am
Posts: 17

I am trying to convert an existing query into appropriate HQL or Criteria. I was wondering if it is possible to use a query like this in Hibernate:

Code:

Select min(SYSTEM_DATE)
From (Select SYSTEM_DATE 
    From AL.TB_ALGO_SYSTEM_CALENDAR 
    Where to_date(SYSTEM_DATE) < to_date('20070201', 'yyyyMMdd') 
    and IS_ACTIVE <> 0 
    Order By to_date(SYSTEM_DATE) Asc) 
Where rownum <= 20

The inner query is no problem, but how can I use it nested in the outer query?

Top

david

Post subject:

Posted: Thu Apr 05, 2007 9:31 pm

Hibernate Team

Joined: Tue Aug 26, 2003 7:19 pm
Posts: 2364
Location: Brisbane, Australia

Virtual tables are not supported. Use native query features for this.

Top

Peetzore

Post subject:

Posted: Tue Apr 10, 2007 3:39 am

Newbie

Joined: Mon Feb 20, 2006 6:31 am
Posts: 17

I already had a suspicion!

Thanks anyway!
Peter

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum