Currently I have a small table with 2 columns, ID(int) & ELEMENT_XPATH(varchar) I am trying to find some way that I can have an Integer value of 1 or 0 returned if the value of ELEMENT_XPATH is an encrypted string ( I have a DES utility class I would like to use ) without creating a new column in the table. I tried using a property & a custom UserType but that always seems to generate a SELECT clause for the non-existent column. I also created a get/set method for this in the POJO but without a property mapping I do not get access to the property via MAP or DOM4J entity modes.

Any help appreciated,

Matt.

try use formula
see : http://www.hibernate.org/hib_docs/reference/en/html_single/#mapping-declaration-property