how to define password column in hibernate

[kwame Iwegbue]

Does anyone know how to annotate a class or define in a hbm.xml file, an element that produces a password column- providing for encryption, (using hibernate3.2) similar to writing the following statement in SQL:

 create table users
(
    username varchar(16) not null,
    password binary not null,
 
);
   

and then the following would insert encrypted password:

  
 
INSERT INTO users(username, password) VALUES('ray', PASSWORD('rain'));
  

Thanks!!

The problem i'm having is with the PASSWORD() function. I can't seem to find its equivalent in hibernate or JPA
[ May 09, 2007: Message edited by: kwame Iwegbue ]

[Paul Sturrock]

"password" data type? Which database are you using? Sounds like a vendor-specific data type, if it is I'd keep this out of the mapping (just use a character type and encrypt the text).

In Hibernate you treat functions like they were named queries. Have a read of the docs on named queries for more info.

[kwame Iwegbue]

Thanks Paul.
how do I encrypt the text. Its MySQL database