[jira] Commented: (CAY-1003) the paged queries in ROP can fail to fetch the subsequent pages if the client and server are in different timezones

["Andrus Adamchik (JIRA)" <de...@cayenne.apache.org>]

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

Andrus Adamchik commented on CAY-1003:
--------------------------------------

Marcin, from looking at the code, both cache keys are generated on the client and passed around as Strings, so I don't think this is the case... I guess I can stage  such test by resetting time zone on a LAN server, but so far I don't see why such a  problem would occur.

> the paged queries in ROP can fail to fetch the subsequent pages if the client and server are in different timezones
> -------------------------------------------------------------------------------------------------------------------
>
>                 Key: CAY-1003
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1003
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Cayenne Core Library
>    Affects Versions: 3.0
>         Environment: ROP, paging, LOCAL_CACHE with no setCacheGroups specified , cayenne v.3.0-SNAPSHOT Mar 05 2008 22:29:23, multiple timezones
>            Reporter: Marcin Skladaniec
>            Assignee: Andrus Adamchik
>
> if the client and server are in different timezone and the executed query has an qualifier like this:
> ExpressionFactory.greaterOrEqualExp(CourseClass.ENDDATETIME_PROPERTY, new Date())
> there is a possibility of a mismatch between the keys identifying the cache. 
> What happens I believe is that the initial SelectQuery creates the key on server, using the server timezone, while the query which faults the following page of data creates the key on client. My assumptions are based on the exception we see when we are trying to connect across timezones (we are in EST, server is in WST):
> org.apache.cayenne.CayenneRuntimeException: [v.3.0-SNAPSHOT Mar 05 2008 22:29:23] Remote error. URL - http://ahost:8181/angel-server-cayenne; CAUSE - [v.3.0-SNAPSHOT Mar 05 2008 22:29:23] No cached list for CourseClass/((endDateTime >= Fri Mar 07 12:45:17 EST 2008) or (endDateTime = null)) and (isCancelled != true)/course.name
>    at org.apache.cayenne.access.ClientServerChannelQueryAction.interceptSinglePageQuery(ClientServerChannelQueryAction.java:99)
>         at org.apache.cayenne.access.ClientServerChannelQueryAction.execute(ClientServerChannelQueryAction.java:65)
>         at org.apache.cayenne.access.ClientServerChannel.onQuery(ClientServerChannel.java:82)
>         at org.apache.cayenne.remote.service.DispatchHelper.dispatch(DispatchHelper.java:40)
>         at org.apache.cayenne.remote.service.BaseRemoteService.processMessage(BaseRemoteService.java:153)
>         at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

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