getting result set into DTO with native SQL Query in Hibernate
You could maybe use a result transformer. Quoting Hibernate 3.2: Transformers for HQL and SQL: SQL Transformers With native sql returning non-entity beans or Map’s is often more useful instead of basic Object[]. With result transformers that is now possible. List resultWithAliasedBean = s.createSQLQuery( “SELECT st.name as studentName, co.description as courseDescription ” + “FROM Enrolment … Read more