openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fengyi <liufengyi2006...@sina.com>
Subject about slice query with paging. the result have some wrong
Date Wed, 03 Jul 2013 05:34:03 GMT
hello everyone: 
    I very like openJPA slice . and  in our project, slice plays a import
role. 
but when i configured slice. and query with paging. the result have some
mistake. 
db is mysql-5.5。 i have two db ,configured for slice. when i query the
pageno gt 1 ,then the query result 
goes wrong . i think this because of slices excute the paging query
individually,and then,the program merge the each slice result. 
for example: 
my whole data is : 1,2,3,4,5,6,7,8,,9,10,11,12 
two slice. 
the first slice holds data 1,3,5,7,9,11  and the second slice holds data
2,4,6,8,10,12 
 pageSize is 2. 
page 1 result is 1,3  (1,3,2,4) 
page 2 result is 5,7 (5,7,6,8) 
page 3 result is 9,1 (9,11,10,12) 

some data missed. 

my team solution is use a delegate query when invoke the  query page
interface.  Cooperate with query Cache, the method can resolve our problem
temporarilly. 
any one have more advice? 



--
View this message in context: http://openjpa.208410.n2.nabble.com/about-slice-query-with-paging-the-result-have-some-wrong-tp7584326.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Mime
View raw message