tl;dr: The property jdbc.time_zone doesn't seem to work.
I am currently facing a weird issue with Hibernate and timezones. Since I'm from Germany, I live in a UTC+2 timezone. But we actually want our database dates to be stored in UTC.
I tried a few steps and asked on Stackoverflow before opening the bug: https://stackoverflow.com/questions/50129116/wildfly-timezone-with-jpa
None of the described stuff did fix the problem. The times are perfectly fine within the java code, so it's likely to be a bug in the hibernate subsystem of WildFly12.
We did set the <property name="hibernate.jdbc.time_zone" value="UTC"/> in the persistence.xml, we also started WildFly with UTC timezone as command line argument and in the *.conf file. It's just not heeding the timezone, it's always using my system default. The bug is gone when I switch to UTC on my machine - but this can't be the "fix" for this problem.
If we don't set the system time to UTC, all date values in the database are UTC+2. |
|
