[OPENJPA-1968] SQLServerDictionery not using DATETIME2 for jdbc driver other than MS JDBC driver

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0, 2.1.1, 2.2.0
• Fix Version/s: 2.1.1, 2.2.0
• Component/s: sql
• Patch Info: Patch Available
• Assignee: Albert Lee
• Reporter: Albert Lee
• Created: 29/Mar/11 16:23
• Updated: 05/Apr/11 21:09
• Resolved: 05/Apr/11 21:09

Description

Use of DATETIME2 db type for Date/Time/Timestamp should based on the SQLServer database version not driver type/vendor.

As a consequence, if version field is a Timestamp data type, you may get optimistic lock exception due to timestamp precision mismatch and hence update to entity may failed.