SQLQuery + mapping

edoA · **Joined:** Thu Oct 27, 2005 8:49 am **Posts:** 3

Hello,

I have table USER with attribues name, birthday.
I have a mapping to this table USER.

Now I want to create a SQLQuery which have only to fetch the name of the table USER.

Is this only possible with a new mapping, that maps only the attribute name ?

--

kochcp · **Posted:** Fri Oct 28, 2005 10:16 am

no. your mapping is fine how it is.

you could make a named sql-query that only returns the name attribute

Code:

<sql-query name="getNameFromUser">
   <return-scalar column="name" type="string"/>
      <![CDATA[
         select name from user
      ]]>
</sql-query>

this will return a List of all the names

edoA · **Joined:** Thu Oct 27, 2005 8:49 am **Posts:** 3

okay, this will help me. thank u.

Is there any other solution, and without new mapping?

I'd use a SQLQuery cause of SQL-UNION
my related post:
http://forum.hibernate.org/viewtopic.php?t=949388&highlight=