How to use BinaryObject Cache API to query a table created from JDBC?

[Ray]

Let's say I create a table from jdbc client using this command.

create table test(a varchar, b varchar, c varchar,primary key(a,b));

I inserted one record in this table.

 select * from test;
+--------------------------------+--------------------------------+--------------------------------+
|               A                |               B                |             
 
C                |
+--------------------------------+--------------------------------+--------------------------------+
| 8                              | 8                              | 9           
                  
|
+--------------------------------+--------------------------------+--------------------------------+

How can I query this table using BinaryObject Cache API?

I tried the code below, but it returns null for object o.

public class TestKey {

    private String a;

    private String b;

    public TestKey() {
    }

    public String getA() {
        return a;
    }

    public void setA(String a) {
        this.a = a;
    }

    public String getB() {
        return b;
    }

    public void setB(String b) {
        this.b = b;
    }
}



        TestKey tk = new TestKey();
        tk.setA("8");
        tk.setB("8");
        Object o = ignite.cache("SQL_PUBLIC_TEST").get(tk);



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/