I'm working on a java web project that uses:
Hibernate
5.2.2
/JPA2.0
+MySQL5InnoDBDialect
MySQL
5.6.15
-innoDB
(on EasyPHP/PHPMyAdmin) + JDBCconnector 6.0.4
- Joda time API
2.9.4
+ Fasterxml jackson API2.8.3
I'm facing a problem on inserting Time
data on database. everytime i put a row, i get a +1H value on time column!
- Attribute on
Java
:
@JsonFormat(shape=JsonFormat.Shape.STRING, pattern="HH:mm")
@Column(name = "RES_DUREE", nullable = false)
@Temporal(TemporalType.TIME) private Date resDuree;
- Attribute on
SQL
:
RES_DUREE TIME NOT NULL;
EDIT (After Adrian Shum's Comment):
- Connection line:
jdbc.url = jdbc:mysql://localhost:3306/mydb?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
I do use UTC but it still 1H+ .
Any suggestion will help, thanks.