Hi, How did you create a mapping for SQL? The problem is that in key and value classes you have fields with a same names - id & type. These fields are not related to each other, I would recommend removing them from the Value class.
Evgenii вт, 11 февр. 2020 г. в 13:59, Edward Chen <[email protected]>: > Hello, > > I am using Ignite 2.7.6 and testing its SQL insert function. I have these > codes: > > > PersonKey { > id: Long; > type: String; > // constructor, getter, setter .... > // hashCode, toString ... > } > > Person { > id: Long; > type: String; > name: String; > zip: String; > > public PersonKey getKey() {return new PersonKey(...);} > > // constructor, getter, setter .... > // hashCode, toString ... > } > > insert sql: "insert into Person(id, type, name, zip) values (100, "S", > "John", "11223") > > when get data back from Cache, > Iterator<..> iter = cache.iterator(); > while(iter.hasNext()){ > Cache.Entry<PersonKey, Person> entry = iter.next(); > > entry.getKey --> *0,null * > } > > The last output is not correct, it should be *"100, S"* . > > Any inputs please ? > > Thanks >
