How to encrypt a database entry when using javax.persistence package?

[deirdre lee]

Hi,
I was wondering is there any way of encrypting a data entry that you persist to a database using the javax.persistence package.

For example the following SQL statement would be used to enter the data directly into the database using JDBC:

INSERT INTO usertable (username, password) VALUES ( 'user1',  AES_ENCRYPT( 'pass1', 'encryptText' ) );

But using javax.persistence package, how is it possible to persist an object with an encrypted data element?

Extract from persistenceService:

public void persistEntity(Object entity)
    {
        entitymanager.persist(entity);
    }

Extract from myObject:

@Entity
@Table(name = "usertable"
@NamedQueries({@NamedQuery(name = "user.findById", query = "SELECT c FROM user c WHERE c.id = :id"), @NamedQuery(name = "user.findByUsername", query = "SELECT c FROM user c WHERE c.username = :username"), @NamedQuery(name = "user.findByPassword", query = "SELECT c FROM userc WHERE c.password = :password")})
public class userimplements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @Column(name = "id", nullable = false)
    private Integer id;
    @Column(name = "username")
    private String username;
    @Column(name = "password")
    private String password;

[Luciano A. Pozzo]

Maybe you could use Entity Listeners:

@java.persistence.PrePersist

@java.persistence.PostPersist

@java.persistence.PostLoad

@java.persistence.PreUpdate

@java.persistence.PostUpdate

@java.persistence.PreRemove

@java.persistence.PostRemove