Help with executeAndFetchTable().asList() + JRMapCollectionDataSource

[FkJ]

Hi,

Probably I'm missing something basic, but the following code doesn't compile:

try (Connection con = sql2o.open())
{
Collection<Map<String, Object>> result = con.createQuery(sql.toString()).executeAndFetchTable().asList();
JRMapCollectionDataSource dataSource = new JRMapCollectionDataSource(result);
        ...

I'm getting this error: The constructor JRMapCollectionDataSource(List<Map<String,Object>>) is undefined

Class constructor looks like this: public JRMapCollectionDataSource(Collection<Map<String,?>> col)

I tried to change result to Collection<Map<String, ?>>, but then I get this: Type mismatch: cannot convert from List<Map<String,Object>> to Collection<Map<String,?>> 

Is there any workaround better than iterate the map returned by Sql2o and create a new one that will be compatible with JasperReports?

Sql2o version is 1.5.4, JasperReports version is 5.5.0.

Thanks

[FkJ]

Found a workaround: http://stackoverflow.com/questions/27804925/how-to-cast-listmap-into-listmapstring-string

[dpon...@gmail.com]

http://paulguru.blogspot.pe/2015/10/exportar-pdf-con-jasperreport.html?q=jasper