Select value object with native SQL

jherbst · **Posted:** Fri Sep 15, 2006 9:23 am

Hi,

I've already searched the documentation and this forum but didn't find any information. Can anybody tell me, if it's possible to fetch a collection of value objects with native SQL?
I've already tried the following, but withou success (NPE):

Code:

        SQLQuery query = getSession().createSQLQuery(articleQuery.toString());
        query.addEntity("article",Article.class);
        query.addJoin("articleimages","article.articleImages");

Is this possible at all?

Greetings
Joerg

Hibernate version: 3.2

Mapping documents:

Code:

   <class name="Article" table="ARTICLE" >
                ...
      <set name="articleImages" table="ARTIMG" >
         <cache usage="read-only"/>
         <key column="001" />
         <element column="002"
            type="trimmedString">
         </element>
      </set>

psycotrompus · **Joined:** Thu Jul 06, 2006 11:09 pm **Posts:** 25

Use the following class annotations:

@NamedNativeQueries that contains an array of @NamedNativeQuery.

then associate the @NamedNativeQuery using the resultSetMapping parameter with the name of @SqlResultSetMapping class annotation.

Then you may use ScrollableResults from session.getNamedQuery("query").scroll();

This works for me.