OpenJPA
  1. OpenJPA
  2. OPENJPA-1620

Fix TestJDBCEscapeDate test for MSSQL

    Details

    • Type: Test Test
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0-beta3
    • Fix Version/s: 2.0.0
    • Component/s: jdbc
    • Labels:
      None

      Description

      Some of the test jpql strings used in TestJDBCEscapeDate are not compatible with MSSQL.

      <openjpa-2.1.0-SNAPSHOT-runknown fatal general error> org.apache.openjpa.persistence.PersistenceException: Conversion failed when converting date and/or time from character string. {prepstmnt 24801516 SELECT t0.empId, t0.hireDate, t0.hireTime, t0.hireTimestamp, t0.name, t0.someLong, t0.statusId FROM SUBQ_EMPLOYEE t0 WHERE (t0.hireDate >=

      {d '2009-8-5'})} [code=241, state=S0003]
      FailedObject: select a from Employee a where a.hireDate >= {d '2009-8-5'}

      [java.lang.String]

        Activity

        Hide
        Donald Woods added a comment -

        applied to 2.0.x and trunk

        Show
        Donald Woods added a comment - applied to 2.0.x and trunk
        Hide
        Donald Woods added a comment -

        copy of patch

        Show
        Donald Woods added a comment - copy of patch

          People

          • Assignee:
            Donald Woods
            Reporter:
            Donald Woods
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development