Hi,
I found the issue.
I have added this to the XML configuration:
<property name="indexedTypes">
<list>
<value>java.lang.Long</value>
<value>org.apache.ignite.examples.model.Person</value>
</list>
</property>
And it worked!
Thank you
Από: KLEARCHOU Klearchos
Αποστολή: Πέμπτη, 9 Νοεμβρίου 2017 2:55 μμ
Προς: 'user@ignite.apache.org' <user@ignite.apache.org>
Θέμα: Failed to parse query - Table not found
Hi,
I am testing the Ignite native persistence and Spring.
I started from the SpringDataExample and change it.
I created an XML configuration that is analogous to the Java configuration that
can be found at the SpringAppCfg class.
I attach the XML configuration for your reference.
I start the ExampleNodeStrtup with the attached configuration.
I activate the cluster through the gridgain console.
I run the modified example that:
1. connects to the cluster through the Java SpringAppCfg
2. Populates the repository
3. Executes the findPersons that works fine
4. Executes queryRepository and fails with the following error message:
Caused by: javax.cache.CacheException: Failed to execute map query on the node:
a27311bb-fdac-4dcf-be43-5d7477ed7f15, class
org.apache.ignite.IgniteCheckedException:Failed to parse SQL query: SELECT
"PersonCache".__Z0._KEY __C0_0,
"PersonCache".__Z0._VAL __C0_1
FROM "PersonCache".PERSON __Z0
WHERE __Z0.FIRSTNAME = ?1
The server's logs:
Caused by: org.h2.jdbc.JdbcSQLException: Table "PERSON" not found; SQL
statement:
SELECT
"PersonCache".__Z0._KEY __C0_0,
"PersonCache".__Z0._VAL __C0_1
FROM "PersonCache".PERSON __Z0
WHERE __Z0.FIRSTNAME = ?1 [42102-195]
I have started the cluster with -DIGNITE_H2_DEBUG_CONSOLE=true and I have run
this query at the H2 console:
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA
And the answer is:
E4225FA1-4F00-4C16-8C8B-E5675B399DCB
ignite-sys-cache
Unicode
OFF
FALSE
5
E4225FA1-4F00-4C16-8C8B-E5675B399DCB
PersonCache
Unicode
OFF
FALSE
6
E4225FA1-4F00-4C16-8C8B-E5675B399DCB
INFORMATION_SCHEMA
Unicode
OFF
FALSE
-1
E4225FA1-4F00-4C16-8C8B-E5675B399DCB
PUBLIC
Unicode
OFF
TRUE
0
What I have done wrong?
Thank you in advance!
Think before you print. This e-mail, and any files and attachments transmitted
with it, is confidential. It is intended for the sole use of the named
recipients(s) only. If you have received this message in error, please
immediately notify us by replying to this message and then permanently delete
it. Any views and opinions expressed are those of the individual author/sender
and are not necessarily shared or endorsed by INTRASOFT International SA or any
associated or related company. This e-mail transmission is not binding for the
purposes of forming a contract and does not form a contractual obligation of
any type.
