Re: Cat Example

stmr.addData(i, new Cat(i+1,"Fluffy")); > > stmr.flush(); > > } > > > > SqlFieldsQuery sql = new SqlFieldsQuery("select * from DOG > LIMIT 10"); > > try (Quer

RE: Cat Example

ql)) { for (List row : cursor) System.out.println("cat=" + row.get(0)); } } System.out.print("UP!"); }} From: Amir Akhmedov [mailto:amir.akhme...@gmail.com] Sent: Friday, February 09, 2018 5:08 PM To: user@ignite.apache.org Subject: Re:

Re: Cat Example

t;INSERT INTO person (id, name, > city_id) values (?, ?, ?)"); > > for(long i = 0; i < 100_000;++i) > > { > > cache.query(qry.setArgs(i, "John Doe", 3L)).getAll(); > > } > > System.out.p

RE: Cat Example

SqlFieldsQuery("INSERT INTO person (id, name, city_id) values (?, ?, ?)"); for(long i = 0; i < 100_000;++i) { cache.query(qry.setArgs(i, "John Doe", 3L)).getAll(); } System.out.print("HI!"); }

Re: Cat Example

Hi Mike, If SQL indexes/configuration is set with the annotation and setIndexedTypes method then you have to use the type name (Cat in your case) as the SQL table name. It’s explained here: https://apacheignite-sql.readme.io/docs/schema-and-indexes#section-annotation-based-configuration