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

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

Kind regards,
Alex

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

Bob,

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.

-Val

------------------------------
If you reply to this email, your message will be added to the discussion
below:
http://apache-ignite-users.70518.x6.nabble.com/SQL-
Syntax-error-in-cross-cache-query-tp15097p15139.html
To start a new topic under Apache Ignite Users, email
ml+s70518n1h65@n6.nabble.com
To unsubscribe from Apache Ignite Users, click here
<http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=1&code=YWxleGFuZGVyLmZlZG90b2ZmQGdtYWlsLmNvbXwxfC0xMzYxNTU0NTg=>
.
NAML
<http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>




--
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.
Mime
View raw message