It seems the type of your id field is integer, but parameter type is string. Can you check it?
Please also see if this helps - https://groups.google.com/forum/#!topic/h2-database/fiUw3tqRb1o --Yakov 2016-03-24 11:33 GMT+03:00 [email protected] <[email protected]>: > hi experts, > > I can invoke SqlFieldsQuery or SqlQuery correct without args. > > But when I invoke SqlFieldsQuery or SqlQuery with args like: > > SqlFieldsQuery sql = new SqlFieldsQuery("select * from testtable1 where > id='1'"); > SqlQuery sql = new SqlQuery<String, DataBean>(Testtable1.class, "id=?"); > > I will get error message: > Caused by: org.h2.jdbc.JdbcSQLException: Hexadecimal string with odd number > of characters: "1"; SQL statement: > > Anybody can help me? > Thanks! > > Tony > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/SqlQuery-Error-tp3658.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >
