JPA Mapping Date and Enum

Hello, good afternoon.

Let us see today how to map in JPA the Date attribute and the Enum attribute.

Maybe there are people that almost got a heart attack when they hear about Date in Java. The APIs can be a little complex to those that are learning about Java.

Fortunately we can find a good solution in JPA to persist a Date attribute. The @Temporal annotation allows us to map 3 options:

  • Just date.
  • Just time.
  • Date and Time.

Check the code bellow:

private Date onlyDate;

private Date onlyTime;

private Date dateAndTime;

It is a very simply way to persist a date field. You can choose the attribute information type just using the right annotation type.

To map an Enum is easy as mapping a Date. To map an Enum in JPA you just have to write the code bellow:

private Enum vaules;

private Enum vauleAsString;

private Enum vauleAsNumber;

You may leave the @Enumerated without parameters, or you may define it as: String or Ordinal.

If your table is not a huge table, you can define your Enum field as String. It is easier to read a status = ‘OK’ or ‘NOK’ than status = 1 (same than status = ‘OK’).

Notice that a query using a String as parameter will use more processing from the database than using a number; if your table is a huge table, it is a better idea to have your status as number and another table to store the status description.

Another solution (less elegant) it would be having both columns in the same table, a column with status = ‘1’ and another column with status_type = ‘OK’.

I hope this little post might be able to help you.

If you have any Doubts/Suggestions just post it.

See you soon.

Leave a Comment