Welcome to the new Gigaspaces XAP forum. To recover your account, please follow these instructions.

Ask Your Question
0

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 -0500

cwtsui gravatar image

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

jaissefsfex gravatar image
edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

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 -0500

shay hassidim gravatar image
edit flag offensive delete link more

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 gravatar imagecwtsui ( 2009-02-26 21:35:27 -0500 )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 gravatar imageshay hassidim ( 2009-02-27 15:20:03 -0500 )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 gravatar imagecwtsui ( 2009-03-01 20:18:04 -0500 )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 gravatar imageshay hassidim ( 2009-03-01 21:43:30 -0500 )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 gravatar imagecwtsui ( 2009-03-02 02:20:08 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2009-02-23 21:18:46 -0500

Seen: 40 times

Last updated: Feb 26 '09