ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yakov Zhdanov <yzhda...@apache.org>
Subject Re: SqlQuery Error
Date Thu, 24 Mar 2016 08:59:31 GMT
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 16616221@qq.com <16616221@qq.com>:

> 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.
>

Mime
View raw message