Hibernate Community • View topic - Using rownum with between clause in hibernate

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Using rownum with between clause in hibernate

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

tanmoy

Post subject: Using rownum with between clause in hibernate

Posted: Wed Jan 19, 2005 8:17 am

Newbie

Joined: Tue Dec 28, 2004 6:25 am
Posts: 16

Hi,

I want to use rownum (Oracle) with between clause in Hibernate. I am using createQuery() method.

Can anyone please guide me how to form the query for hibernate.

Top

christian

Post subject:

Posted: Wed Jan 19, 2005 10:53 am

Hibernate Team

Joined: Mon Aug 25, 2003 9:11 pm
Posts: 4592
Location: Switzerland

Not possible, since its an internal implementation detail of Oracle (what you do is really bad, btw). Use createSQLQuery().

Top

Page 1 of 1

[ 2 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