How to validate String of Email in JPA entity

Question

I have a column in database of length 512. It is going to contain multiple email address separated by ";". How can I validate its respective variable in the entity so that all the email address are valid.

List will not work as I need to persist it in the column. Here is the data:

@Basic
@Column(name = "CC_EMAIL_ADDRESS", nullable = true, length = 512)
private String emailCC;

score 1 · Answer 1 · answered May 03 '19 at 05:52

Use the javax.validation library. This will throw a validation exception if it fails to validate when you set attempt to persist the email, or you can do manual validation with starting with a ValidatorFactory.

@NotNull(message="{email.required}")
@Pattern(regexp = "[A-Za-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\\."
        + "[A-Za-z0-9!#$%&'*+/=?^_`{|}~-]+)*@"
        + "(?:[A-Za-z0-9](?:[A-Za-z0-9-]*[A-Za-z0-9])?\\.)+[A-Za-z0-9]"
        + "(?:[A-Za-z0-9-]*[A-Za-z0-9])?",
        message = "{invalid.email}")
private String email;

Java bee · Answer 2 · 2019-10-23T10:12:35.770

1

This way I use with good success in my Projects

@NotEmpty
@Email
@Size(max = 255)
@Column(unique = true)
private String email;


@PrePersist
@PreUpdate
private void prepareData(){
    this.email = email == null ? null : email.toLowerCase();
}

edited Oct 23 '19 at 10:12

answered Oct 22 '19 at 16:43

Java bee

2,522
1
12
25

Code-only answers are considered low quality: make sure to provide an explanation what your code does and how it solves the problem. It will help the asker and future readers both if you can add more information in your post. See also Explaining entirely code-based answers: https://meta.stackexchange.com/questions/114762/explaining-entirely-code-based-answers – borchvm Oct 23 '19 at 06:46

score 0 · Answer 3 · answered May 03 '19 at 05:06

0

You can use @PrePersist Callback event in your entity to valdiate the email before saving it to database.

@PrePersist
public void validateEmails(){
    //Validate Here
}

Or you can make a setter method in your Entity and validate the data in setter method.

answered May 03 '19 at 05:06

Vikram Singh Shekhawat

714
1
10
27

I cant use PrePersist as it wil execute everytime the entity is called, and that is not suppose to happen – Rosey Khatun May 03 '19 at 07:40

score 0 · Answer 4 · answered May 03 '19 at 05:24

0

You can create a custom constraint.

@MyCustomConstraint
private String emailCC;

where @MyCustomConstraint will be your new annotation.

answered May 03 '19 at 05:24

Alex

11,451
6
37
52

score 0 · Answer 5 · answered May 03 '19 at 05:28

0

Use been validation and a regex:

@Basic
@Pattern(regexp = "\\w+@\\w+\\.\\w+(,\\s*\\w+@\\w+\\.\\w+)*")
@Column(name = "CC_EMAIL_ADDRESS", nullable = true, length = 512)

answered May 03 '19 at 05:28

sechanakira

243
3
11

How to validate String of Email in JPA entity

5 Answers5