[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2509) Criteria.setMaxResults(int) broken with Oracle9Dialect, only works with a long in a HQL query
Criteria.setMaxResults(int) broken with Oracle9Dialect, only works with a long in a HQL
query
---------------------------------------------------------------------------------------------
Key: HHH-2509
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2509
Project: Hibernate3
Type: Bug
Components: query-criteria
Versions: 3.2.0.cr5
Environment: Windows XP, Oracle 9, Spring 2.0.3, Hibernate 3.2.0.cr5
Reporter: Gabriel Goïc
Willing to extract 50 random elements from my database, I wrote the following snippet of
code:
Criteria crit = getSession().createCriteria(Woffre.class);
crit.setMaxResults(50);
crit.addOrder(Order.asc("sid"));
return crit.list();
As you can see, there's nothing particular here. But executing this code gives the
following error:
org.hibernate.exception.GenericJDBCException: could not execute query
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2160)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2041)
at org.hibernate.loader.Loader.list(Loader.java:2036)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:95)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at
fr.apec.proto.server.dao.impl.WOffreDAOImpl.loadFirst50WOffres(WOffreDAOImpl.java:55)
(...)
Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.driver.OracleStatement.checkBindsInAndOut(OracleStatement.java:1971)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2812)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)
(...)
So, I decided to use HQL to work around this problem and copied/pasted the
"where" clause displayed as a log when using the Criteria API :
getHibernateTemplate().find("from Woffre woffre where rownum <= ? order by
woffre.sid asc", 50);
... which produces a java.lang.ClassCastException with java.lang.Integer whereas the
following
getHibernateTemplate().find("from Woffre woffre where rownum <= ? order by
woffre.sid asc", (long)50);
... just works fine
It seems that Criteria.setMaxResults(int) should take a long instead of an int, as the
Criteria API seems not able to get the conversion done, which causes a crash; or maybe the
underlying implementation should be able to work with an int...
PS: I first posted this problem on the hibernate users forum :
http://forum.hibernate.org/viewtopic.php?t=972225
--
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