Hi all,

Spring and Hibernate provided the way to insert a record into database via the save() method.
Ex:
User() user = new User(int id, String name);
userDAO.save(user);

which is great.
However I am stuck at this:
I need to execute this query to insert a record to the table user
SQL query: "insert into user values("My name", AES_ENCRYPT("clear_txt", "key"));
Just for example: My table user has two fields: 'name', and 'password'. The password needed to encrypt with some key. AES_ENCRYPT is a function in MySQL.

How do I do this the Hibernate way?
I had looked around and seem like Hibernate doesn't has the insert query.

If this is not the right way to do it, how do you deal with a requirement to encrypt a field in database with provided key?

Thanks in advance,

Thai