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

        Donald Woods created issue -
        Donald Woods made changes -
        Field Original Value New Value
        Status Open [ 1 ] In Progress [ 3 ]
        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
        Donald Woods made changes -
        Status In Progress [ 3 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Hide
        Donald Woods added a comment -

        copy of patch

        Show
        Donald Woods added a comment - copy of patch
        Donald Woods made changes -
        Attachment OPENJPA-1620.patch [ 12441207 ]
        Donald Woods made changes -
        Issue Type Bug [ 1 ] Test [ 6 ]
        Donald Woods made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open In Progress In Progress
        18s 1 Donald Woods 08/Apr/10 20:46
        In Progress In Progress Resolved Resolved
        8m 37s 1 Donald Woods 08/Apr/10 20:55
        Resolved Resolved Closed Closed
        13d 23h 34m 1 Donald Woods 22/Apr/10 20:30

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development