[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4738) getSingleResult returning SQLException in DerbyDialect

getSingleResult returning SQLException in DerbyDialect ------------------------------------------------------ Key: HHH-4738 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4738 Project: Hibernate Core Issue Type: Bug Components: query-hql Affects Versions: 3.5.0-Beta-2 Environment: hibernate 3.5.0-0.2, Glassfish v3, Derby Reporter: Samuel Halliday I am encountering problems when issuing getSingleResult queries using the Glassfish v3 "hibernate 3.5.0-0.2". These queries work fine if I use hibernate 3.3.1.GA, or a PostgreSQL backend/dialect. Something between 3.3.1 and 3.5 has therefore introduced this bug. The queries are along the lines of [code] Query q = em.createQuery("SELECT COUNT(s) FROM MyTable s"); Long result = (Long) q.getSingleResult(); [/code] and [code] Query query = em.createQuery("SELECT s FROM MyTable s ORDER BY s.id"); query.setFirstResult(id); query.setMaxResults(1); MyTable random = (MyTable) query.getSingleResult(); [/code] The exception I am seeing is below, when used with (at least) the Java Derby DB. The message is "The column position '1' is out of range. The number of columns for this ResultSet is '0'." [code] Caused by: java.sql.SQLException: The column position '1' is out of range. The number of columns for this ResultSet is '0'. at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.ColumnMetaData.getColumnType(Unknown Source) at org.apache.derby.client.am.PreparedStatement.setInt(Unknown Source) at org.hibernate.loader.Loader.bindLimitParameters(Loader.java:1669) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1594) at org.hibernate.loader.Loader.doQuery(Loader.java:694) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:257) at org.hibernate.loader.Loader.doList(Loader.java:2232) ... 42 more Caused by: org.apache.derby.client.am.SqlException: The column position '1' is out of range. The number of columns for this ResultSet is '0'. at org.apache.derby.client.am.ColumnMetaData.checkForValidColumnIndex(Unknown Source) ... 49 more [/code]