How to store date/time and timestamps in UTC time zone with JPA and Hibernate

by

Since Hibernate 5.2, you can now force the UTC time zone by adding the following configuration property into the properties.xml JPA configuration file:

<property name="hibernate.jdbc.time_zone" value="UTC"/>

If you’re using Spring Boot, then add this property to your application.properties file:

spring.jpa.properties.hibernate.jdbc.time_zone=UTC

More Related Contents:

  1. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  2. Hibernate Annotations – Which is better, field or property access?
  3. How to map calculated properties with JPA and Hibernate
  4. Bypass GeneratedValue in Hibernate (merge data not in db?)
  5. How does the FetchMode work in Spring Data JPA
  6. What is “the inverse side of the association” in a bidirectional JPA OneToMany/ManyToOne association?
  7. Hibernate – @ElementCollection – Strange delete/insert behavior
  8. Difference between @OneToMany and @ElementCollection?
  9. What is the difference between CascadeType.REMOVE and orphanRemoval in JPA?
  10. JPA SQL Server No Dialect mapping for JDBC type: -9
  11. Transaction marked as rollback only: How do I find the cause
  12. JPA entity without id
  13. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  14. How to use multiple JOIN FETCH in one JPQL query
  15. Multiple fetches with EAGER type in Hibernate with JPA
  16. Could not commit JPA transaction: Transaction marked as rollbackOnly
  17. Spring JpaRepository – Detach and Attach entity
  18. java.lang.IllegalStateException: Multiple representations of the same entity with @ManyToMany 3 entities
  19. JPA: what is the proper pattern for iterating over large result sets?
  20. JPA Query.getResultList() – use in a generic way
  21. Spring Data JPA and Exists query
  22. Large Objects may not be used in auto-commit mode
  23. IllegalStateException with Hibernate 4 and ManyToOne cascading
  24. Force refresh of collection JPA entityManager
  25. Hibernate triggering constraint violations using orphanRemoval
  26. Error creating bean with name ‘entityManagerFactory
  27. JPA: How do I specify the table name corresponding to a class at runtime?
  28. When to use DiscriminatorValue annotation in hibernate
  29. Unsuccessful: alter table XXX drop constraint YYY in Hibernate/JPA/HSQLDB standalone
  30. JPA: difference between @JoinColumn and @PrimaryKeyJoinColumn?

Leave a Comment