openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fay Wang (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-1496) Fail to set temporal parameter
Date Fri, 05 Feb 2010 06:02:27 GMT
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.


Mime
View raw message