I am new to Hibernate. Before using it, i would like to know whether there is a way to encrypt the data before inserting into database and decrypting it after fetching from database?

After a bit searching, I found Jasypt. But it needs the password to be stored in XML configuration file.

In my case, the password changes from table to table and should not be stored in the XML file. Is there anyway that I can get this done in Hibernate?

Have you taken a look at "org.hibernate.Interceptor", if you have your own module which does encryption/decryption then you can use interceptor to encrypt the data before inserting and decrypt it after fetching from database. You can find details of interceptor at http://docs.jboss.org/hibernate/core/3.3/reference/en/html/events.html

I think you can use Listerners (callback @PrePersit and @PostLoad for encryption/decryption respectively). Or as cited mpujari80, the Interceptor (but I think more difficult and it's not JPA)