Re: com.datastax.driver.core.exceptions.SyntaxError: line 1:37 no viable alternative at character

[Serega Sheypak]

Sorry, misprint
//composeQuery() => INSERT INTO packets (id, fingerprint, mark) VALUES (?,
?, ?);
PreparedStatement preparedStatement = session.prepare(composeQuery());
//exception happens here!

2015-06-24 11:20 GMT+02:00 Serega Sheypak <serega.shey...@gmail.com>:

> Hi, I'm trying to use bounded query and I get  weird error:
>
> Here is a query:
>
> Bounded query: INSERT INTO packets (id, fingerprint, mark) VALUES (?, ?,
> ?);
>
>
> Here is a code:
>
> PreparedStatement preparedStatement = session.prepare(composeQuery());
> //composeQuery returns INSERT INTO packets (id, fingerprint, mark) VALUES
> (?, ?, ?);
>
> BoundStatement boundStatement = new BoundStatement(preparedStatement);
> //EXCEPTION HERE
>
> boundStatement.bind(UUID.randomUUID(), RandomStringUtils.random(10), 1);
>
> session.execute(boundStatement);
> If I use cqlsh and run
>
> INSERT INTO packets (id, fingerprint, mark) VALUES (now(), 'xxx', 1);
> it works
>
> Stacktrace:
>
> Exception in thread "main"
> com.datastax.driver.core.exceptions.SyntaxError: line 1:37 no viable
> alternative at character ' '
>
> at
> com.datastax.driver.core.exceptions.SyntaxError.copy(SyntaxError.java:35)
>
> at
> com.datastax.driver.core.DefaultResultSetFuture.extractCauseFromExecutionException(DefaultResultSetFuture.java:289)
>
> at
> com.datastax.driver.core.AbstractSession.prepare(AbstractSession.java:79)
>
> at stress.StressTest.runBound(StressTest.java:89)
>
> at stress.Main.main(Main.java:29)
>
> Caused by: com.datastax.driver.core.exceptions.SyntaxError: line 1:37 no
> viable alternative at character ' '
>
> at com.datastax.driver.core.Responses$Error.asException(Responses.java:101)
>
> at com.datastax.driver.core.SessionManager$1.apply(SessionManager.java:185)
>
> at com.datastax.driver.core.SessionManager$1.apply(SessionManager.java:160)
>
> at com.google.common.util.concurrent.Futures$1.apply(Futures.java:720)
>
> at
> com.google.common.util.concurrent.Futures$ChainingListenableFuture.run(Futures.java:859)
>
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>
>  at java.lang.Thread.run(Thread.java:745)
>
>
>