Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0-beta
    • Fix Version/s: 2.0.0-beta2
    • Component/s: jdbc
    • Labels:
      None

      Description

      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)

      1. OPENJPA-1496-3.patch
        10 kB
        Fay Wang
      2. OPENJPA-1496-2.patch
        30 kB
        Fay Wang
      3. OPENJPA-1496.patch
        38 kB
        Fay Wang

        Activity

        Fay Wang created issue -
        Fay Wang made changes -
        Field Original Value New Value
        Attachment OPENJPA-1496.patch [ 12435061 ]
        Fay Wang made changes -
        Attachment OPENJPA-1496-2.patch [ 12435217 ]
        Fay Wang made changes -
        Attachment OPENJPA-1460-3.patch [ 12435262 ]
        Fay Wang made changes -
        Attachment OPENJPA-1460-3.patch [ 12435262 ]
        Fay Wang made changes -
        Attachment OPENJPA-1496-3.patch [ 12435263 ]
        Fay Wang made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Fay Wang made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Michael Dick made changes -
        Affects Version/s 2.0.0 [ 12314019 ]
        Fix Version/s 2.0.0 [ 12314019 ]
        Fix Version/s 2.1.0 [ 12314542 ]
        Donald Woods made changes -
        Fix Version/s 2.0.0-beta2 [ 12314802 ]
        Fix Version/s 2.0.0 [ 12314019 ]
        Affects Version/s 2.0.0-beta [ 12314149 ]
        Affects Version/s 2.0.0 [ 12314019 ]

          People

          • Assignee:
            Fay Wang
            Reporter:
            Fay Wang
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development