Cassandra select query with Bind Variables in java8

Question

I am trying to execute a Cassandra query in Java8. My query is SELECT * FROM customer where aor='north' and I execute it with session.execute(query) and got correct answer. But then I changed my query to SELECT * FROM customer where aor=?

PreparedStatement statement =  session.prepare(query);
BoundStatement boundStatement = statement.bind("'north'");
ResultSet results = session.execute(boundStatement);
for (Row row : results) {
            System.out.println(row.toString());
        }

This is not working. No errors showing but I am not getting any result.

Can someone please help

You should probably change `statement.bind("'north'");` -> `statement.bind("north");` — ByeBye, Jan 27 '21 at 14:55

score 0 · Accepted Answer · answered Jan 28 '21 at 08:28

0

When you are using statement.bind("'north'"); it means that you want literally find 'north'.

Just change your string to north and it will work as you wanted

answered Jan 28 '21 at 08:28

ByeBye

6,650
5
30
63

Cassandra select query with Bind Variables in java8

1 Answers1