Hello everybody,
When I want to store LocalTime and OffsetTime into a Time column with the hibernate.jdbc.time_zone set on "UTC" the value is not correctly handle if we are on a Daylight Saving Time period.
Consider this entity :
{code:java}
@Entity
@Table(name = "avdev_myData")
public class MyData implements Serializable {
private static final long serialVersionUID = 1L;
@Id
private Long id;
@Column(name = "local_time")
private LocalTime localTime;
}
{code}
Add this in your configuration :
{code:xml}
<property name="hibernate.jdbc.time_zone" value="UTC"/>
{code}
Add a new row with a local Time at 12:00pm
{code:java}
MyData myData = new MyData();
myData.setId(1L);
myData.setLocalTime(LocalTime.of(12, 0));
entityManager.persist(myData);
entityManager.getTransaction().commit();
{code}
The value expected is: *10:00am*
The actual value is: *11:00am*
Change with Instant object and Timestamp column make it working as expected and the value stored is "My time minus 2 hours". Because we are on a DST period, the transformation for LocalTime into UTC values are not handle properly and the DST is ignored.
We can reproduced this with both LocalTime and OffsetTime objects.
I have a full test case from Hibernate templates here : [https://github.com/avdev4j/hibernate_utc_localTime|https://github.com/avdev4j/hibernate_utc_localTime]
Just launch the storeLocalTimeShouldReturnWithAnUtcValue() unit test.
Hope it can help to improve this option because it's very usefull.
It's my first report, if If you need more informations please tell me (y). |
|
