Hibernate Community • View topic - setMaxResults and setFirstResult in Hibernate1.2

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

setMaxResults and setFirstResult in Hibernate1.2

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

dash

Post subject: setMaxResults and setFirstResult in Hibernate1.2

Posted: Fri Dec 05, 2003 2:46 pm

Newbie

Joined: Tue Sep 30, 2003 11:00 am
Posts: 1

I have been implemented page nvigation mechanizm using Query:

Code:

            Query q = sess.createQuery("from p in class Product");
            q.setMaxResults(pageSize);
            q.setFirstResult(numPage * pageSize);
            return q.list();

It's working fine but recently when i have used Oracle database sometimes I 've got exception (java.sql.SQLException: Conversion to String failed). But if I used following code:

Code:

            Query q = sess.createQuery("from p in class Product");
            return q.list();

I didn't get any exceptions.

What do you think. What is the problem?

Top

david

Post subject:

Posted: Fri Dec 05, 2003 11:17 pm

Hibernate Team

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

You can enable the show_sql falg to see what SQL is being generated. Also,
the 2.1 series has had a few improvements in this area. I would try it out.

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