"In" key word can not be used in jpql by using cassandra 1.1.5 ! #151

Closed
zhouhero opened this Issue Dec 14, 2012 · 13 comments

Comments

Projects
None yet
4 participants

When use "in" key word in jpql by using cassandra 1.1.5, the following error happend:

" Condition in is not suported for query on row key! "

but in cassandra CQL1.3 , "in" can be used.

Can anyone help me get it working ?

Collaborator

mevivs commented Dec 14, 2012

Try using it "nativeQuery" support with Kundera.

  1. Set cql version to 3
  2. Execute cql query as em.createNativeQuery or em.getNativeQuery() support.

-Vivek

Thank you for your answer! i will try it.
By the way, when using native query , can i set params in cql3 like jpql?
It seem that the parameter setting is not working now by using native cql in cassandra 1.1.5.

Collaborator

mevivs commented Dec 14, 2012

AFN setParameter is limited to JPQL/Named query only

-Vivek

i see,
but i want to using both setting parameter and "in" keyword in my program.
if you can make "in" keyword working in Kundera 2.3, you will help me very mutch!
Thanks!

Collaborator

mevivs commented Dec 14, 2012

Just to brief on this, Once we enable support for newly released cassandra jdbc driver(not sure how much stable that is), this will be in.

-Vivek

by the way, is kundera 2.2 using pelopes driver to connect to cassandera now?
in the new version(2.3), will it use cassandra jdbc driver directly?

Collaborator

mevivs commented Dec 14, 2012

It gives you both option:

  1. Pelops client
  2. Thrift client.

3rd will be jdbc driver support.

-Vivek

i see, i think it will be very good by using jdbc driver in kundera2.3.
when over 10,000 clients are online in my system, witch driver is best?

Collaborator

mevivs commented Dec 14, 2012

jdbc is relatively very new in comparision of thrift protocol and we are working on it. As of now most systems in production are using thrift based clients.

-Vivek

Thanks you for your support very much!
Looking forward to kundera 2.3 with jdbc driver ....

Collaborator

mevivs commented Jan 22, 2013

Parked for release > 2.4

"in" keyword is can used in JPQL by using kundera 2.4 + cassandra1.2?

Contributor

xamry commented Mar 11, 2013

Not yet,

For detailed listing of keywords supported in JPQL, please see:
https://github.com/impetus-opensource/Kundera/wiki/JPQL

Please let us know if we have missed something.

Sincerely,
Amresh

On Mon, Mar 11, 2013 at 7:19 AM, zhouhero notifications@github.com wrote:

"in" keyword is can used in JPQL by using kundera 2.4 + cassandra1.2?


Reply to this email directly or view it on GitHubhttps://github.com/impetus-opensource/Kundera/issues/151#issuecomment-14694329
.

@mevivs mevivs modified the milestone: 2.11 release Feb 5, 2014

chhavigangwal was assigned by mevivs Feb 5, 2014

mevivs closed this Mar 28, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment