Attribute resultClass doesn't work with NamedNativeQuery -------------------------------------------------------- Key: HHH-6884 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6884 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.6.6 Environment: Hibernate 3.6.6.Final over JPA 2.0 Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production Reporter: Tomasz Przybyła Attribute resultClass is set to Long.class, but query returns a list of BigDecimal objects. Below you can see definition of NamedNativeQuery: {code} @NamedNativeQueries( @NamedNativeQuery(name = "getUserGroupsIds", query = "select id from identities_hierarchy connect by prior id = childid start with childid = ?", resultSetMapping = "groupIdMapping", resultClass = Long.class ) ) @SqlResultSetMapping(name = "groupIdMapping", columns = @ColumnResult(name = "id") ) {code} Following code executes this query: {code} List<Long> result = getEntityManager().createNamedQuery("getUserGroupsIds", Long.class) .setParameter(1, userId) .getResultList(); System.out.println("Returned object is of type: " + ((Iterator<?>) result.iterator()).next().getClass()); {code} The id column in database is of type NUMBER(10, 0). There are no problems with CriteriaQueries and HQL. Any suggestion how to solve this problem will be greatly welcomed :] -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira