Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-1968

SQLServerDictionery not using DATETIME2 for jdbc driver other than MS JDBC driver

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.1.0, 2.1.1, 2.2.0
    • 2.1.1, 2.2.0
    • sql
    • None
    • Patch Available

    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.

      Attachments

        1. TestDDTimestamp.java
          3 kB
          Albert Lee
        2. OPENJPA-1968.patch
          2 kB
          Albert Lee

        Activity

          People

            allee8285 Albert Lee
            allee8285 Albert Lee
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: