Home
Analytics
[CentOS/Tomcat] Birt Viewer JDBC configured in XML
blietaer
Dear Support,
Found many nice cookbook in order to get the Birt Viewer Working in Tomcat/Linux.
And,true, quickly enough, I could get the BirtViewer example displayed in a browser on port 8080.
The issue is when I take a *.rptdesign created from Eclispe (Windows, Linux,...) and try to have it properly displayed in Tomcat. I got, of course, the JDBC error.
The report should connect to the PostgreSQL DB on another machine, using a correct JDBC (Eclipse/Birt does it perfectly)<property name="URL">jdbc:postgresql://my_server:54322/my_db</property>
Thus Questions:
a.) Using the 3.7.2, I _do_ know the jdbc *jar should all go in WEB-INF/lib/ [and not in WEB-INF/plugin/... anymore], but it does not help. What exactly should be installed ? I have a dozen *jar from PostgreSQL web site in there...
b.) I am not sure where/how I should update the XML in order to call the correct JDBC and have it all working.
Not using any data-profile, I try hacking directly into the <oda-data-source>...but what/where?
<property name="driverClass">
<property name="jarList">p
Thank you for your support on this.
Find more posts tagged with
Comments
mwilliams
What is the error you're getting?
blietaer
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="108795" data-time="1345739504" data-date="23 August 2012 - 09:31 AM"><p>
What is the error you're getting?<br /></p></blockquote>
These:<br />
<blockquote class='ipsBlockquote' ><p>
The following items have errors:<br />
<br />
Data (id = 57):<br />
+ Can not load the report query: 57. Errors occurred when generating the report document for the report element with ID 57. (Element ID:57)<br />
<br />
Table (id = 61):<br />
+ Can not load the report query: 61. Errors occurred when generating the report document for the report element with ID 61. (Element ID:61)<br /></p></blockquote>
<br />
And this is the report, done and displayed perfectly in eclipse with the very same JDBC on the very same machine...Why is this giving issue in tomcat ??<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'><?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 4.2.0.v20120611 Build <4.2.0.v20120613-1143></property>
<list-property name="propertyBindings">
<structure>
<property name="name">queryText</property>
<property name="id">40</property>
</structure>
</list-property>
<property name="units">in</property>
<property name="iconFile">/templates/chart_listing.gif</property>
<property name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.chartlisting</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc.dbprofile" name="Data Source" id="39">
<list-property name="privateDriverProperties">
<ex-property>
<name>org.eclipse.datatools.connectivity.db.connectionProperties</name>
</ex-property>
<ex-property>
<name>org.eclipse.datatools.connectivity.oda.profile.db.provider.id</name>
<value>org.eclipse.datatools.enablement.postgresql.connectionProfile</value>
</ex-property>
<ex-property>
<name>org.eclipse.datatools.connectivity.db.savePWD</name>
<value>true</value>
</ex-property>
<ex-property>
<name>org.eclipse.datatools.connectivity.drivers.defnType</name>
<value>org.eclipse.datatools.enablement.postgresql.postgresqlDriverTemplate</value>
</ex-property>
<ex-property>
<name>org.eclipse.datatools.connectivity.driverDefinitionID</name>
<value>DriverDefn.org.eclipse.datatools.enablement.postgresql.postgresqlDriverTemplate.PostgreSQL JDBC Driver</value>
</ex-property>
<ex-property>
<name>org.eclipse.datatools.connectivity.db.version</name>
<value>8.x</value>
</ex-property>
<ex-property>
<name>org.eclipse.datatools.connectivity.db.vendor</name>
<value>postgres</value>
</ex-property>
</list-property>
<property name="databaseName">tmon</property>
<property name="username">tmon</property>
<encrypted-property name="password" encryptionID="base64">dG1vbjAx</encrypted-property>
<property name="URL">jdbc:postgresql://141.253.4.35:54322/kourou</property>
<property name="driverClass">org.postgresql.Driver</property>
<property name="jarList">/var/lib/tomcat6/webapps/birt/WEB-INF/plugins/org.eclipse.birt.report.viewer_3.7.2.v20120213/drivers/postgresql-8.3-607.jdbc4.jar</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.dbprofile.sqbDataSet" name="Data Set" id="40">
<list-property name="columnHints">
<structure>
<property name="columnName">pkid</property>
<property name="analysis">measure</property>
<text-property name="displayName">Pckt ID</text-property>
<text-property name="heading">pkid</text-property>
</structure>
<structure>
<property name="columnName">pktime</property>
<property name="analysis">dimension</property>
<text-property name="displayName">TimeStamp</text-property>
<text-property name="heading">pktime</text-property>
</structure>
<structure>
<property name="columnName">pksig</property>
<text-property name="displayName">Pckt Sig</text-property>
<text-property name="heading">pksig</text-property>
</structure>
</list-property>
<list-property name="filter"/>
<list-property name="parameters"/>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">pkid</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">pktime</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">pksig</property>
<property name="dataType">blob</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">pkid</property>
<property name="nativeName">pkid</property>
<property name="dataType">integer</property>
<property name="nativeDataType">-5</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">pktime</property>
<property name="nativeName">pktime</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">93</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">pksig</property>
<property name="nativeName">pksig</property>
<property name="dataType">blob</property>
<property name="nativeDataType">-2</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT "pkid", "pktime", "pksig"
FROM "public"."packets"
WHERE "pkid" > 15532361 AND "pkid" < 15532379
]]></xml-property>
<structure name="designerState">
<property name="version">1.0</property>
<property name="stateContentAsString"><?xml version="1.0" encoding="UTF-8"?>
<SQLQueryBuilder editorInputType="SQLBuilderStorageEditorInput" name="Data Set" version="1.0">
<SQLStatement>SELECT &quot;pkid&quot;, &quot;pktime&quot;, &quot;pksig&quot;&#x0A; FROM &quot;public&quot;.&quot;packets&quot;&#x0A; WHERE &quot;pkid&quot; &gt; 15532361 AND &quot;pkid&quot; &lt; 15532379&#x0A;</SQLStatement>
<connInfo>postgres_8.x:Transient.org.eclipse.datatools.enablement.postgresql.connectionProfile:tmon:tmon</connInfo>
<omitSchemaInfo>false:true:</omitSchemaInfo>
<editorInputUsageOptions>useWindowState=true</editorInputUsageOptions>
<windowState height="627" version="1.0" width="959">
<control height="190" isHideable="true" isVisible="true" name="SQLSourceViewer" width="932"/>
<control height="206" isHideable="true" isVisible="true" name="DesignViewer" width="945"/>
<control height="193" isHideable="true" isVisible="true" name="GraphControl" width="937"/>
<control height="193" isHideable="true" isVisible="false" name="OutlineViewer" width="136"/>
</windowState>
</SQLQueryBuilder></property>
</structure>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>2.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>pkid</design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
<design:precision>19</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>pkid</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>pkid</design:label>
<design:formattingHints>
<design:displaySize>20</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>pktime</design:name>
<design:position>2</design:position>
</design:identifier>
<design:nativeDataTypeCode>93</design:nativeDataTypeCode>
<design:precision>29</design:precision>
<design:scale>6</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>pktime</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>pktime</design:label>
<design:formattingHints>
<design:displaySize>29</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>pksig</design:name>
<design:position>3</design:position>
</design:identifier>
<design:nativeDataTypeCode>-2</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>pksig</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>pksig</design:label>
<design:formattingHints>
<design:displaySize>2147483647</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria>
<design:rowOrdering/>
</design:criteria>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="33">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="37">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab" id="38">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<grid id="4">
<property name="height">0.322in</property>
<property name="width">5.968in</property>
<column id="5"/>
<row id="6">
<property name="height">0.322in</property>
<property name="verticalAlign">text-bottom</property>
<cell id="7">
<property name="verticalAlign">top</property>
<label id="8">
<property name="fontWeight">bold</property>
<property name="textUnderline">underline</property>
<property name="textAlign">center</property>
<text-property name="text">BLI Test Kourou Packet Table</text-property>
</label>
<data id="57">
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">pkid</property>
<text-property name="displayName">Pckt ID</text-property>
<expression name="expression" type="javascript">dataSetRow["pkid"]</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
<property name="resultSetColumn">pkid</property>
</data>
</cell>
</row>
</grid>
<table id="61">
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">pkid</property>
<text-property name="displayName">Pckt ID</text-property>
<expression name="expression" type="javascript">dataSetRow["pkid"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">pktime</property>
<text-property name="displayName">TimeStamp</text-property>
<expression name="expression" type="javascript">dataSetRow["pktime"]</expression>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">pksig</property>
<text-property name="displayName">Pckt Sig</text-property>
<expression name="expression" type="javascript">dataSetRow["pksig"]</expression>
<property name="dataType">blob</property>
</structure>
</list-property>
<column id="74"/>
<column id="75"/>
<column id="76"/>
<header>
<row id="62">
<cell id="63">
<label id="77">
<text-property name="text">Pckt ID</text-property>
</label>
</cell>
<cell id="64">
<label id="79">
<text-property name="text">TimeStamp</text-property>
</label>
</cell>
<cell id="65">
<label id="81">
<text-property name="text">Pckt Sig</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="66">
<cell id="67">
<data id="78">
<property name="resultSetColumn">pkid</property>
</data>
</cell>
<cell id="68">
<data id="80">
<property name="resultSetColumn">pktime</property>
</data>
</cell>
<cell id="69">
<data id="82">
<property name="resultSetColumn">pksig</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="70">
<cell id="71"/>
<cell id="72"/>
<cell id="73"/>
</row>
</footer>
</table>
</body>
</report>
</pre>
mwilliams
Can you click on the '+' next to the first error and display the details of the error? Thanks!
blietaer
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="108959" data-time="1346335821" data-date="30 August 2012 - 07:10 AM"><p>
Can you click on the '+' next to the first error and display the details of the error? Thanks!<br /></p></blockquote>
Oh, yeah sorry.<br />
<br />
Thank you!<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
The following items have errors:
Data (id = 57):
- Can not load the report query: 57. Errors occurred when generating the report document for the report element with ID 57. (Element ID:57)
Error.ReportQueryLoadingError2 ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 57. Errors occurred when generating the report document for the report element with ID 57. (Element ID:57)
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:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.executeQuery(ReportItemExecutor.java:412)
at org.eclipse.birt.report.engine.internal.document.v4.DataItemExecutor.doExecute(DataItemExecutor.java:62)
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.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:62)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
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:294)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1547)
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)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:679)
Table (id = 61):
- Can not load the report query: 61. Errors occurred when generating the report document for the report element with ID 61. (Element ID:61)
Error.ReportQueryLoadingError2 ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 61. Errors occurred when generating the report document for the report element with ID 61. (Element ID:61)
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:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
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:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
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:294)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1547)
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)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:679)
</pre>
mwilliams
I just noticed that your design file attached above says BIRT 4.2.0. Are you still trying to use the 3.7.2 runtime? If so, try updating your runtime to 4.2. Also, the driver jar you have in the lib folder is postgresql-8.3-607.jdbc4.jar, correct?
blietaer
Yeah, I guess I was mixing stuff here in version...
I cleaned that up.
Also, I went for a simple JDBC connection (no builder here), managing driver for the latest JAR from postgresql site and...it works just fine now!
Tor your quick suppor!
consider this as closed/solved.
cheers.
mwilliams
Great to hear! Let us know whenever you have questions!