Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 368242

Summary: Report with Hibernate Data Source throws EngineException
Product: z_Archived Reporter: Christian Jacob <christian.jacob>
Component: BIRTAssignee: Birt-ReportViewer <Birt-ReportViewer-inbox>
Status: NEW --- QA Contact:
Severity: normal    
Priority: P3 CC: bluesoldier
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard:
Attachments:
Description Flags
simple report with hibernate data source
none
xhtml to show the report in a frameset none

Description Christian Jacob CLA 2012-01-10 08:15:57 EST
Build Identifier: Version: Helios Service Release 2 Build id: 20110218-0911

I designed a report that uses a Hibernate Data source. I can see the values in the designer. However, when I was trying to view it in my Seam application, the DataPresentationEngine throws an error. Here is the stack trace:

Can not load the report query: 11. Errors occurred when generating the report document for the report element with ID 11. 
Error.ReportQueryLoadingError2 ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 11. Errors occurred when generating the report document for the report element with ID 11.
	at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:164)
	at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1890)
	at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.executeQuery(ReportItemExecutor.java:412)
	at org.eclipse.birt.report.engine.internal.document.v4.TableItemExecutor.doExecute(TableItemExecutor.java:72)
	at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.execute(ReportItemExecutor.java:294)
	at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.prepareChildExecutor(ContainerExecutor.java:226)
	at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.hasNextChild(ContainerExecutor.java:110)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)
	at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExecutorWrapper.hasNextChild(RenderTask.java:780)
	at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasNextChild(HTMLPageLM.java:68)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:62)
	at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
	at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
	at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:661)
	at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:284)
	at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1545)
	at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204)
	at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(AbstractGetPageActionHandler.java:238)
	at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:105)
	at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
	at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
	at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
	at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87)

This does not happen, if I use "run" or "preview" in the attribute "designType" instead of "frameset". It also does not happen with reports that use an SQL data source. And, yes, I copied the jdbc driver to WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_2.6.2.r262_v20110127\drivers

Reproducible: Always

Steps to Reproduce:
1. Create a report with a hibernate data source
2. Try to show it within a Seam application
Comment 1 Christian Jacob CLA 2012-01-10 08:18:26 EST
Created attachment 209256 [details]
simple report with hibernate data source
Comment 2 Christian Jacob CLA 2012-01-10 08:19:20 EST
Created attachment 209257 [details]
xhtml to show the report in a frameset
Comment 3 Christian Jacob CLA 2012-01-10 09:34:56 EST
I have to correct myself concerning the designType attribute: with "preview" or "run" an exception is actually not thrown, but the PDF sheets are almost empty. They just contain the fixed texts and show no result set. I suspect that the exception is caught internally and that the result set is not processed further.
Comment 4 Xiaoying Gu CLA 2013-03-05 03:50:46 EST
Can you preview the report design in the BIRT designer other than the Seam project?