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 <property name="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.
On Wed, Jul 19, 2017 at 12:57 PM, Bob Li <2789106...@qq.com> wrote:
> thank afedotov.
>
> personCache definition in this xml file.
>
> <bean class="org.apache.ignite.
> configuration.CacheConfiguration">
> <property name="name"
> value="personCache"></property>
> <property name="statisticsEnabled"
> value="true" />
>
> <property name="indexedTypes"
> value="java.lang.Long,
> com.howfree.report.model.Person" />
> <property
> name="onheapCacheEnabled" value="true"/>
>
> </bean>
>
>
>
> Used POJO class including spring-data-mongo annotation lilke @Field.
>
> @Document
> public class Person implements Serializable {
> @Id
> private String _id;
> @Field("id")
> @QuerySqlField(name = "id")
> private Long id;
>
> @Field("biz_date")
> @QuerySqlField(index = true, name = "biz_date")
> private Date bizDate;
> ...................................................................
> }
>
>
>
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Re-SQL-Syntax-error-in-cross-cache-
> query-tp15107p15115.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
