incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Lebresne <sylv...@datastax.com>
Subject Re: bind prepared statement for "IN" select statements
Date Tue, 09 Jul 2013 15:36:16 GMT
What you are trying to do is not currently supported:
https://issues.apache.org/jira/browse/CASSANDRA-4210.

That being said, you get that exact error because what you pass to bind()
is an array, but bind() is a variadic method, so this
is equivalent to writing:
  ResultSet results = execute(getUserInList.bind(“abc”, “def”, “ghi”));
which calls bind with 3 arguments, even though your prepared statement has
only one prepared variable.

So in theory you'd want to do
  ResultSet results = execute(getUserInList.bind(Arrays.asList(“abc”,
“def”, “ghi”)));
but then again, this won't work either because, as said above, this is not
yet supported Cassandra side.

Just for the sake of completness, what you can actually do is:

PreparedStatement getUserInList = prepare(QueryBuilder.select(ADDRESS,
USER).from(USER_BY_ADDRESS_COLUMN_FAMILY)
            .where(QueryBuilder.in(ADDRESS, QueryBuilder.bindMarker(),
QueryBuilder.bindMarker(), QueryBuilder.bindMarker())));

i.e., have 3 bind markers, and then the remaining of your initial code
would work (but I understand this is probably not what you
want, just being complete).

--
Sylvain


On Tue, Jul 9, 2013 at 5:21 PM, Pruner, Anne (Anne) <pruner@avaya.com>wrote:

>  Has anyone tried binding a prepared statement for an “IN” query?****
>
> ** **
>
> For example, ****
>
> ** **
>
> protected PreparedStatement getUserInList =
> prepare(QueryBuilder.select(ADDRESS,
> USER).from(USER_BY_ADDRESS_COLUMN_FAMILY)****
>
>             .where(QueryBuilder.in(ADDRESS, QueryBuilder.bindMarker())));*
> ***
>
> ** **
>
> Object[] addressList = {“abc”, “def”, “ghi”};****
>
> ResultSet results = execute(getUserInList.bind(addressList));****
>
> ** **
>
> ** **
>
> This results in a java.lang.IllegalArgumentException: Prepared statement
> has only 1 variables, 3 values provided****
>
> ** **
>
> Any ideas?****
>
> Thanks,****
>
> Anne Pruner****
>
> ** **
>
> ** **
>
> ** **
>

Mime
View raw message