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

Ask Your Question
0

SQLQuery not returning results with 'IN' and 'AND clauses

I have the following query

select * from com.metavante.ceb.session.gigaspaces.data.GSSessionDataObject where type IN ( 'PFWENTITLEMENTRECORD' , 'TESTMULTIPLE' ) and userKey='alomhmeagoqqvjqm1313182624096B1PK1545'

where type and userkey are String. The above query is not returning any results when ran from GUI, but if I split the query i am getting the same results..

  1. select * from com.metavante.ceb.session.gigaspaces.data.GSSessionDataObject where type IN ( 'PFWENTITLEMENTRECORD' , 'TESTMULTIPLE' )

  2. select * from com.metavante.ceb.session.gigaspaces.data.GSSessionDataObject where type IN ( 'PFWENTITLEMENTRECORD' , 'TESTMULTIPLE' ) and userKey='alomhmeagoqqvjqm1313182624096B1PK1545'

I have compared the data for both the records and it is the same..

I am really really new to GS, so any help on this is highly appreciated..

{quote}This thread was imported from the previous forum. For your reference, the original is [available here|http://forum.openspaces.org/thread.jspa?threadID=3734]{quote}

asked 2011-08-12 17:29:50 -0500

shyamnair 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

Shyam,
Would the following return correct result:
select * from com.metavante.ceb.session.gigaspaces.data.GSSessionDataObject where userKey='alomhmeagoqqvjqm1313182624096B1PK1545'

select * from com.metavante.ceb.session.gigaspaces.data.GSSessionDataObject where type='PFWENTITLEMENTRECORD' and userKey='alomhmeagoqqvjqm1313182624096B1PK1545'

It might be that a type is a reserved word.

You should check this with the support team.

Shay

answered 2011-08-14 10:41:09 -0500

shay hassidim gravatar image
edit flag offensive delete link more

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: 2011-08-12 17:29:50 -0500

Seen: 40 times

Last updated: Aug 14 '11