You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Donald Woods (JIRA)" <ji...@apache.org> on 2010/04/08 22:46:36 UTC
[jira] Created: (OPENJPA-1620) Fix TestJDBCEscapeDate test for
MSSQL
Fix TestJDBCEscapeDate test for MSSQL
-------------------------------------
Key: OPENJPA-1620
URL: https://issues.apache.org/jira/browse/OPENJPA-1620
Project: OpenJPA
Issue Type: Bug
Components: jdbc
Affects Versions: 2.0.0-beta3
Reporter: Donald Woods
Assignee: Donald Woods
Fix For: 2.0.0
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]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (OPENJPA-1620) Fix TestJDBCEscapeDate test for
MSSQL
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods resolved OPENJPA-1620.
-----------------------------------
Resolution: Fixed
applied to 2.0.x and trunk
> Fix TestJDBCEscapeDate test for MSSQL
> -------------------------------------
>
> Key: OPENJPA-1620
> URL: https://issues.apache.org/jira/browse/OPENJPA-1620
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0-beta3
> Reporter: Donald Woods
> Assignee: Donald Woods
> Fix For: 2.0.0
>
> Attachments: OPENJPA-1620.patch
>
>
> 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]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Work started: (OPENJPA-1620) Fix TestJDBCEscapeDate test for
MSSQL
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on OPENJPA-1620 started by Donald Woods.
> Fix TestJDBCEscapeDate test for MSSQL
> -------------------------------------
>
> Key: OPENJPA-1620
> URL: https://issues.apache.org/jira/browse/OPENJPA-1620
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0-beta3
> Reporter: Donald Woods
> Assignee: Donald Woods
> Fix For: 2.0.0
>
>
> 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]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1620) Fix TestJDBCEscapeDate test for
MSSQL
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods updated OPENJPA-1620:
----------------------------------
Attachment: OPENJPA-1620.patch
copy of patch
> Fix TestJDBCEscapeDate test for MSSQL
> -------------------------------------
>
> Key: OPENJPA-1620
> URL: https://issues.apache.org/jira/browse/OPENJPA-1620
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0-beta3
> Reporter: Donald Woods
> Assignee: Donald Woods
> Fix For: 2.0.0
>
> Attachments: OPENJPA-1620.patch
>
>
> 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]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1620) Fix TestJDBCEscapeDate test for
MSSQL
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods updated OPENJPA-1620:
----------------------------------
Issue Type: Test (was: Bug)
> Fix TestJDBCEscapeDate test for MSSQL
> -------------------------------------
>
> Key: OPENJPA-1620
> URL: https://issues.apache.org/jira/browse/OPENJPA-1620
> Project: OpenJPA
> Issue Type: Test
> Components: jdbc
> Affects Versions: 2.0.0-beta3
> Reporter: Donald Woods
> Assignee: Donald Woods
> Fix For: 2.0.0
>
> Attachments: OPENJPA-1620.patch
>
>
> 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]
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira