[OPENJPA-1620] Fix TestJDBCEscapeDate test for MSSQL

• Type: Test
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0-beta3
• Fix Version/s: 2.0.0
• Component/s: jdbc
• Assignee: Donald Woods
• Reporter: Donald Woods
• Created: 08/Apr/10 20:46
• Updated: 22/Apr/10 20:30
• Resolved: 08/Apr/10 20:55

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]