about replication of SQLquery template

I make a custom cluster configure file which will replicate template spaces.
the template is following:
spaces.core.client.SQLQuery<ClientAData>(new ClientAData(),"id < 10 ")
One space will recive the template correctly
Another space will receive something like this
spaces.core.client.SQLQuery<ClientAData>(new ClientAData(),"id = 10 ")
(It is known by the returned result)

Is this a bug or SQLquery does not support "Replicate Notify Template"

This thread was imported from the previous forum.
For your reference, the original is available here

asked 2009-02-23 21:18:46 -0600

cwtsui
1 ●1 ●2 ●6

updated 2013-08-08 09:52:00 -0600

jaissefsfex
1 ●1

edit retag flag offensive close merge delete

add a comment

It is not clear what is the problem you are facing.

Do you mean you don't see a notify template constructed via:
spaces.core.client.SQLQuery<ClientAData>(new ClientAData(),"id = 10 ")
replicated to another partition?

Would a regular template (none SQL based) is replicated?

Shay

answered 2009-02-26 13:50:11 -0600

shay hassidim

17548 ●9 ●13 ●17

edit flag offensive delete link

Comments

I have an Object (call Data) with just one Integer member - id. id is SpaceRoute.

Now, I have a data grid using 2 partitioned spaces. the first space will contain object with even hash the second space will contain object with odd hash

If I notify new Data(), both space got the template

if I notify new SQLQuery<data>(new Data(),"id < 10"), first space got the template. if I notify new SQLQuery<data>(new Data(),"id < 9"), second space got the template.

if I notify new SQLQuery<data>(new Data(),"id < 9 and id < 10"), second space got the template. if I notify new SQLQuery<data>(new Data(),"id < 10 and id < 9"), second space got the template.

if I notify new SQLQuery<data>(new Data(),"id < 11 and id < 10"), first space got the template. if I notify new SQLQuery<data>(new Data(),"id < 10 and id < 11"), first space got the template.

Is this a bug in SQLQuery ??

Edited by: Tsui Chi wing on Feb 26, 2009 9:35 PM

cwtsui ( 2009-02-26 21:35:27 -0600 )edit

id < 9 and id < 10 means id < 9

Why you need such a query?

Maybe what you means is this: id > 8 and id < 10

Note the notify template does have some limitations when using SQLQuery. See: http://www.gigaspaces.com/wiki/displa...

Shay

shay hassidim ( 2009-02-27 15:20:03 -0600 )edit

Maybe we should focus on the question "Why I notify new SQLQuery<data>(new Data(),"id < 10"), only first space got the template".

cwtsui ( 2009-03-01 20:18:04 -0600 )edit

You should see the notify template at each partition. Can you check the gs-ui , space-browser , classes view and see how many templates each partition has?

Shay

shay hassidim ( 2009-03-01 21:43:30 -0600 )edit

According to the reply dated Feb 26, 2009 9:35 PM,

if I notify new SQLQuery<data>(new Data(),"id < 10"), only first space got the template. That means only one template present. if I notify new SQLQuery<data>(new Data(),"id < 9"), only second space got the template. That means only one template present.

This result is given by the output form gs-ui , space-browser , classes view.

cwtsui ( 2009-03-02 02:20:08 -0600 )edit

add a comment

about replication of SQLquery template

1 Answer

Comments

Your Answer

Question Tools

Stats

Related questions

about replication of SQLquery template edit

1 Answer

Comments

Your Answer

Question Tools

Stats

Related questions

about replication of SQLquery template