[ 
https://issues.apache.org/cayenne/browse/CAY-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12946#action_12946
 ] 

Andrus Adamchik commented on CAY-1072:
--------------------------------------

Yes, converting dates to Strings are a no-go. I don't see us being able to fix 
that on the short run. Could you try a parameterized expression instead (using 
$param instead of date literals).

> org.apache.cayenne.query.SQLResultSetMapping must implement 
> java.io.Serializable
> --------------------------------------------------------------------------------
>
>                 Key: CAY-1072
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1072
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Cayenne JPA
>    Affects Versions: 3.0
>         Environment: ROP
>            Reporter: Lachlan Deck
>            Assignee: Andrus Adamchik
>
> so I've got this...
> public int allRecordsCount(Expression e) {
>       ObjEntity entity = 
> getContext().getEntityResolver().lookupObjEntity(getObjectClass());
>       Expression qualifier = null;
>       <...>
>       String ejbqlWhereString = qualifier == null ? "" : " WHERE " + 
> qualifier.toEJBQL("a");
>       String ejbqlQueryString = "SELECT count(a) FROM " + entity.getName() + 
> " a" + ejbqlWhereString;
>       EJBQLQuery ejbqlQuery = new EJBQLQuery(ejbqlQueryString);
>       Number count = (Number) DataObjectUtils.objectForQuery(getContext(), 
> ejbqlQuery);
>       return count.intValue();
> }
> But I'm getting this exception. Any ideas?
> org.apache.cayenne.CayenneRuntimeException: [v.3.0-SNAPSHOT May 14 2008 
> 22:35:23] Remote error. URL - 
> http://delish.ish.com.au:8181/angel-server-cayenne; CAUSE - Serialized class 
> org.apache.cayenne.query.SQLResultSetMapping must implement 
> java.io.Serializable
>    [java]     at 
> org.apache.cayenne.remote.hessian.HessianConnection.doSendMessage(HessianConnection.java:147)
>    [java]     at 
> org.apache.cayenne.remote.BaseConnection.sendMessage(BaseConnection.java:73)
>    [java]     at 
> org.apache.cayenne.remote.ClientChannel.send(ClientChannel.java:281)
>    [java]     at 
> org.apache.cayenne.remote.ClientChannel.onQuery(ClientChannel.java:113)
>    [java]     at 
> org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQueryAction.java:317)
>    [java]     at 
> org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:96)
>    [java]     at 
> org.apache.cayenne.CayenneContext.onQuery(CayenneContext.java:340)
>    [java]     at 
> org.apache.cayenne.CayenneContext.performQuery(CayenneContext.java:328)
>    [java]     at 
> ish.oncourse.cayenne.CayenneContext.performQuery(CayenneContext.java:292)
>    [java]     at 
> org.apache.cayenne.DataObjectUtils.objectForQuery(DataObjectUtils.java:274)
>    [java]     at 
> ish.oncourse.controller.ListController.allRecordsCount(ListController.java:482)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to