Hi I think I found a bug using the Criteria API. I am using Hibernate 3.2.0.cr5 (according to the META-INF in hibernate3.jar) with Oracle9, thin driver and Oracle9 dialect
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 wrote the following

getHibernateTemplate().find("from Woffre woffre where rownum <= ? order by woffre.sid asc", 50);

... which produces a 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 work with an int...

Is this a (known ?) bug ? or just a misconfiguration?

The criteria api works fine
Maybe this is an oracle specific problem : are you sure of the dialect you use (there is two dialects for oracle)
What's the link between the criteria call and the hql one ? Does hibernate converts maxresult with rownum>? for oracle ?

I am using dialect org.hibernate.dialect.Oracle9Dialect for an Oracle 9 database



yes, I copied/pasted the "where" clause displayed as a log when using the Criteria API

OK, as nobody seems to know about this problem, I raised this issue : http://opensource.atlassian.com/project ... e/HHH-2509

Just a tip : this is an open source project that cannot reproduce all the possible environments.
As your problem seems to be environment specific you may have to provide more informations for your jira.
At least hibernate developers need a test case that reproduce the problem. The best you can do is a patch that solve it but it is a lot more work