JasperServer with Bean Data Source giving ClassCastException

[technologist.kj]

I'm using JRBeanCollectionDatasource with Jasper server. I could test the datasource successfully by providing "beanIdInSpring" and "getMycollection" as the bean and function name in the add new datasource page.

The "getMyCollection" function inside the bean returns and arraylist of class "MyBean".

Although such a setup works well in IReport, when I try to view this in Jasper Server I get this error -

java.lang.ClassCastException: java.util.ArrayList cannot be cast to com.jaspersoft.jasperserver.api.metadata.jasperreports.service.ReportDataSourceService at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BeanReportDataSourceServiceFactory.createService(BeanReportDataSourceServiceFactory.java:89) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.createDataSourceService(EngineServiceImpl.java:710) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:655) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:356) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:788) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:60) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:288) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:329) at com.jaspersoft.jasperserver.war.action.ViewReportAction.verifyData(ViewReportAction.java:222) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136)

[kavi_mathi]

Any update reg this?

[technologist.kj]

Figured out that the concept of a "datasource" is different in iReport UI and jasperServer. Please follow this tutorial to create a custom query executor in jasper server.

[technologist.kj]

updated as answer.