Hi, has anyone got any tips on using a custom sql query (can't use hql as need connect by prior) and i have added a property with a formula. I just keep getting NPE - like bug HHH-2536 (https://hibernate.onjira.com/browse/HHH-2536), but I'm using version 4.1.9.final which i think has been resolved. (dialect is Oracle).

Here's the relevant bit of my hbm.xml (obviously just using sysdate to test things out as gives same NPE):

<property name="test" formula="(select to_char(sysdate) from dual)" type="string"/>
...
<sql-query
name="mblTree"> SELECT m.*, (select to_char(sysdate) from dual) test
FROM mytable m
START WITH mbl_title = :startMblTitle
CONNECT BY PRIOR mbl_id = mbl_parent_id
<return alias="MyTable" class="com.processor.MyTable"/>
</sql-query>

Any help would be much appreciated.

Tim.

You may use NamedQuery.

http://www.roseindia.net/hibernate/hibernate4/HibernateNamedNativeSQLXML.shtml

Thanks for the reply, but might have misunderstood my issue. The problem is when I add another property to my hbm.xml file that is a formula (works fine if its just mapped to a column)...

<property name="test" formula="(select to_char(sysdate) from dual)" type="string"/>

The formula works by itself, and the query works by itself (with just m.*) but together they throw NPE which is exactly what was specified here: https://hibernate.onjira.com/browse/HHH-2536, but this has been fixed, but can't find any usage notes on it.

Cheers,

Tim.