EJBQLQuery with date parameter

From: Steve Wells (websystem..mail.com)
Date: Mon Aug 25 2008 - 00:26:26 EDT

  • Next message: Mike Kienenberger: "Re: Current thread has no bound DataContext (zk integration)"

    Just started trying the EJBQLQuery and ran into trouble with date type
    parameters using C3M4, hsql

    EJBQLQuery query = new EJBQLQuery("select count(e),
    e.toDocType.marketplaceDocType from EmcTransaction e where " +
      "e.toReceivedPayload.dateReceived > :fromDate GROUP BY
    e.toDocType.marketplaceDocType");
      query.setParameter("fromDate", fromDate);

    results in:

    SELECT COUNT(*) AS sc0, t1.marketplace_doc_type AS sc1 FROM emc_transaction
    t0 INNER JOIN doc_type t1 ON (t0.doc_type_id = t1.id) INNER JOIN
    received_payload t2 ON (t0.received_payload = t2.id) INNER JOIN sent_payload
    t3 ON (t0.sent_payload = t3.id) WHERE t2.date_received > ? GROUP BY
    t1.marketplace_doc_type [bind: 1:'2008-08-25 00:00:00.892']
    13:32:07,922 94999 INFO
    (org.apache.cayenne.access.QueryLogger.logQueryError(QueryLogger.java:454))
    - *** error.
    java.lang.IllegalArgumentException: Only DATE, TIME or TIMESTAMP can be
    mapped as 'java.util.Date', got VARBINARY
     at
    org.apache.cayenne.access.types.UtilDateType.convertToJdbcObject(UtilDateType.java:74)
     at
    org.apache.cayenne.access.types.UtilDateType.setJdbcObject(UtilDateType.java:159)
     at org.apache.cayenne.dba.JdbcAdapter.bindParameter(JdbcAdapter.java:481)
     at
    org.apache.cayenne.access.jdbc.SQLTemplateAction.bind(SQLTemplateAction.java:321)
     at
    org.apache.cayenne.access.jdbc.SQLTemplateAction.execute(SQLTemplateAction.java:150)
     at
    org.apache.cayenne.access.jdbc.SQLTemplateAction.performAction(SQLTemplateAction.java:127)
     at
    org.apache.cayenne.access.jdbc.EJBQLAction.performAction(EJBQLAction.java:100)
     at
    org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:58)
     at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:230)
     at
    org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:424)
     at
    org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:68)
     at
    org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQueryAction.java:397)
     at
    org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:847)
     at
    org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:394)
     at
    org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:120)
     at org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:740)
     at
    org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQueryAction.java:317)
     at
    org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:96)
     at org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1336)
     at
    org.apache.cayenne.access.DataContext.performQuery(DataContext.java:1325)

    The field date_received is definatly TIMESTAMP type 93.

    Any help appreciated. Am I better for a while sticking with SQLTemplate?

    Thanks,

    Steve

    This archive was generated by hypermail 2.0.0 : Mon Aug 25 2008 - 00:27:06 EDT