Load only some columns with Hibernate native SQL queries
Posted
by
Alessandro Dionisi
on Stack Overflow
See other posts from Stack Overflow
or by Alessandro Dionisi
Published on 2011-01-05T10:32:23Z
Indexed on
2011/01/06
12:53 UTC
Read the original article
Hit count: 186
I have a table on the database and I want to load only some columns from the result set. I defined a native sql query in the hbm file:
<sql-query name="query">
<return alias="r" class="RawData"/>
<![CDATA[
SELECT DESCRIPTION as {r.description}
FROM RAWD_RAWDATAS r
WHERE r.RAWDATA_ID=?
]]>
</sql-query>
This query however fails with error: could not read column value from result set: RAWDATA1_14_0_; Invalid column name SQL Error: 17006, SQLState: null, because Hibernate tries to load all fields from the result set. I found also a bug in Hibernate JIRA (http://opensource.atlassian.com/projects/hibernate/browse/HHH-3035). Anyone knows how to accomplish this task with a workaround?
© Stack Overflow or respective owner