Hello,

How does Hibernate implement the method Query.setFirstResult()?

Please don't get mad, I know this is off-topic. I did ask the same question on a relevant forum but didn't get any answer yet.

I am using MySQL and connecting to it via the ConnecterJ JDBC driver.

Thanks alot.
--
Santosh.

It changes how the ResultSet is accessed. If you set it the ResultSet will be scrollable and only rows from the given value accessed.

PS. I found this out by fetching the source code, you should probably try that ;-)

Hi,

set the following properties in your hibernate.cfg.xml to true

"hibernate.show_sql"
"hibernate.format_sql"
"hibernate.use_sql_comments"

and
try an example with
Query.setFirstResult()
and
Query.setMaxResults()

and you will see the generated sql.