mapping file (a bit stripped down for clarity):


User.hbm.xml
----------------

<hibernate-mapping>

<class name="com.myApp.user.User" table="USER">

...........

<property name="emailAddress" type="java.lang.String">
<column name="EMAIL_ADDRESS" length="80" not-null="true" />
</property>

<property name="password" type="java.lang.String">
<column name="PASSWORD" length="25" not-null="true" />
</property>

...............

</class>
</hibernate-mapping>



I want to know whether its possible to specify some native sql for just 1 field in my mapping file - ie. for the 'password' field, or would I need to specify the whole SELECT in a named <sql-query> in this case?


I need to use the MySQL decode() function to retrieve my passwords since encode() has been used to put them in. :=(

are you telling me no one here can answer this?

If no-one can give me a yes/no on this then this is a reason to abandon Hibernate in my view - it cant be that hard come on..