Hi All,
I have defined sample cache configuration as shown below and started my 2
server nodes based on this configuration. After loading data from Java
client, I tried to run a SQL query from SQL Viewe -> Visor and it gives me
the following error (I do not get this error when i define SQL annotations
and indexes using Java Client)
Please can anyone help to understand the root cause of this issue and how
to fix it.
"*Failed to parse SQL query: SELECT*
***
*FROM*
*"CodingSchemes".be.xyz.gridgain.model.CodingScheme*
*Table "BE" not found; SQL statement:"*
*//Refer below for complete Error Trace*
*XML Configuration*
* <bean id="ignite.cfg"
class="org.apache.ignite.configuration.IgniteConfiguration">*
* <property name="cacheConfiguration">*
* <list>*
* <bean
class="org.apache.ignite.configuration.CacheConfiguration">*
* <property name="name" value="CodingSchemes"/>*
* <property name="rebalanceMode" value="SYNC"/>*
* <property name="cacheMode" value="REPLICATED"/> *
* <property name="queryEntities">*
* <list>*
* <bean
class="org.apache.ignite.cache.QueryEntity">*
* <property name="keyType"
value="java.lang.Long"/>*
* <property name="valueType"
value="be.ing.gridgain.model.CodingScheme"/> *
* <property name="fields">*
* <map>*
* <entry key="entryId" value="java.lang.Long"/>*
* <entry key="tableName" value="java.lang.String"/>*
* <entry key="code" value="java.lang.String"/>*
* <entry key="valueNL" value="java.lang.String"/>*
* <entry key="valueFR" value="java.lang.String"/>*
* <entry key="valueEN" value="java.lang.String"/>*
* <entry key="valueDE" value="java.lang.String"/>*
* </map>*
* </property>*
* <property name="indexes">*
* <list>*
* <bean class="org.apache.ignite.cache.QueryIndex">*
* <constructor-arg value="entryId"/>*
* </bean>*
* </list>*
* </property>*
* </bean>*
* </list>*
* </property>*
* </bean>*
* </list>*
* </property>*
*Error Trace :*
Caused by: org.apache.ignite.IgniteCheckedException: *Failed to parse SQL
query: SELECT*
***
*FROM*
*"CodingSchemes".be.xyz.gridgain.model.CodingScheme*
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:787)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:829)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryFields(IgniteH2Indexing.java:713)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$7.applyx(GridQueryProcessor.java:881)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$7.applyx(GridQueryProcessor.java:875)
at
org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:1651)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.queryLocalFields(GridQueryProcessor.java:875)
... 17 more
*Caused by: org.h2.jdbc.JdbcSQLException: Table "BE" not found; SQL
statement:*
SELECT
*
FROM
"CodingSchemes".be.xyz.gridgain.model.CodingScheme [42102-175]
at
org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:172)
at org.h2.message.DbException.get(DbException.java:149)
at org.h2.schema.Schema.getTableOrView(Schema.java:440)
at org.h2.command.Parser.readTableOrView(Parser.java:5055)
at org.h2.command.Parser.readTableFilter(Parser.java:1188)
at
org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1813)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1921)
at org.h2.command.Parser.parseSelectSub(Parser.java:1807)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1631)
at org.h2.command.Parser.parseSelect(Parser.java:1619)
at org.h2.command.Parser.parsePrepared(Parser.java:426)
at org.h2.command.Parser.parse(Parser.java:298)
at org.h2.command.Parser.parse(Parser.java:270)
at org.h2.command.Parser.prepareCommand(Parser.java:235)
at org.h2.engine.Session.prepareLocal(Session.java:436)
at org.h2.engine.Session.prepareCommand(Session.java:379)
at
org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
at
org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:70)
at
org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:267)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.prepareStatement(IgniteH2Indexing.java:334)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:784)
... 24 more
--
Thanks & Regards
Vaibhav Dutt Sharma
