I have a table with PK field as Varchar2.
accordingly I have value object representing the field with String member attribute.

now currently the pk value is running serial number starting from 1 and onwards.

in oracle we can write select max(to_number(pk_field)) from table;

but hibernate is not taking this query to get me the records.

Reason is to_number is not qualified method in hibernate scope.

anyone with solution on this ?