Re: How to load 2 tables in a cache

2016-04-14 Thread vkulichenko
Hi, Is it possible for you to create a small GitHub project that will reproduce the issue and share it with us? I'm a bit lost in the amounts of code that you copy-pasted here :) -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables

Re: How to load 2 tables in a cache

2016-04-14 Thread tusharnakra
"PCache".PERSON WHERE (SALARY > ?1) AND (SALARY <= ?2) [90003-175] -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4175.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: How to load 2 tables in a cache

2016-04-14 Thread Vladimir Ozerov
mployees. > List> res = cursor.getAll(); > > // Print persons' names and organizations' names. > print("Names of all employees and organizations they belong to:", > res); > } > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4136.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >

Re: How to load 2 tables in a cache

2016-04-13 Thread tusharnakra
case each row will have one element with full name of an employees. List> res = cursor.getAll(); // Print persons' names and organizations' names. print("Names of all employees and organizations they belong to:", res); } -- View this message in context:

Re: How to load 2 tables in a cache

2016-04-13 Thread tusharnakra
Could this error be because I haven't done setIndexedType?: cfg1.setIndexedTypes(OrganizationKey.class, Organization.class); OR because I have same column name "orgid" in both the tables?? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-l

Re: How to load 2 tables in a cache

2016-04-13 Thread tusharnakra
fg.setCacheStoreFactory(storeFactory); ccfg.setReadThrough(true); ccfg.setWriteThrough(true); // Configure JDBC types. Collection jdbcTypes = new ArrayList<>(); jdbcTypes.add(jdbcTypeOrganization(cacheName)); jdbcTypes.add(jdbcTypePerson(cacheName));

Re: How to load 2 tables in a cache

2016-04-12 Thread vkulichenko
Can you please show your CacheConfig class? -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4113.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: How to load 2 tables in a cache

2016-04-12 Thread tusharnakra
mal 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:

Re: How to load 2 tables in a cache

2016-04-11 Thread vkulichenko
Database first_name name should be mapped to firstName in Java object, and you should use the Java name when executing SQL queries against the data in memory. Can you try this? -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache

Re: How to load 2 tables in a cache

2016-04-11 Thread tusharnakra
eOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:1769) ... 3 more Caused by: org.h2.jdbc.JdbcSQLException: Column "PERSON.FIRST_NAME" not found; SQL statement: select Person.first_name from Person, "OrgCache".Organization where Person.orgId = Organization.orgId and Organization.orgname = ? [42122-175] -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4082.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: How to load 2 tables in a cache

2016-04-11 Thread tusharnakra
Hi @dsetrakyan, Can you look into my above comment, the error that I'm getting? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4071.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: How to load 2 tables in a cache

2016-04-11 Thread Dmitriy Setrakyan
/docs/sql-queries > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4069.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >

Re: How to load 2 tables in a cache

2016-04-11 Thread tusharnakra
Yes, it makes sense! So, is there any way that the SQL JOIN relations can work in gridgain for the 2 tables loaded in different cache? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4069.html Sent from the Apache Ignite

Re: How to load 2 tables in a cache

2016-04-11 Thread Alexey Kuznetsov
users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4065.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Alexey Kuznetsov GridGain Systems www.gridgain.com

Re: How to load 2 tables in a cache

2016-04-11 Thread tusharnakra
I don't understand what you mean by data types? I'm talking about 2 database tables present in the same MySql database/ -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4065.html Sent from the Apache Ignite Use

Re: How to load 2 tables in a cache

2016-04-10 Thread Vasiliy Sisko
-- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026p4047.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

How to load 2 tables in a cache

2016-04-08 Thread tusharnakra
-- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-load-2-tables-in-a-cache-tp4026.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.