trouble serialize results - executeAndFetchTable().asList()

[ro...@uwf.edu]

Trying to serialize the result of a simple select query.

I am getting 

java.lang.UnsupportedOperationException: Row map does not support entrySet.

at org.sql2o.data.Row$1.entrySet(Row.java:190)

tasks = con.createQuery(sql).executeAndFetchTable().asList();

Type listOfMaps = new TypeToken<List<Map<String,Object>>>(){}.getType();

Gson gson = new Gson();
resString = gson.toJson(tasks, listOfMaps);

[martina...@gmail.com]

I am getting the same problem.

I tried the example from the web site which didn't work:

public List<Map<String,Object>> getReportData(){
    String complexSql = "...";

    try (Connection con = sql2o.open()) {
        return con.createQuery(complexSql).executeAndFetchTable().asList();
    }
}

It simply returns : 

System.out.println(getReportData);

[org.sql2o.data.Row$1@134886f7, org.sql2o.data.Row$1@1d213cfa, org.sql2o.data.Row$1@7e68e907, org.sql2o.data.Row$1@2c1bc3d2, org.sql2o.data.Row$1@7b338798]

[martina...@gmail.com]

I used executeAndFetchTable() and this method as workaround:

     private List<Map<String, Object>> tableToList(Table t) {
        List<Map<String, Object>> mapList = new ArrayList<>();
        for (int i = 0; i < t.rows().size(); i++) {
            Map<String,Object> map = new HashMap<>();
            for (int j = 0; j < t.columns().size(); j++) {
                map.put(t.columns().get(j).getName(), t.rows().get(i).getObject(j));
            }
            mapList.add(map);


        }
        return mapList;
    }

[costa...@gmail.com]

I had a similar issue in scala but I solved it by casting row.asMap() to HashMap.

[costa...@gmail.com]

Sorry, I thought that the cast would fix the issue and I posted the message before trying it. It seems that the latest version of the source code creates the Row.asMap as a HashMap and I thought that that change was made a long time ago, but it turns out it is only in version 1.6.0-RC3. So, upgrading to this version got rid of the error.