Spring JPA java.util.Date to Mysql timestamp with wrong date value

Question

I have a JPA entity with a date field is persisted into Mysql DateTime.

Field:

  @Column(name = "CREATION_DATE")
  private Date creationDate;

Column:
CREATION_DATE datetime DEFAULT NULL,

Setter:

request.setCreationDate(new Date());//Value set to current date

I am getting an strange error that persisted date is 8 hours lesser than the current time. Tried few approaches as below:

Using @Temporal(TemporalType.TIMESTAMP) for the field
Setting default TimeZone
TimeZone.setDefault(TimeZone.getTimeZone("GMT+8"));
Printing the date before setting, which displays the correct value.
Setting the timezone at mysql layer as well:
SET GLOBAL time_zone = '+8:00'; SET SESSION time_zone = '+8:00';
Changing the field type to java.sql.Timestamp

none of the above approaches helped. Anyone had a similar issue? Any clue?

I wonder what the JPA providers log says? You have looked at it haven't you? ... — Neil Stockton
– Neil Stockton, Commented Jul 1, 2017 at 6:21
Haven't tried printing the sql and parameter values. I will try enabling it. This issue is not happening in my dev machine which is running in oracle jdk happening only in the server which is running openjdk. Is there any difference between oracle and open jdk in this regard? — Ramprabhu
– Ramprabhu, Commented Jul 2, 2017 at 2:27
I tried printing the hibernate logs the time stamp is correct — Ramprabhu
– Ramprabhu, Commented Jul 4, 2017 at 15:06

Ramprabhu · Accepted Answer · 2019-01-02 16:10:50Z

4

Found the issue, the problem was in jdbc connection URL.

spring.datasource.url=jdbc:mysql://:3307/dbname?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

due to the server time zone setting in the URL, GMT+8 time was converted to UTC which was leading to the 8 hours time difference. After removing the serverTimezone parameter in the URL, date is working fine. Thank you Neil and Shazin for your time and support.

edited Jan 2, 2019 at 16:10

answered Jul 9, 2017 at 10:32

Ramprabhu

1951 silver badge14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring JPA java.util.Date to Mysql timestamp with wrong date value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related