Hibernate Community • View topic - Using MySQL with LIMIT clause

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Using MySQL with LIMIT clause

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

mdsrlz

Post subject: Using MySQL with LIMIT clause

Posted: Mon Feb 13, 2006 2:05 pm

Senior

Joined: Fri Jan 13, 2006 2:50 pm
Posts: 123
Location: Blumenau / SC / Brasil

Hi.

Is it possible to use the LIMIT clause of MySQL with NHibernate?

I've tried to page some results, but the NH took a lot of time selecting all records and filtering them after this. I've used the following code:

Code:

criteria.SetFirstResult(startRowIndex);
criteria.SetMaxResults(maximumRows);

The SQL generated was:

Code:

SELECT ... FROM myTable WHERE 1=1

Is it possible to generate

Code:

SELECT ... FROM myTable WHERE 1=1 LIMIT x,y

?

Tks ;)

Top

sergey

Post subject:

Posted: Mon Feb 13, 2006 5:13 pm

Contributor

Joined: Wed May 11, 2005 4:59 pm
Posts: 1766
Location: Prague, Czech Republic

There should be a LIMIT clause in the generated SQL. If you are really sure there isn't, then please try to reproduce the behavior using a simple example and then submit a bug report to JIRA. But I think the problem is in your code.

Top

mdsrlz

Post subject:

Posted: Tue Feb 14, 2006 7:08 am

Senior

Joined: Fri Jan 13, 2006 2:50 pm
Posts: 123
Location: Blumenau / SC / Brasil

sergey wrote:

Hum, thanks Sergey. I was missing the property SelectCountMethod of the ObjectDataSource. It must be set to pass the StartRowIndexParameterName and MaximumRowsParameterName to my class.

Thanks.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » NHibernate 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