OK, I changed the SQL query to: "select Person.firstName "
+ "from Person, \"OrgCache\".Organization where
"
+ "Person.orgid = Organization.orgid "
+ "and Organization.orgname = ?");
Getting the following error:
Failed to execute local query: GridQueryRequest [reqId=1, pageSize=1024,
space=PCache, qrys=[GridCacheSqlQuery [qry=SELECT
PERSON.FIRSTNAME __C0
FROM "PCache".PERSON
INNER JOIN "OrgCache".ORGANIZATION
WHERE (ORGANIZATION.ORGNAME = ?1) AND (PERSON.ORGID = ORGANIZATION.ORGID),
params=[Ignite], paramIdxs=[0], paramsSize=1, cols={__C0=GridSqlType
[type=19, scale=0, precision=2147483647, displaySize=2147483647,
sql=OTHER]}, alias=null]], topVer=AffinityTopologyVersion [topVer=1,
minorTopVer=4], extraSpaces=[OrgCache], parts=null]
class org.apache.ignite.IgniteCheckedException: Failed to execute SQL query.
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:832)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:855)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:454)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:184)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1065)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:572)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$2.iterator(IgniteH2Indexing.java:956)
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:61)
at org.apache.ignite.organization.Demo.main(Demo.java:92)
Caused by: org.h2.jdbc.JdbcSQLException: Hexadecimal string contains non-hex
character: "Ignite"; SQL statement:
SELECT
PERSON.FIRSTNAME __C0
FROM "PCache".PERSON
INNER JOIN "OrgCache".ORGANIZATION
WHERE (ORGANIZATION.ORGNAME = ?1) AND (PERSON.ORGID = ORGANIZATION.ORGID)
[90004-175]
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4100.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
