Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Hi,
I have a trouble in using mysql's max & lpad in Hibernate.
I need to get value from MYSQL code as folloing code:
"select max(lpad(gw_trx_id, 16, '0000000000000000')) from FP_TRANSACTION;", gw_trx_id is digital string. this code can work in MYSQL.
But I don't know how to make it work in Hibernate, I seeking example in web using google, but find no any answer. I hope Hibernate has more example for usage.

Please give me a suggestion.