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/09 19:41:28 UTC
[jira] Resolved: (OPENJPA-1496) Fail to set temporal parameter
[ 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.