Hi Stéphane, The parametrized queries are supported by the thin JDBC driver.
Could you please share a code snippet that illustrates table 'device' creation and JDBC driver using? Please provide the log from the server node. It should contain additional details about the issue. Thanks, Slava. 2018-02-15 11:58 GMT+03:00 Stéphane Thibaud <[email protected]>: > Hello! I am trying to convert our Play Framework application to use Apache > Ignite. I encountered a failure to parse an existing query, but I do not > see what is so special about this query: > > java.sql.SQLException: Failed to parse query: insert into device(id, > secret, updated_at, created_at) > values (?, ?, ?, ?) > > at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection. > sendRequest(JdbcThinConnection.java:671) ~[ignite-core-2.3.0.jar:2.3.0] > at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement. > execute0(JdbcThinStatement.java:130) ~[ignite-core-2.3.0.jar:2.3.0] > at org.apache.ignite.internal.jdbc.thin.JdbcThinPreparedStatement. > executeWithArguments(JdbcThinPreparedStatement.java:252) > ~[ignite-core-2.3.0.jar:2.3.0] > at org.apache.ignite.internal.jdbc.thin.JdbcThinPreparedStatement. > execute(JdbcThinPreparedStatement.java:240) ~[ignite-core-2.3.0.jar:2.3.0] > at com.zaxxer.hikari.proxy.PreparedStatementProxy.execute( > PreparedStatementProxy.java:44) ~[HikariCP-2.3.7.jar:na] > at com.zaxxer.hikari.proxy.PreparedStatementJavassistProx > y.execute(PreparedStatementJavassistProxy.java) ~[HikariCP-2.3.7.jar:na] > at anorm.Sql$$anonfun$execute$1.apply(Anorm.scala:235) > ~[anorm_2.11-2.4.0.jar:2.4.0] > at anorm.Sql$$anonfun$execute$1.apply(Anorm.scala:235) > ~[anorm_2.11-2.4.0.jar:2.4.0] > at resource.AbstractManagedResource$$anonfun$5.apply( > AbstractManagedResource.scala:86) ~[scala-arm_2.11-1.4.jar:1.4] > at > scala.util.control.Exception$Catch$$anonfun$either$1.apply(Exception.scala:125) > ~[scala-library-2.11.8.jar:na] > at > scala.util.control.Exception$Catch$$anonfun$either$1.apply(Exception.scala:125) > ~[scala-library-2.11.8.jar:na] > at scala.util.control.Exception$Catch.apply(Exception.scala:103) > ~[scala-library-2.11.8.jar:na] > at scala.util.control.Exception$Catch.either(Exception.scala:125) > ~[scala-library-2.11.8.jar:na] > at resource.AbstractManagedResource.acquireFor( > AbstractManagedResource.scala:86) ~[scala-arm_2.11-1.4.jar:1.4] > at resource.ManagedResourceOperations$class.acquireAndGet( > ManagedResourceOperations.scala:25) ~[scala-arm_2.11-1.4.jar:1.4] > at resource.AbstractManagedResource.acquireAndGet( > AbstractManagedResource.scala:48) ~[scala-arm_2.11-1.4.jar:1.4] > at anorm.Sql$class.execute(Anorm.scala:235) > ~[anorm_2.11-2.4.0.jar:2.4.0] > at anorm.SimpleSql.execute(SimpleSql.scala:6) > ~[anorm_2.11-2.4.0.jar:2.4.0] > > Do you have an idea of the issue I might be facing? Are parametrized > queries supported by the JDBC driver, for example? > > > Best regards, > > Stéphane
