hi,

we are using oracle as the backend. I am migrating from hand written sql code to hibernate.

we have a function called encrypt_password.



and we have a sql like this:

select firstName, lastName, encrypt_password(password) from user

does hibernate support sql like that?

I tried several ways, but looks like I have no way to map 'encrypt_password(password)' to a java attribute.

my mapping file is like
<
....
<property name="firstName" column="firstName"/>
<property name="password" column="password"/>
....
>

please help.

If its read only, you can map it with formula: <property name="password" formula="encrypt(PASSWORD)"/>