You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Fay Wang (JIRA)" <ji...@apache.org> on 2010/02/05 07:02:27 UTC
[jira] Created: (OPENJPA-1496) Fail to set temporal parameter
Fail to set temporal parameter
------------------------------
Key: OPENJPA-1496
URL: https://issues.apache.org/jira/browse/OPENJPA-1496
Project: OpenJPA
Issue Type: Bug
Components: jdbc
Reporter: Fay Wang
Assignee: Fay Wang
Fix For: 2.1.0
For an entity:
@Entity
public class TimeEntity {
@Id
@GeneratedValue
private long id;
String name;
int value;
@Temporal(TemporalType.TIMESTAMP)
private java.util.Calendar cal2Timestamp;
...}
an attempt to set parameter as below fails with IllegalArgumentException:
String jpql = "SELECT COUNT(a) FROM TimeEntity a WHERE a.cal2Timestamp BETWEEN ?1 AND ?2";
Calendar endTime = Calendar.getInstance();
Calendar startTime = (Calendar)endTime.clone();
startTime.add(14, -4);
List results = em.createQuery(jpql).
setParameter(1, startTime, TemporalType.TIMESTAMP).
setParameter(2, endTime, TemporalType.TIMESTAMP).
getResultList();
java.lang.IllegalArgumentException: Parameter "Parameter<Calendar>(2)" declared in "SELECT COUNT(a) FROM TimeEntity a WHERE a.value = ?1 AND a.cal2Timestamp BETWEEN ?2 AND ?3" is set to value of "2/4/10 9:55 PM" of type "java.sql.Timestamp", but this parameter is bound to a field of type "java.util.Calendar".
at org.apache.openjpa.persistence.QueryImpl.assertValueAssignable(QueryImpl.java:1079)
at org.apache.openjpa.persistence.QueryImpl.bindValue(QueryImpl.java:1036)
at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:640)
at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:653)
at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:1)
at d637638.Test637638.testTemporalType(Test637638.java:36)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at junit.framework.TestCase.runTest(Unknown Source)
at junit.framework.TestCase.runBare(Unknown Source)
at junit.framework.TestResult$1.protect(Unknown Source)
at junit.framework.TestResult.runProtected(Unknown Source)
at junit.framework.TestResult.run(Unknown Source)
at junit.framework.TestCase.run(Unknown Source)
at junit.framework.TestSuite.runTest(Unknown Source)
at junit.framework.TestSuite.run(Unknown Source)
at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (OPENJPA-1496) Fail to set temporal parameter
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fay Wang closed OPENJPA-1496.
-----------------------------
> Fail to set temporal parameter
> ------------------------------
>
> Key: OPENJPA-1496
> URL: https://issues.apache.org/jira/browse/OPENJPA-1496
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 2.1.0
>
> Attachments: OPENJPA-1496-2.patch, OPENJPA-1496-3.patch, OPENJPA-1496.patch
>
>
> For an entity:
> @Entity
> public class TimeEntity {
> @Id
> @GeneratedValue
> private long id;
>
> String name;
>
> int value;
>
> @Temporal(TemporalType.TIMESTAMP)
> private java.util.Calendar cal2Timestamp;
> ...}
> an attempt to set parameter as below fails with IllegalArgumentException:
> String jpql = "SELECT COUNT(a) FROM TimeEntity a WHERE a.cal2Timestamp BETWEEN ?1 AND ?2";
> Calendar endTime = Calendar.getInstance();
> Calendar startTime = (Calendar)endTime.clone();
> startTime.add(14, -4);
> List results = em.createQuery(jpql).
> setParameter(1, startTime, TemporalType.TIMESTAMP).
> setParameter(2, endTime, TemporalType.TIMESTAMP).
> getResultList();
> java.lang.IllegalArgumentException: Parameter "Parameter<Calendar>(2)" declared in "SELECT COUNT(a) FROM TimeEntity a WHERE a.value = ?1 AND a.cal2Timestamp BETWEEN ?2 AND ?3" is set to value of "2/4/10 9:55 PM" of type "java.sql.Timestamp", but this parameter is bound to a field of type "java.util.Calendar".
> at org.apache.openjpa.persistence.QueryImpl.assertValueAssignable(QueryImpl.java:1079)
> at org.apache.openjpa.persistence.QueryImpl.bindValue(QueryImpl.java:1036)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:640)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:653)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:1)
> at d637638.Test637638.testTemporalType(Test637638.java:36)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at junit.framework.TestCase.runTest(Unknown Source)
> at junit.framework.TestCase.runBare(Unknown Source)
> at junit.framework.TestResult$1.protect(Unknown Source)
> at junit.framework.TestResult.runProtected(Unknown Source)
> at junit.framework.TestResult.run(Unknown Source)
> at junit.framework.TestCase.run(Unknown Source)
> at junit.framework.TestSuite.runTest(Unknown Source)
> at junit.framework.TestSuite.run(Unknown Source)
> at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1496) Fail to set temporal parameter
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fay Wang updated OPENJPA-1496:
------------------------------
Attachment: (was: OPENJPA-1460-3.patch)
> Fail to set temporal parameter
> ------------------------------
>
> Key: OPENJPA-1496
> URL: https://issues.apache.org/jira/browse/OPENJPA-1496
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 2.1.0
>
> Attachments: OPENJPA-1496-2.patch, OPENJPA-1496.patch
>
>
> For an entity:
> @Entity
> public class TimeEntity {
> @Id
> @GeneratedValue
> private long id;
>
> String name;
>
> int value;
>
> @Temporal(TemporalType.TIMESTAMP)
> private java.util.Calendar cal2Timestamp;
> ...}
> an attempt to set parameter as below fails with IllegalArgumentException:
> String jpql = "SELECT COUNT(a) FROM TimeEntity a WHERE a.cal2Timestamp BETWEEN ?1 AND ?2";
> Calendar endTime = Calendar.getInstance();
> Calendar startTime = (Calendar)endTime.clone();
> startTime.add(14, -4);
> List results = em.createQuery(jpql).
> setParameter(1, startTime, TemporalType.TIMESTAMP).
> setParameter(2, endTime, TemporalType.TIMESTAMP).
> getResultList();
> java.lang.IllegalArgumentException: Parameter "Parameter<Calendar>(2)" declared in "SELECT COUNT(a) FROM TimeEntity a WHERE a.value = ?1 AND a.cal2Timestamp BETWEEN ?2 AND ?3" is set to value of "2/4/10 9:55 PM" of type "java.sql.Timestamp", but this parameter is bound to a field of type "java.util.Calendar".
> at org.apache.openjpa.persistence.QueryImpl.assertValueAssignable(QueryImpl.java:1079)
> at org.apache.openjpa.persistence.QueryImpl.bindValue(QueryImpl.java:1036)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:640)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:653)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:1)
> at d637638.Test637638.testTemporalType(Test637638.java:36)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at junit.framework.TestCase.runTest(Unknown Source)
> at junit.framework.TestCase.runBare(Unknown Source)
> at junit.framework.TestResult$1.protect(Unknown Source)
> at junit.framework.TestResult.runProtected(Unknown Source)
> at junit.framework.TestResult.run(Unknown Source)
> at junit.framework.TestCase.run(Unknown Source)
> at junit.framework.TestSuite.runTest(Unknown Source)
> at junit.framework.TestSuite.run(Unknown Source)
> at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1496) Fail to set temporal parameter
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fay Wang updated OPENJPA-1496:
------------------------------
Attachment: OPENJPA-1496-3.patch
> Fail to set temporal parameter
> ------------------------------
>
> Key: OPENJPA-1496
> URL: https://issues.apache.org/jira/browse/OPENJPA-1496
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 2.1.0
>
> Attachments: OPENJPA-1496-2.patch, OPENJPA-1496-3.patch, OPENJPA-1496.patch
>
>
> For an entity:
> @Entity
> public class TimeEntity {
> @Id
> @GeneratedValue
> private long id;
>
> String name;
>
> int value;
>
> @Temporal(TemporalType.TIMESTAMP)
> private java.util.Calendar cal2Timestamp;
> ...}
> an attempt to set parameter as below fails with IllegalArgumentException:
> String jpql = "SELECT COUNT(a) FROM TimeEntity a WHERE a.cal2Timestamp BETWEEN ?1 AND ?2";
> Calendar endTime = Calendar.getInstance();
> Calendar startTime = (Calendar)endTime.clone();
> startTime.add(14, -4);
> List results = em.createQuery(jpql).
> setParameter(1, startTime, TemporalType.TIMESTAMP).
> setParameter(2, endTime, TemporalType.TIMESTAMP).
> getResultList();
> java.lang.IllegalArgumentException: Parameter "Parameter<Calendar>(2)" declared in "SELECT COUNT(a) FROM TimeEntity a WHERE a.value = ?1 AND a.cal2Timestamp BETWEEN ?2 AND ?3" is set to value of "2/4/10 9:55 PM" of type "java.sql.Timestamp", but this parameter is bound to a field of type "java.util.Calendar".
> at org.apache.openjpa.persistence.QueryImpl.assertValueAssignable(QueryImpl.java:1079)
> at org.apache.openjpa.persistence.QueryImpl.bindValue(QueryImpl.java:1036)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:640)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:653)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:1)
> at d637638.Test637638.testTemporalType(Test637638.java:36)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at junit.framework.TestCase.runTest(Unknown Source)
> at junit.framework.TestCase.runBare(Unknown Source)
> at junit.framework.TestResult$1.protect(Unknown Source)
> at junit.framework.TestResult.runProtected(Unknown Source)
> at junit.framework.TestResult.run(Unknown Source)
> at junit.framework.TestCase.run(Unknown Source)
> at junit.framework.TestSuite.runTest(Unknown Source)
> at junit.framework.TestSuite.run(Unknown Source)
> at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1496) Fail to set temporal parameter
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fay Wang updated OPENJPA-1496:
------------------------------
Attachment: OPENJPA-1460-3.patch
This patch assumes any temporal types (Date, Time, Timestamp) are assignable to each other. However, with this patch, two test cases fail: TestTemporalTypeQueryParameterBinding.testNamedParameterWithMismatchedValue
and
TestTemporalTypeQueryParameterBinding.testPositionalParameterWithMismatchedValue
These two test cases suggest strong type checking for the temporal types.
> Fail to set temporal parameter
> ------------------------------
>
> Key: OPENJPA-1496
> URL: https://issues.apache.org/jira/browse/OPENJPA-1496
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 2.1.0
>
> Attachments: OPENJPA-1496-2.patch, OPENJPA-1496.patch
>
>
> For an entity:
> @Entity
> public class TimeEntity {
> @Id
> @GeneratedValue
> private long id;
>
> String name;
>
> int value;
>
> @Temporal(TemporalType.TIMESTAMP)
> private java.util.Calendar cal2Timestamp;
> ...}
> an attempt to set parameter as below fails with IllegalArgumentException:
> String jpql = "SELECT COUNT(a) FROM TimeEntity a WHERE a.cal2Timestamp BETWEEN ?1 AND ?2";
> Calendar endTime = Calendar.getInstance();
> Calendar startTime = (Calendar)endTime.clone();
> startTime.add(14, -4);
> List results = em.createQuery(jpql).
> setParameter(1, startTime, TemporalType.TIMESTAMP).
> setParameter(2, endTime, TemporalType.TIMESTAMP).
> getResultList();
> java.lang.IllegalArgumentException: Parameter "Parameter<Calendar>(2)" declared in "SELECT COUNT(a) FROM TimeEntity a WHERE a.value = ?1 AND a.cal2Timestamp BETWEEN ?2 AND ?3" is set to value of "2/4/10 9:55 PM" of type "java.sql.Timestamp", but this parameter is bound to a field of type "java.util.Calendar".
> at org.apache.openjpa.persistence.QueryImpl.assertValueAssignable(QueryImpl.java:1079)
> at org.apache.openjpa.persistence.QueryImpl.bindValue(QueryImpl.java:1036)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:640)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:653)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:1)
> at d637638.Test637638.testTemporalType(Test637638.java:36)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at junit.framework.TestCase.runTest(Unknown Source)
> at junit.framework.TestCase.runBare(Unknown Source)
> at junit.framework.TestResult$1.protect(Unknown Source)
> at junit.framework.TestResult.runProtected(Unknown Source)
> at junit.framework.TestResult.run(Unknown Source)
> at junit.framework.TestCase.run(Unknown Source)
> at junit.framework.TestSuite.runTest(Unknown Source)
> at junit.framework.TestSuite.run(Unknown Source)
> at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (OPENJPA-1496) Fail to set temporal parameter
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fay Wang resolved OPENJPA-1496.
-------------------------------
Resolution: Fixed
> Fail to set temporal parameter
> ------------------------------
>
> Key: OPENJPA-1496
> URL: https://issues.apache.org/jira/browse/OPENJPA-1496
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 2.1.0
>
> Attachments: OPENJPA-1496-2.patch, OPENJPA-1496-3.patch, OPENJPA-1496.patch
>
>
> For an entity:
> @Entity
> public class TimeEntity {
> @Id
> @GeneratedValue
> private long id;
>
> String name;
>
> int value;
>
> @Temporal(TemporalType.TIMESTAMP)
> private java.util.Calendar cal2Timestamp;
> ...}
> an attempt to set parameter as below fails with IllegalArgumentException:
> String jpql = "SELECT COUNT(a) FROM TimeEntity a WHERE a.cal2Timestamp BETWEEN ?1 AND ?2";
> Calendar endTime = Calendar.getInstance();
> Calendar startTime = (Calendar)endTime.clone();
> startTime.add(14, -4);
> List results = em.createQuery(jpql).
> setParameter(1, startTime, TemporalType.TIMESTAMP).
> setParameter(2, endTime, TemporalType.TIMESTAMP).
> getResultList();
> java.lang.IllegalArgumentException: Parameter "Parameter<Calendar>(2)" declared in "SELECT COUNT(a) FROM TimeEntity a WHERE a.value = ?1 AND a.cal2Timestamp BETWEEN ?2 AND ?3" is set to value of "2/4/10 9:55 PM" of type "java.sql.Timestamp", but this parameter is bound to a field of type "java.util.Calendar".
> at org.apache.openjpa.persistence.QueryImpl.assertValueAssignable(QueryImpl.java:1079)
> at org.apache.openjpa.persistence.QueryImpl.bindValue(QueryImpl.java:1036)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:640)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:653)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:1)
> at d637638.Test637638.testTemporalType(Test637638.java:36)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at junit.framework.TestCase.runTest(Unknown Source)
> at junit.framework.TestCase.runBare(Unknown Source)
> at junit.framework.TestResult$1.protect(Unknown Source)
> at junit.framework.TestResult.runProtected(Unknown Source)
> at junit.framework.TestResult.run(Unknown Source)
> at junit.framework.TestCase.run(Unknown Source)
> at junit.framework.TestSuite.runTest(Unknown Source)
> at junit.framework.TestSuite.run(Unknown Source)
> at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1496) Fail to set temporal parameter
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fay Wang updated OPENJPA-1496:
------------------------------
Attachment: OPENJPA-1496-2.patch
A different approach to solve this problem.
> Fail to set temporal parameter
> ------------------------------
>
> Key: OPENJPA-1496
> URL: https://issues.apache.org/jira/browse/OPENJPA-1496
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 2.1.0
>
> Attachments: OPENJPA-1496-2.patch, OPENJPA-1496.patch
>
>
> For an entity:
> @Entity
> public class TimeEntity {
> @Id
> @GeneratedValue
> private long id;
>
> String name;
>
> int value;
>
> @Temporal(TemporalType.TIMESTAMP)
> private java.util.Calendar cal2Timestamp;
> ...}
> an attempt to set parameter as below fails with IllegalArgumentException:
> String jpql = "SELECT COUNT(a) FROM TimeEntity a WHERE a.cal2Timestamp BETWEEN ?1 AND ?2";
> Calendar endTime = Calendar.getInstance();
> Calendar startTime = (Calendar)endTime.clone();
> startTime.add(14, -4);
> List results = em.createQuery(jpql).
> setParameter(1, startTime, TemporalType.TIMESTAMP).
> setParameter(2, endTime, TemporalType.TIMESTAMP).
> getResultList();
> java.lang.IllegalArgumentException: Parameter "Parameter<Calendar>(2)" declared in "SELECT COUNT(a) FROM TimeEntity a WHERE a.value = ?1 AND a.cal2Timestamp BETWEEN ?2 AND ?3" is set to value of "2/4/10 9:55 PM" of type "java.sql.Timestamp", but this parameter is bound to a field of type "java.util.Calendar".
> at org.apache.openjpa.persistence.QueryImpl.assertValueAssignable(QueryImpl.java:1079)
> at org.apache.openjpa.persistence.QueryImpl.bindValue(QueryImpl.java:1036)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:640)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:653)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:1)
> at d637638.Test637638.testTemporalType(Test637638.java:36)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at junit.framework.TestCase.runTest(Unknown Source)
> at junit.framework.TestCase.runBare(Unknown Source)
> at junit.framework.TestResult$1.protect(Unknown Source)
> at junit.framework.TestResult.runProtected(Unknown Source)
> at junit.framework.TestResult.run(Unknown Source)
> at junit.framework.TestCase.run(Unknown Source)
> at junit.framework.TestSuite.runTest(Unknown Source)
> at junit.framework.TestSuite.run(Unknown Source)
> at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1496) Fail to set temporal parameter
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fay Wang updated OPENJPA-1496:
------------------------------
Attachment: OPENJPA-1496.patch
> Fail to set temporal parameter
> ------------------------------
>
> Key: OPENJPA-1496
> URL: https://issues.apache.org/jira/browse/OPENJPA-1496
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 2.1.0
>
> Attachments: OPENJPA-1496.patch
>
>
> For an entity:
> @Entity
> public class TimeEntity {
> @Id
> @GeneratedValue
> private long id;
>
> String name;
>
> int value;
>
> @Temporal(TemporalType.TIMESTAMP)
> private java.util.Calendar cal2Timestamp;
> ...}
> an attempt to set parameter as below fails with IllegalArgumentException:
> String jpql = "SELECT COUNT(a) FROM TimeEntity a WHERE a.cal2Timestamp BETWEEN ?1 AND ?2";
> Calendar endTime = Calendar.getInstance();
> Calendar startTime = (Calendar)endTime.clone();
> startTime.add(14, -4);
> List results = em.createQuery(jpql).
> setParameter(1, startTime, TemporalType.TIMESTAMP).
> setParameter(2, endTime, TemporalType.TIMESTAMP).
> getResultList();
> java.lang.IllegalArgumentException: Parameter "Parameter<Calendar>(2)" declared in "SELECT COUNT(a) FROM TimeEntity a WHERE a.value = ?1 AND a.cal2Timestamp BETWEEN ?2 AND ?3" is set to value of "2/4/10 9:55 PM" of type "java.sql.Timestamp", but this parameter is bound to a field of type "java.util.Calendar".
> at org.apache.openjpa.persistence.QueryImpl.assertValueAssignable(QueryImpl.java:1079)
> at org.apache.openjpa.persistence.QueryImpl.bindValue(QueryImpl.java:1036)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:640)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:653)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:1)
> at d637638.Test637638.testTemporalType(Test637638.java:36)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at junit.framework.TestCase.runTest(Unknown Source)
> at junit.framework.TestCase.runBare(Unknown Source)
> at junit.framework.TestResult$1.protect(Unknown Source)
> at junit.framework.TestResult.runProtected(Unknown Source)
> at junit.framework.TestResult.run(Unknown Source)
> at junit.framework.TestCase.run(Unknown Source)
> at junit.framework.TestSuite.runTest(Unknown Source)
> at junit.framework.TestSuite.run(Unknown Source)
> at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OPENJPA-1496) Fail to set temporal parameter
Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods updated OPENJPA-1496:
----------------------------------
Affects Version/s: (was: 2.0.0)
2.0.0-beta
Fix Version/s: (was: 2.0.0)
2.0.0-beta2
> Fail to set temporal parameter
> ------------------------------
>
> Key: OPENJPA-1496
> URL: https://issues.apache.org/jira/browse/OPENJPA-1496
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0-beta
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 2.0.0-beta2
>
> Attachments: OPENJPA-1496-2.patch, OPENJPA-1496-3.patch, OPENJPA-1496.patch
>
>
> For an entity:
> @Entity
> public class TimeEntity {
> @Id
> @GeneratedValue
> private long id;
>
> String name;
>
> int value;
>
> @Temporal(TemporalType.TIMESTAMP)
> private java.util.Calendar cal2Timestamp;
> ...}
> an attempt to set parameter as below fails with IllegalArgumentException:
> String jpql = "SELECT COUNT(a) FROM TimeEntity a WHERE a.cal2Timestamp BETWEEN ?1 AND ?2";
> Calendar endTime = Calendar.getInstance();
> Calendar startTime = (Calendar)endTime.clone();
> startTime.add(14, -4);
> List results = em.createQuery(jpql).
> setParameter(1, startTime, TemporalType.TIMESTAMP).
> setParameter(2, endTime, TemporalType.TIMESTAMP).
> getResultList();
> java.lang.IllegalArgumentException: Parameter "Parameter<Calendar>(2)" declared in "SELECT COUNT(a) FROM TimeEntity a WHERE a.value = ?1 AND a.cal2Timestamp BETWEEN ?2 AND ?3" is set to value of "2/4/10 9:55 PM" of type "java.sql.Timestamp", but this parameter is bound to a field of type "java.util.Calendar".
> at org.apache.openjpa.persistence.QueryImpl.assertValueAssignable(QueryImpl.java:1079)
> at org.apache.openjpa.persistence.QueryImpl.bindValue(QueryImpl.java:1036)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:640)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:653)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:1)
> at d637638.Test637638.testTemporalType(Test637638.java:36)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at junit.framework.TestCase.runTest(Unknown Source)
> at junit.framework.TestCase.runBare(Unknown Source)
> at junit.framework.TestResult$1.protect(Unknown Source)
> at junit.framework.TestResult.runProtected(Unknown Source)
> at junit.framework.TestResult.run(Unknown Source)
> at junit.framework.TestCase.run(Unknown Source)
> at junit.framework.TestSuite.runTest(Unknown Source)
> at junit.framework.TestSuite.run(Unknown Source)
> at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OPENJPA-1496) Fail to set temporal parameter
Posted by "Fay Wang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12830466#action_12830466 ]
Fay Wang commented on OPENJPA-1496:
-----------------------------------
Current parameter processing is based on the assumption that each parameter is associated with one and only one class type. However, this is not true in the case of temporal data. Consider the following scenarios:
@Entity
public class TimeEntity {
@Id
@GeneratedValue
private long id;
String name;
int value;
@Temporal(TemporalType.TIMESTAMP)
private java.util.Calendar cal2Timestamp;
...}
String jpql = "SELECT COUNT(a) FROM A a WHERE a.cal2Timestamp BETWEEN ?1 AND ?2";
Query q = em.createQuery(jpql);
Calendar endTime = Calendar.getInstance();
Calendar startTime = (Calendar)endTime.clone();
startTime.add(14, -4);
(1)
q.setParameter(1, startTime, TemporalType.TIMESTAMP);
q.setParameter(2, endTime, TemporalType.TIMESTAMP);
(2)
q.setParameter(1, startTime);
q.setParameter(2, endTime);
In case (1), the parameterType of the two parameters should be Timestamp, which is based on the @Temporal annotation of the Calendar field, cal2Timestamp.
In Case (2), the parameter type of the two parameters should be Calendar.
In order to support both cases, the attached patch stores both types in the ordered parameter map, and uses the type depending on which setParameter method is called.
> Fail to set temporal parameter
> ------------------------------
>
> Key: OPENJPA-1496
> URL: https://issues.apache.org/jira/browse/OPENJPA-1496
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Reporter: Fay Wang
> Assignee: Fay Wang
> Fix For: 2.1.0
>
>
> For an entity:
> @Entity
> public class TimeEntity {
> @Id
> @GeneratedValue
> private long id;
>
> String name;
>
> int value;
>
> @Temporal(TemporalType.TIMESTAMP)
> private java.util.Calendar cal2Timestamp;
> ...}
> an attempt to set parameter as below fails with IllegalArgumentException:
> String jpql = "SELECT COUNT(a) FROM TimeEntity a WHERE a.cal2Timestamp BETWEEN ?1 AND ?2";
> Calendar endTime = Calendar.getInstance();
> Calendar startTime = (Calendar)endTime.clone();
> startTime.add(14, -4);
> List results = em.createQuery(jpql).
> setParameter(1, startTime, TemporalType.TIMESTAMP).
> setParameter(2, endTime, TemporalType.TIMESTAMP).
> getResultList();
> java.lang.IllegalArgumentException: Parameter "Parameter<Calendar>(2)" declared in "SELECT COUNT(a) FROM TimeEntity a WHERE a.value = ?1 AND a.cal2Timestamp BETWEEN ?2 AND ?3" is set to value of "2/4/10 9:55 PM" of type "java.sql.Timestamp", but this parameter is bound to a field of type "java.util.Calendar".
> at org.apache.openjpa.persistence.QueryImpl.assertValueAssignable(QueryImpl.java:1079)
> at org.apache.openjpa.persistence.QueryImpl.bindValue(QueryImpl.java:1036)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:640)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:653)
> at org.apache.openjpa.persistence.QueryImpl.setParameter(QueryImpl.java:1)
> at d637638.Test637638.testTemporalType(Test637638.java:36)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at junit.framework.TestCase.runTest(Unknown Source)
> at junit.framework.TestCase.runBare(Unknown Source)
> at junit.framework.TestResult$1.protect(Unknown Source)
> at junit.framework.TestResult.runProtected(Unknown Source)
> at junit.framework.TestResult.run(Unknown Source)
> at junit.framework.TestCase.run(Unknown Source)
> at junit.framework.TestSuite.runTest(Unknown Source)
> at junit.framework.TestSuite.run(Unknown Source)
> at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.