is there any good and helpful tutorial out there?

[joka83]

 Well, after nearly 9hours trying to establish a custom java bean datasource on the server, I am that close to become crazy.

Is there any good tutorial out there, which gives a step by step view on this topic? especially on creating the application-context file? the docs delivered within the software are a joke in my opinion !! 

 

regards

daniel

Post Edited by joka83 at 04/15/2011 17:11

[tkavanagh]

Hi Daniel,

Do you have access to the Admin Guide (it's a Pro Guide). It has a section on Custom Datasources. Unfortunately, there is no Admin Guide for the Community product - kind of an oversite. And the datasources section is going to be moved out of the Admin guide and put into the Ultimate Guide - which Community members can get access to.

You could download the Pro Evaluation installer and get the Admin Guide ....

[joka83]

 hey tkavanagh,

 

thanks a lot, I finally got my bean datasource working in ireports ;)

but when I try to connect it to your jasperserver product i face new problems...

i published my datasource via spring beans and I am able to get a "Connection passed"-Success whenever I try to connect to my database ! (Bean Data Source) ;)))

bean name is the id I used in spring bean application context and the bean method is the method which returns an arraylist of beans.

but when I try to  fill my custom Report with the datasource I get an issue called:

 

java.lang.ClassCastException: java.util.ArrayList cannot be cast to com.jaspersoft.jasperserver.api.metadata.jasperreports.service.ReportDataSourceService

Error Trace

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:86) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.createDataSourceService(EngineServiceImpl.java:799) at 

...

 

In my application I return an ArrayList of Beans. Well in iReport it works great, but why doesnt it in JasperServer...

what do i have to do?

 

any help would be nice...its a great feeling to see things working fine ;)

 

 

 

Post Edited by joka83 at 04/29/2011 13:30

[joka83]

 hey guys, me again ;)

 

i just wrote a factory class which returns a reportdatasourceservice....works fine, but now i get an error called

 

"Incompatible java.util.ArrayList value assigned to parameter REPORT_DATA_SOURCE in the report1 dataset."

 

I dont find any help, which values i could use there? any help? whats my fault? 

 

some tipps would be great ;)

 

regards daniel

 

update: I am able to do the report, but no pages are shown...think there is a problem submitting the arraylist to the report generator?! :(

Post Edited by joka83 at 05/01/2011 09:25

[technologist.kj]

How did you solve this Daniel ? I'm workng with jasper server and JRBeanCollection datasource - hitting this issue now :)

[hariharanwebmail]

I gave a try with custom datasource and it seems to work fine... I have documented the steps at...

http://hariharanwebmail.blogspot.in/2012/12/jasper-friendly-ghost.html

[technologist.kj]

There were certain config  changes to be done over the ones given in jasper's examples. They are documented here - http://www.codemarvels.com/2012/12/implementing-a-custom-query-executor-custom-data-source-in-jasper-server/