stat.execute("CREATE TABLE TEST(ID INT, NAME VARCHAR, DATA VARCHAR)");
rs = stat.executeQuery("SELECT * FROM TEST");
assertEquals(1, rs.findColumn("ID"));
assertEquals(2, rs.findColumn("NAME"));
assertEquals(3, rs.findColumn("DATA"));
assertEquals(1, rs.findColumn("id"));
assertEquals(2, rs.findColumn("name"));
assertEquals(3, rs.findColumn("data"));
assertEquals(1, rs.findColumn("Id"));
assertEquals(2, rs.findColumn("Name"));
assertEquals(3, rs.findColumn("Data"));