[hibernate-issues] [JIRA] (HHH-13984) Differences in "timestamp" resolution in dialects for hsqldb and mssql

[Carsten Hammer (JIRA)]

Carsten Hammer ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Ad5423ad0-e635-4a62-af47-9f84327bde1d ) *created* an issue

Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZGE0YjA3NTkxODJhNGZlYzhmMWI1OWI4YjU0ZTVmMTQiLCJwIjoiaiJ9 ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-13984?atlOrigin=eyJpIjoiZGE0YjA3NTkxODJhNGZlYzhmMWI1OWI4YjU0ZTVmMTQiLCJwIjoiaiJ9 ) HHH-13984 ( https://hibernate.atlassian.net/browse/HHH-13984?atlOrigin=eyJpIjoiZGE0YjA3NTkxODJhNGZlYzhmMWI1OWI4YjU0ZTVmMTQiLCJwIjoiaiJ9 ) Differences in "timestamp" resolution in dialects for hsqldb and mssql ( https://hibernate.atlassian.net/browse/HHH-13984?atlOrigin=eyJpIjoiZGE0YjA3NTkxODJhNGZlYzhmMWI1OWI4YjU0ZTVmMTQiLCJwIjoiaiJ9 )

Issue Type: Improvement Affects Versions: 5.4.6 Assignee: Unassigned Components: hibernate-core Created: 27/Apr/2020 06:20 AM Priority: Major Reporter: Carsten Hammer ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Ad5423ad0-e635-4a62-af47-9f84327bde1d )

If you make use of a "timestamp" datatype in your mapping of java code (java.util.Date) and have a roundtrip through the entity mapping of hibernate to the database you might loose resolution.
While in SQLServer2008Dialect "timestamp" is mapped to the mssql datatype datetime2 which defaults to datetime2(7) in the HSQLDialect you find a mapping to the hsql datatype timestamp which defaults to timestamp(6).

https://docs.microsoft.com/de-de/sql/t-sql/data-types/datetime2-transact-sql?view=sql-server-ver15
http://hsqldb.org/doc/2.0/guide/sqlgeneral-chapt.html#sgc_datetime_types

( https://hibernate.atlassian.net/browse/HHH-13984#add-comment?atlOrigin=eyJpIjoiZGE0YjA3NTkxODJhNGZlYzhmMWI1OWI4YjU0ZTVmMTQiLCJwIjoiaiJ9 ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13984#add-comment?atlOrigin=eyJpIjoiZGE0YjA3NTkxODJhNGZlYzhmMWI1OWI4YjU0ZTVmMTQiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100125- sha1:c966059 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200427/26d46e45/attachment.html