ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From afedotov <alexander.fedot...@gmail.com>
Subject Re: SQL Syntax error in cross-cache query
Date Thu, 20 Jul 2017 06:05:09 GMT
Hi Bob,

Due to some reason my answer has got in another conversation, so
duplicating it here.

You need either adjust entity/table name to the upper case like *select ID
from "personCache".PERSON p limit 5* or
add a config option <propertyname="sqlEscapeAll" value="true"/>, in this
case you will be able to perform the query
in the following way *select \"id\" from \"personCache\".\"Person\" p limit
5* (note the escaping is mandatory for all the parts: schema, table, field).

Kind regards,

Kind regards,

19 июля 2017 г. 11:12 PM пользователь "vkulichenko [via Apache Ignite
Users]" <ml+s70518n15139h43@n6.nabble.com> написал:


Original query is wrong for sure. \\\" means that you actually have a slash
in SQL string which is obviously wrong. As for the second error, it looks
like a misconfiguration. Please provide more information on what exactly
you did, your configuration, etc.


If you reply to this email, your message will be added to the discussion
To start a new topic under Apache Ignite Users, email
To unsubscribe from Apache Ignite Users, click here

View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Re-SQL-Syntax-error-in-cross-cache-query-tp15157.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
View raw message