[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6017) setFirstResult causes Parameters is not matched exception
setFirstResult causes Parameters is not matched exception
---------------------------------------------------------
Key: HHH-6017
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6017
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.6.2
Environment: Hibernate environment version :
spring-orm-3.0.4.RELEASE.jar
hibernate-distribution-3.6.2.Final.jar
commons-collections-3.2.1.jar
antlr-2.7.6.jar
dom4j-1.6.1.jar
slf4j-api-1.6.1.jar
Database platform :
Oracle 10g
Reporter: seungu lee
Priority: Critical
setFirstResult function causes "Parameters is not matched Bind var('?') count
2 And parameters counts are 1 [21]" Exception
See below execute log
[2011-03-15 18:46:50] [ERROR]『core.log.exception.InternalException:<init>(32)』
Parameters is not matched
Bind var('?') count 2 And parameters counts are 1 [21]
Query:
select
*
from
( select
row_.*,
rownum rownum_
from
( select
user0_.USER_ID as USER1_0_,
user0_.LOGIN_ID as LOGIN2_0_,
user0_.LOGIN_PASSWD as LOGIN3_0_,
user0_.USER_NAME as USER4_0_,
user0_.USER_DESC as USER5_0_,
user0_.HASH_TYPE as HASH6_0_,
user0_.LAST_ACCESS_TM as LAST7_0_
from
AA_USER user0_ ) row_
where
rownum <= ?/**P*/
)
where
rownum_ > ?/**P*/
/////////////////////
source
import java.util.List;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.nbpcorp.newproj.domain.User;
public class UserDAO extends HibernateDaoSupport {
public void init(SessionFactory sessionFactory) {
setSessionFactory(sessionFactory);
}
public List selectUserList() {
Query query = this.getSession().createQuery("from " + User.class.getName());
query.setFirstResult(10);
query.setMaxResults(10 + 1);
List list = query.list();
return list;
}
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira