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

Fix TestJDBCEscapeDate test for MSSQL

    Details

    • Type: Test
    • Status: Closed
    • Priority: 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]

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: