I tried to use the hibernate pagination from Gavin's weblog using the setFirstResults and setMaxResults API of Query. It works fine with Hibernate 2.1 but with Hibernate 3.0, it gives an exception:
ERROR [main ] 2005-08-24 18:06:07,794 : JDBCExceptionReporter.logExceptions : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, ?' at line 1
Looks like it puts ? for limit for first result and max result, but does not replace the ? with the actual values in 3.0
Please help.
Hibernate version:
3.0
Mapping documents:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="Test" table="test">
<id name="id"
type="int"
unsaved-value="0">
<generator class="increment"/>
</id>
<property name="name"/>
<property name="age"/>
<property name="company"/>
</class>
<query name="sample.test.age.equal">
from Test t
where t.age = ?
</query>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
try{
Session session=HibernateSession.currentSession();
Query q=session.createQuery("from Test");
q.setFirstResult(1);
q.setMaxResults(10);
List result=q.list();
Iterator i=result.iterator();
while(i.hasNext())
{
Test t=(Test)i.next();
System.out.println(t.getName());
}
HibernateSession.closeSession();
}catch(HibernateException he)
{
System.out.println("Exception ---- "+he.getMessage());
}
Full stack trace of any exception that occurs:
INFO [main ] 2005-08-24 18:06:07,075 : SessionFactoryImpl.<init> : building session factory
WARN [main ] 2005-08-24 18:06:07,090 : Configurator.configure : No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/amruta/Jar%20files/lib/ehcache.jar!/ehcache-failsafe.xml
INFO [main ] 2005-08-24 18:06:07,481 : SessionFactoryObjectFactory.addInstance : Not binding factory to JNDI, no JNDI name configured
INFO [main ] 2005-08-24 18:06:07,481 : SessionFactoryImpl.checkNamedQueries : Checking 1 named queries
INFO [main ] 2005-08-24 18:06:07,684 : HibernateSession.<clinit> : session factory build
INFO [main ] 2005-08-24 18:06:07,715 : HibernateSession.currentSession : session opened------ in currentSession()
WARN [main ] 2005-08-24 18:06:07,778 : JDBCExceptionReporter.logExceptions : SQL Error: 1064, SQLState: 42000
ERROR [main ] 2005-08-24 18:06:07,778 : JDBCExceptionReporter.logExceptions : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, ?' at line 1
WARN [main ] 2005-08-24 18:06:07,794 : JDBCExceptionReporter.logExceptions : SQL Error: 1064, SQLState: 42000
ERROR [main ] 2005-08-24 18:06:07,794 : JDBCExceptionReporter.logExceptions : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, ?' at line 1
Name and version of the database you are using:
Database :- SQLyog v4.01
The generated SQL (show_sql=true):
Hibernate: select test0_.id as id, test0_.name as name0_, test0_.age as age0_, test0_.company as company0_ from test test0_ limit ?, ?
Login
FAQ
Search
