Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Can not load the report query: 160. Errors occurred when generating the report document for the repo(Error when running report from server.)
Can not load the report query: 160. Errors occurred when generating the report document for the repo [message #693613] Wed, 06 July 2011 21:26 Go to next message
SGT. Smith is currently offline SGT. SmithFriend
Messages: 2
Registered: July 2011
Junior Member
I have developed a simple report and trying to deploy it to the server and run and I am getting the following error:

The following items have errors:

Table (id = 160):
+ Can not load the report query: 160. Errors occurred when generating the report document for the report element with ID 160. (Element ID:160)


It works in the BIRT designer (Windows) but not on the Linux/Ubuntu/Tomcat6 machine.

I believe it can not find: com.mysql.jdbc.Driver
which is a class in : mysql-connector-java-5.1.0-bin.jar

which I downloaded and added to the Windows machine and copied the jar to:

/var/lib/tomcat6/webapps/birt/WEB-INF/lib/mysql-connector-java-5.1.0-bin.jar

TIA for any pointers.

The error in the log is:

Jul 6, 2011 5:01:06 PM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
SEVERE: Unable to open connection.
org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:113)
	at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:57)
	at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
	at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
	at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
	at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
	at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:409)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:319)
	at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
	at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
	at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
	at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
	at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:616)
	at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
	at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:80)
	at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1897)
	at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
	at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
	at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
	at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
	at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
	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.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249)
	at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:260)
	at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:85)
	at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1317)
	at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)
	at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
	at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)
	at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)
	at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)
	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)
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
	at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:615)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
	at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:212)
	at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.internalCreateConnection(JDBCConnection.java:140)
	at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)
	at org.eclipse.datatools.enablement.internal.mysql.connection.JDBCMySQLConnectionFactory.createConnection(JDBCMySQLConnectionFactory.java:28)
	at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
	at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
	at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:659)
	at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:644)
	at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
	at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
	at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
	at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
	at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)
	at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)


Report XML:
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="(error posting this about links...)" version="3.2.22" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 3.7.0.v20110602 Build &lt;3.7.0.v20110607-1526></property>
    <list-property name="userProperties">
        <structure>
            <property name="name">Data Cube - Data Set.Data Set.x</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">Data Cube - Data Set.Data Set.y</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
    </list-property>
    <property name="Data Cube - Data Set.Data Set.x">135</property>
    <property name="Data Cube - Data Set.Data Set.y">80</property>
    <property name="units">in</property>
    <property name="iconFile">/templates/crosstab.gif</property>
    <property name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.crosstab</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="18">
            <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.mysql.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.mysql.5_1.driverTemplate</value>
                </ex-property>
                <ex-property>
                    <name>org.eclipse.datatools.connectivity.db.version</name>
                    <value>5.1</value>
                </ex-property>
                <ex-property>
                    <name>org.eclipse.datatools.connectivity.db.vendor</name>
                    <value>MySql</value>
                </ex-property>
            </list-property>
            <property name="databaseName">xxxxx</property>
            <property name="username">xxxxxxxxxxxx</property>
            <encrypted-property name="password" encryptionID="base64">xxxxxxxxxxxxx</encrypted-property>
            <property name="URL">jdbc:mysql://10.226.9.150:3306/polk</property>
            <property name="driverClass">com.mysql.jdbc.Driver</property>
            <property name="jarList">mysql-connector-java-5.1.0-bin.jar;/var/lib/tomcat6/webapps/birt/WEB-INF/lib/mysql-connector-java-5.1.0-bin.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="20">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">Make</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">MAKE</text-property>
                    <text-property name="heading">MAKE</text-property>
                </structure>
                <structure>
                    <property name="columnName">Model</property>
                    <property name="analysis">attribute</property>
                    <text-property name="displayName">MODEL</text-property>
                    <text-property name="heading">MODEL</text-property>
                </structure>
                <structure>
                    <property name="columnName">COUNT</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">COUNT</text-property>
                    <text-property name="heading">COUNT</text-property>
                </structure>
            </list-property>
            <list-property name="parameters"/>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">Make</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">Model</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">COUNT</property>
                        <property name="dataType">integer</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">Make</property>
                    <property name="nativeName">Make</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">Model</property>
                    <property name="nativeName">Model</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">COUNT</property>
                    <property name="nativeName">COUNT</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">-5</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[SELECT MAKE, MODEL, COUNT(VIN) AS COUNT
  FROM `polk`.`data`
  GROUP BY MAKE, MODEL
]]></xml-property>
            <structure name="designerState">
                <property name="version">1.0</property>
                <property name="stateContentAsString">&lt;?xml version="1.0" encoding="UTF-8"?>
&lt;SQLQueryBuilder editorInputType="SQLBuilderStorageEditorInput" name="Data Set" version="1.0">
&lt;SQLStatement>SELECT MAKE, MODEL, COUNT(VIN) AS COUNT&amp;#x0A;  FROM `polk`.`data`&amp;#x0A;  GROUP BY MAKE, MODEL&amp;#x0A;&lt;/SQLStatement>
&lt;connInfo>MySql_5.1:Transient.org.eclipse.datatools.enablement.mysql.connectionProfile:polk:ksmith&lt;/connInfo>
&lt;omitSchemaInfo>false:true:&lt;/omitSchemaInfo>
&lt;editorInputUsageOptions>useWindowState=true&lt;/editorInputUsageOptions>
&lt;windowState height="594" version="1.0" width="856">
&lt;control height="181" isHideable="true" isVisible="true" name="SQLSourceViewer" width="829"/>
&lt;control height="192" isHideable="true" isVisible="true" name="DesignViewer" width="842"/>
&lt;control height="183" isHideable="true" isVisible="true" name="GraphControl" width="834"/>
&lt;control height="187" isHideable="true" isVisible="false" name="OutlineViewer" width="156"/>
&lt;/windowState>
&lt;/SQLQueryBuilder></property>
            </structure>
            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="(error about post having links...)" xmlns:model="(error about post having links...)">
  <Version>2.0</Version>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>Dealer_State</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>2</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>DEALER_STATE</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>DEALER_STATE</design:label>
            <design:formattingHints>
              <design:displaySize>2</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>Make</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>128</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>MAKE</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>MAKE</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>COUNT</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>21</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>COUNT</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>COUNT</design:label>
            <design:formattingHints>
              <design:displaySize>21</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="4">
            <property name="fontFamily">sans-serif</property>
            <property name="fontSize">10pt</property>
        </style>
        <style name="crosstab-cell" id="5">
            <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="6">
            <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="7">
            <column id="8"/>
            <row id="9">
                <cell id="10">
                    <label id="11">
                        <property name="fontSize">14pt</property>
                        <property name="fontWeight">bold</property>
                        <property name="textAlign">center</property>
                        <text-property name="text">Cross Tab</text-property>
                    </label>
                </cell>
            </row>
        </grid>
        <table id="160">
            <property name="dataSet">Data Set</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">Make</property>
                    <text-property name="displayName">MAKE</text-property>
                    <expression name="expression" type="javascript">dataSetRow["Make"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">Model</property>
                    <text-property name="displayName">MODEL</text-property>
                    <expression name="expression" type="javascript">dataSetRow["Model"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">COUNT</property>
                    <text-property name="displayName">COUNT</text-property>
                    <expression name="expression" type="javascript">dataSetRow["COUNT"]</expression>
                    <property name="dataType">integer</property>
                </structure>
            </list-property>
            <column id="173"/>
            <column id="174"/>
            <column id="175"/>
            <header>
                <row id="161">
                    <cell id="162">
                        <label id="176">
                            <text-property name="text">MAKE</text-property>
                        </label>
                    </cell>
                    <cell id="163">
                        <label id="178">
                            <text-property name="text">MODEL</text-property>
                        </label>
                    </cell>
                    <cell id="164">
                        <label id="180">
                            <text-property name="text">COUNT</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="165">
                    <cell id="166">
                        <data id="177">
                            <property name="resultSetColumn">Make</property>
                        </data>
                    </cell>
                    <cell id="167">
                        <data id="179">
                            <property name="resultSetColumn">Model</property>
                        </data>
                    </cell>
                    <cell id="168">
                        <data id="181">
                            <property name="resultSetColumn">COUNT</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="169">
                    <cell id="170"/>
                    <cell id="171"/>
                    <cell id="172"/>
                </row>
            </footer>
        </table>
    </body>
</report>
Re: Can not load the report query: 160. Errors occurred when generating the report document for the [message #693684 is a reply to message #693613] Thu, 07 July 2011 01:53 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

If you are using BIRT 3.7 that should be fine. If you are using a
previous version put it in the
web-inf/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_version/drivers
directory

Jason


On 7/6/2011 5:26 PM, SGT. Smith wrote:
> I have developed a simple report and trying to deploy it to the server
> and run and I am getting the following error:
>
> The following items have errors:
>
> Table (id = 160):
> + Can not load the report query: 160. Errors occurred when generating
> the report document for the report element with ID 160. (Element ID:160)
> It works in the BIRT designer (Windows) but not on the
> Linux/Ubuntu/Tomcat6 machine.
>
> I believe it can not find: com.mysql.jdbc.Driver
> which is a class in : mysql-connector-java-5.1.0-bin.jar
>
> which I downloaded and added to the Windows machine and copied the jar to:
>
> /var/lib/tomcat6/webapps/birt/WEB-INF/lib/mysql-connector-java-5.1.0-bin.jar
>
>
> TIA for any pointers.
>
> The error in the log is:
>
>
> Jul 6, 2011 5:01:06 PM
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
> SEVERE: Unable to open connection.
> org.eclipse.datatools.connectivity.oda.OdaException ;
> java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
> at
> org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:113)
>
> at
> org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:57)
>
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
>
> at
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
>
> at
> org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
>
> at
> org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
> at
> org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
>
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:409)
>
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:319)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
>
> at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:616)
>
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
>
> at
> org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:80)
>
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
>
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1897)
>
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
>
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
>
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
>
> at
> org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
>
> at
> org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
>
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
>
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
>
> 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.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249)
>
> at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:260)
> at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:85)
> at
> org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1317)
>
> at
> org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)
>
> at
> org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
>
> at
> org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)
>
> at
> org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)
>
> at
> org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)
>
> 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)
> Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
> at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
> at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:615)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
> at
> org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:212)
>
> at
> org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.internalCreateConnection(JDBCConnection.java:140)
>
> at
> org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)
>
> at
> org.eclipse.datatools.enablement.internal.mysql.connection.JDBCMySQLConnectionFactory.createConnection(JDBCMySQLConnectionFactory.java:28)
>
> at
> org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
>
> at
> org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
>
> at
> org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:659)
>
> at
> org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:644)
>
> at
> org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
>
> at
> org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
>
> at
> org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
>
> at
> org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
>
> at
> org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)
>
> at
> org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
>
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
>
>
> Report XML:
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="(error posting this about links...)" version="3.2.22"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 3.7.0.v20110602
> Build <3.7.0.v20110607-1526></property>
> <list-property name="userProperties">
> <structure>
> <property name="name">Data Cube - Data Set.Data Set.x</property>
> <property name="type">integer</property>
> <property name="isVisible">false</property>
> </structure>
> <structure>
> <property name="name">Data Cube - Data Set.Data Set.y</property>
> <property name="type">integer</property>
> <property name="isVisible">false</property>
> </structure>
> </list-property>
> <property name="Data Cube - Data Set.Data Set.x">135</property>
> <property name="Data Cube - Data Set.Data Set.y">80</property>
> <property name="units">in</property>
> <property name="iconFile">/templates/crosstab.gif</property>
> <property
> name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.crosstab</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="18">
> <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.mysql.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.mysql.5_1.driverTemplate</value>
> </ex-property>
> <ex-property>
> <name>org.eclipse.datatools.connectivity.db.version</name>
> <value>5.1</value>
> </ex-property>
> <ex-property>
> <name>org.eclipse.datatools.connectivity.db.vendor</name>
> <value>MySql</value>
> </ex-property>
> </list-property>
> <property name="databaseName">xxxxx</property>
> <property name="username">xxxxxxxxxxxx</property>
> <encrypted-property name="password"
> encryptionID="base64">xxxxxxxxxxxxx</encrypted-property>
> <property name="URL">jdbc:mysql://10.226.9.150:3306/polk</property>
> <property name="driverClass">com.mysql.jdbc.Driver</property>
> <property
> name="jarList">mysql-connector-java-5.1.0-bin.jar;/var/lib/tomcat6/webapps/birt/WEB-INF/lib/mysql-connector-java-5.1.0-bin.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="20">
> <list-property name="columnHints">
> <structure>
> <property name="columnName">Make</property>
> <property name="analysis">attribute</property>
> <text-property name="displayName">MAKE</text-property>
> <text-property name="heading">MAKE</text-property>
> </structure>
> <structure>
> <property name="columnName">Model</property>
> <property name="analysis">attribute</property>
> <text-property name="displayName">MODEL</text-property>
> <text-property name="heading">MODEL</text-property>
> </structure>
> <structure>
> <property name="columnName">COUNT</property>
> <property name="analysis">measure</property>
> <text-property name="displayName">COUNT</text-property>
> <text-property name="heading">COUNT</text-property>
> </structure>
> </list-property>
> <list-property name="parameters"/>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">Make</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">Model</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">COUNT</property>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">Make</property>
> <property name="nativeName">Make</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">Model</property>
> <property name="nativeName">Model</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">COUNT</property>
> <property name="nativeName">COUNT</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">-5</property>
> </structure>
> </list-property>
> <xml-property name="queryText"><![CDATA[SELECT MAKE, MODEL, COUNT(VIN)
> AS COUNT
> FROM `polk`.`data`
> GROUP BY MAKE, MODEL
> ]]></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 MAKE, MODEL, COUNT(VIN) AS COUNT&#x0A; FROM
> `polk`.`data`&#x0A; GROUP BY MAKE, MODEL&#x0A;</SQLStatement>
> <connInfo>MySql_5.1:Transient.org.eclipse.datatools.enablement.mysql.connectionProfile:polk:ksmith</connInfo>
>
> <omitSchemaInfo>false:true:</omitSchemaInfo>
> <editorInputUsageOptions>useWindowState=true</editorInputUsageOptions>
> <windowState height="594" version="1.0" width="856">
> <control height="181" isHideable="true" isVisible="true"
> name="SQLSourceViewer" width="829"/>
> <control height="192" isHideable="true" isVisible="true"
> name="DesignViewer" width="842"/>
> <control height="183" isHideable="true" isVisible="true"
> name="GraphControl" width="834"/>
> <control height="187" isHideable="true" isVisible="false"
> name="OutlineViewer" width="156"/>
> </windowState>
> </SQLQueryBuilder></property>
> </structure>
> <xml-property name="designerValues"><![CDATA[<?xml version="1.0"
> encoding="UTF-8"?>
> <model:DesignValues xmlns:design="(error about post having links...)"
> xmlns:model="(error about post having links...)">
> <Version>2.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>Dealer_State</design:name>
> <design:position>1</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>2</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>DEALER_STATE</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>DEALER_STATE</design:label>
> <design:formattingHints>
> <design:displaySize>2</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>Make</design:name>
> <design:position>2</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>128</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>MAKE</design:displayName>
> </design:uiHints>
> </design:attributes>
> Path: news.eclipse.org!not-for-mail
> From: jeyinul <forums-noreply@eclipse.org>
> Newsgroups: eclipse.birt
> Subject: =?utf-8?Q?Chart?=
> Date: Wed, 06 Jul 2011 07:16:16 -0400
> Organization: Eclipse Community Forums
> Lines: 2900
> Message-ID: <iv1fjs$7fu$1@news.eclipse.org>
> Reply-To: jeyinul <forums-noreply@eclipse.org>
> NNTP-Posting-Host: 172.30.206.107
> X-Trace: news.eclipse.org 1309950396 7678 172.30.206.107 (6 Jul 2011
> 11:06:36 GMT)
> X-Complaints-To: news@news.eclipse.org
> NNTP-Posting-Date: Wed, 6 Jul 2011 11:06:36 +0000 (UTC)
> X-FUDforum: c7ed4ca4d6a4ff3b73a07e2176df25fb <693383>
> User-Agent: FUDforum
> Xref: news.eclipse.org eclipse.birt:42656
>
> Hi All,
>
> i generate a report using cross tab and chart.
>
> But the count is different in cross tab and chart.
>
> In chart The count is not increasing more than 4.
>
> PFA.
>
> CROSS TAB IS IN FIRST PAGE.
> CHART IS IN SECOND PAGE.
>
> Please help me on this.
>
> Thanks,
> Jeyinul.
> begin 644 run.doc
> MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````"
> M````^```````````$```^@````$```#^____`````/8```#W````________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M_______________________LI<$`6X`)!```^!*_````````$```````"```
> MD`T```X`8FIB:JSZK/H````````````````````````)!!8`-,H``,Z0`0#.
> MD`$`904````````J``````````````````````````````#__P\`````````
> M``#__P\```````````#__P\``````````````````````+<``````.0%````
> M````Y`4``"<3````````)Q,````````G$P```````"<3````````)Q,``!0`
> M`````````````/____\`````.Q,````````[$P```````#L3```X````<Q,`
> M`$0```"W$P``M`(``#L3````````PQD``#`!``!K%@``*````),6````````
> MDQ8```````"3%@```````),6````````?A@```````!^&````````'X8````
> M````9AD```(```!H&0```````&@9````````:!D```````!H&0```````&@9
> M````````:!D```````#S&@``H@(``)4=``!&````:!D``!4`````````````
> M````````````)Q,```````!^&``````````````````````````````^&```
> M0````'X8````````?A@```````!^&````````&@9```````````````````G
> M$P```````"<3````````DQ8``````````````````),6``"K`0``?1D``!8`
> M```N&0```````"X9````````+AD```````!^&```6````"<3````````DQ8`
> M```````G$P```````),6````````9AD``````````````````"X9````````
> M````````````````````````````````````````````````````````````
> M````?A@```````!F&0``````````````````+AD``````````````````"X9
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````+AD```````"3%@``
> M`````/____\`````((Z1CLT[S`$``````````#L3````````UA@``%@````N
> M&0``````````````````4AD``!0```"3&0``,````,,9````````+AD`````
> M``#;'0```````"X9````````VQT````````N&0``````````````````````
> M````````````````````````````````````````````````````````````
> M`````````````````````-L=```````````````````G$P```````"X9```D
> M````?A@```````!^&````````"X9````````?A@```````!^&```````````
> M````````````````````````````````````````?A@```````!^&```````
> M`'X8````````:!D```````!H&0``````````````````````````````````
> M````````````````+AD`````````````````````````````````````````
> M`````````'X8````````?A@```````!^&````````,,9````````?A@`````
> M``!^&````````'X8````````?A@``````````````````/____\`````____
> M_P````#_____````````````````_____P````#_____`````/____\`````
> M_____P````#_____`````/____\`````_____P````#_____`````/____\`
> M````_____P````#_____`````/____\`````_____P````#_____`````-L=
> M````````?A@```````!^&````````'X8````````?A@```````!^&```````
> M`'X8````````````````````````````````````````````````````````
> M``````````````````````````!^&````````'X8````````?A@```````#D
> M!0``"0P``.T1```Z`0``!0`2`0``"00`````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M``````````````````````````````````````````````````````@3($E.
> M0TQ51$5024-455)%("!<9"`B=V]R9&UL.B\O-S4N<&YG(B!<*B!-15)'149/
> M4DU!5$E.150@%`$5#5!R;VIE8W0@3F%M90=*15E)3E5,(%-%0U522519(%-!
> M35!,12!415-424Y'!P<-1G)O;2!$871E(%-E;&5C=&5D!S`V+4IU;"TR,#$P
> M!U1O($1A=&4@4V5L96-T960',#8M2G5L+3(P,3$'!PU$969E8W0@36%N86=E
> M;65N="!297!O<G0@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
> M("`@("`@(%!224]22519("`-("`@("`@("`@("`@("`@("`@("`@(%194$4@
> M("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
> M("`@("`@(%-405154P=#<FET:6-A;`=(:6=H!TQO=P=-961I=6T'5$]404P'
> M!P<'!P<'!P<M("T'0VQO<V5D!RT'+0<M!RT'+0<'!T1E9F5R<F5D!RT'+0<M
> M!RT'+0<'!T9I>&5D!RT'+0<M!RT'+0<'!TYE=P<Q!RT'+0<M!S$'!P=/<&5N
> M!RT'+0<M!RT'+0<'!U)E+6]P96X'+0<M!RT'+0<M!P<'4F5J96-T960'+0<M
> M!RT'+0<M!P<'3E5,3"`@5$]404P',0<M!RT'+0<Q!P=#=7-T;VUE<B!297!O
> M<G1E9"!$969E8W0'0VQO<V5D!RT',0<M!RT',0<'!T1E9F5R<F5D!RT'+0<M
> M!S$',0<'!T9I>&5D!RT'+0<M!RT'+0<'!TYE=P<M!RT',0<M!S$'!P=/<&5N
> M!RT'+0<Q!S$',@<'!U)E+6]P96X'+0<M!RT'+0<M!P<'4F5J96-T960'+0<M
> M!RT'+0<M!P<'0W5S=&]M97(@4F5P;W)T960@1&5F96-T(%1/5$%,!RT',0<R
> M!S('-0<'26YT97)N86P@4F5V:65W($1E9F5C=`=#;&]S960'+0<M!RT',0<Q
> M!P<'1&5F97)R960',0<M!RT'+0<Q!P<'1FEX960'+0<M!RT',@<R!P<'3F5W
> M!RT'+0<Q!S$',@<'!T]P96X'+0<M!RT',@<R!P<'4F4M;W!E;@<M!RT'+0<M
> M!RT'!P=296IE8W1E9`<M!RT'+0<M!RT'!P=);G1E<FYA;"!2979I97<@1&5F
> M96-T(%1/5$%,!S$'+0<Q!S8'.`<'26YT97)N86P@5&5S=&EN9R!$969E8W0'
> M0VQO<V5D!RT'+0<M!RT'+0<'!T1E9F5R<F5D!RT'+0<M!RT'+0<'!T9I>&5D
> M!RT'+0<M!RT'+0<'!TYE=P<M!S$'+0<M!S$'!P=/<&5N!RT'+0<M!RT'+0<'
> M!U)E+6]P96X'+0<M!RT'+0<M!P<'4F5J96-T960',0<M!RT'+0<Q!P<'26YT
> M97)N86P@5&5S=&EN9R!$969E8W0@5$]404P',0<Q!RT'+0<R!P=,96=A8WD@
> M1&5F96-T!T-L;W-E9`<M!RT'+0<M!RT'!P=$969E<G)E9`<M!RT'+0<M!RT'
> M!P=&:7AE9`<M!RT'+0<M!RT'!P=.97<',0<M!S$',0<S!P<'3W!E;@<M!RT'
> M+0<M!RT'!P=292UO<&5N!S0'+0<Q!RT'-0<'!U)E:F5C=&5D!RT'+0<M!RT'
> M+0<'!TQE9V%C>2!$969E8W0@5$]404P'-0<M!S(',0<X!P=43U1!3`<X!S('
> M-0<Y!S(T!P<($R!)3D-,541%4$E#5%5212`@7&0@(G=O<F1M;#HO+S<V+G!N
> M9R(@7"H@34521T5&3U)-051)3D54(!0!%0T##0T$#0T##0T$#0T'!PT-#4IU
> M;"`V+"`R,#$Q(#0Z-#`@4$T-#0<'#0T-````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M```(```""```.P@``#X(```_"```2P@``$P(``!K"```;0@``&X(``"`"```
> M@0@``(P(``"-"```G0@``)X(``"I"```JP@``*P(``#W"```^`@``$T)``!.
> M"0``5@D``%<)``!;"0``7`D``%\)``!@"0``9@D``&<)``!L"0``;@D``'0)
> M``!U"0``>`D``'D)``!_"0``@`D``($)``"""0``@PD``(0)``"%"0``A@D`
> M`(<)``"("0``B0D``(L)``","0``E`D``)4)``"6"0``EPD``)@)``"9"0``
> MF@D``/?S]_/<\]SSU]SSW//<\]SSU\3SQ/.Q\['SL?.Q\\3SU_.>\X[SCO..
> M\X[SCO..\]>.\X[SCO..'Q9H#R^A`$(J`4]*`P!02@,`44H#`%Y*`P!P:```
> M```E%F@/+Z$`-0B!0BH!3TH#`%!*`P!12@,`7`B!7DH#`'!H`````"46:`\O
> MH0`U"(%"*@U/2@,`4$H#`%%*`P!<"(%>2@,`<&B`````)19H#R^A`#4(@4(J
> M"$]*`P!02@,`44H#`%P(@5Y*`P!P:/___P`)%F@U5@$`/`B!+19H#R^A`#4(
> M@4(J"$-*%@!/2@,`4$H#`%%*`P!<"(%>2@,`84H6`'!H____``86:#56`0``
> M#P-J`````!9H-58!`%4(`0`X``@``#\(``!,"```;`@``&T(``!N"```@0@`
> M`(T(``">"```J@@``/T```````````````#W````````````````[@``````
> M`````````($```````````````#]````````````````]P``````````````
> M`.X```````````````#W````````````````[@``````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````;0``:V1Y$@``%B0!%R0!268!`````I9L``0T`0C6,``"E/]?!Y0=
> M``;+!P@!`0`(`0$`"`$!``@!`0``!C46"`$!``@!`0`(`0$`"`$!``G6!$`!
> M@`$*=```X`$2UA0```#_`("`````````_X``@````!3V`P`>%_8#```:U@@`
> M`````````!O6"```````````'-8(```````````=U@@``````````#36!@`!
> M!0,``#36!@`!"@-L`&'V`P``930!<-84````_P"`@````````/^``(`````)
> M```#)`$6)`%)9@$```!A)`$&```6)`%)9@$``````0````FJ"```JP@``*P(
> M``#X"```+P```````````````"T````````````````G````````````````
> M```````````````````````````````&```6)`%)9@$``````0``T```:V09
> M$P``%B0!%R0!268!`````I9L``0T`076&!`!`0`0`0$`$`$!`!`!`0``````
> M``````C67``$E/\M#&$41Q\?*0`&F0P(`0$`"`$!``@!`0`(`0$```8T"`@!
> M`0`(`0$`"`$!``@!`0``!N8*"`$!``@!`0`(`0$`"`$!```&V`D(`0$`"`$!
> M``@!`0`(`0$`"=8(0`&``4`!@`$*=```X`$2UB@```#_`("`````````_X``
> M@````````/\`@(````````#_@`"`````$]8P`````!`!````````$`$`````
> M```0`0```````!`!``````#_`````````/\`````%/8#BRD7]@,``!K6$```
> M```````````````````;UA``````````````````````'-80````````````
> M`````````!W6$``````````````````````TU@8``04#```TU@8``0H#;`!A
> M]@,``&4T`7#6*````/\`@(````````#_@`"`````````_P"`@````````/^`
> M`(```````_@(``!."0``5PD``%P)``!@"0``9PD``&T)``!N"0``;PD``'`)
> M``!Q"0``<@D``',)``!T"0``]0```````````````.P```````````````#L
> M````````````````[````````````````.P```````````````#:````````
> M````````U0```````````````,\```````````````#/````````````````
> MSP```````````````,\```````````````#/````````````````SP``````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M``````````````````````8``!8D`4EF`0`````$``!&9J45````$0```R0!
> M%B0!+42``4EF`0```$W&"@```/^``(````!A)`$)```#)`$6)`%)9@$```!A
> M)`$*```3I`H`%*0*`!8D`4EF`0`````-=`D``'4)``!Y"0``*```````````
> M`````!\````````````````````````````````````````````````)```#
> M)`$6)`%)9@$```!A)`$`U@``:V2_%P``%B0!%R0!268!`````I9L``,T`00T
> M`076&!`!`0`0`0$`$`$!`!`!`0````````````C6B``&E/\>*,PR>CTH2-92
> M9%P@!I<=$`$!`!`!`0`0`0$`$`$!```&RP<(`0$`"@$0``H!$``*`1````;+
> M!P@!`0`*`1``"@$0``H!$```!LL'"`$!``H!$``*`1``"@$0```&RP<(`0$`
> M"@$0``H!$``*`1````;Y!@H!$``*`1``"@$0``H!$``)U@)``0IT``#@`1+6
> M"@```/\`@(`````3UC``````$`$````````0`0```````!`!````````$`$`
> M`````/\`````````_P`````4]@/07!?V`P``&M88````````````````````
> M``````#,S,P`&]88`````,S,S`#,S,P`S,S,`,S,S`#,S,P`'-88`````,S,
> MS`#,S,P`S,S,`,S,S`#,S,P`'=88`````,S,S`#,S,P`S,S,`,S,S`#,S,P`
> M--8&``$%`P``--8&``$*`VP`8?8#``!E-`%PU@H```#_`("```````)Y"0``
> M@`D``(()``"$"0``A@D``(@)``"*"0``^0```````````````/``````````
> M``````#P````````````````\````````````````/````````````````#P
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M```````````````````````````````````)```#)`$6)`%)9@$```!A)`$&
> M```6)`%)9@$`````!HH)``"+"0``%P``````````````````````````````
> M``````````````````#H``!K9/@8```6)`$7)`%)9@$````"EFP``S0!!=88
> M$`$!`!`!`0`0`0$`$`$!````````````"-:>``>4_V81'BC,,GH]*$C64F1<
> M8`8"#0@!`0`(`0$`"`$!``@!`0``!I40"@$0``H!$``*`1``"`$!```&RP<*
> M`1``"@$0``H!$``*`1````;+!PH!$``*`1``"@$0``H!$```!LL'"@$0``H!
> M$``*`1``"@$0```&RP<*`1``"@$0``H!$``*`1````;Y!@H!$``*`1``"@$0
> M``H!$``)U@(``0IT``#@`1+6"@```/____\````3UC``````$`$````````0
> M`0```````!`!````````$`$``````/\`````````_P`````4]@/07!?V`P``
> M&M8<`````,S,S`#,S,P`S,S,`,S,S`#,S,P`S,S,`!O6'`````#,S,P`S,S,
> M`,S,S`#,S,P`S,S,`,S,S``<UAP`````S,S,`,S,S`#,S,P`S,S,`,S,S`#,
> MS,P`'=8<``````````#,S,P`S,S,`,S,S`#,S,P`S,S,`#36!@`!!0,``#36
> M!@`!"@-L`&'V`P``930!<-8*````_____P`````!BPD``(P)``"5"0``EPD`
> M`)D)``";"0``G0D``)\)``#Y````````````````^0```````````````/``
> M``````````````#P````````````````\````````````````/``````````
> M``````#P````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````"0```R0!%B0!268!````820!!@``%B0!268!````
> M``>:"0``FPD``)P)``"="0``G@D``*`)``"A"0``I@D``*<)``"H"0``J0D`
> M`*H)``"K"0``K`D``*T)``"N"0``KPD``+`)``"R"0``LPD``+8)``"W"0``
> MN`D``+D)``"Z"0``NPD``+P)``"]"0``O@D``+\)``#`"0``P@D``,,)``#'
> M"0``R`D``,D)``#*"0``RPD``,P)``#-"0``S@D``,\)``#0"0``T0D``-,)
> M``#4"0``VPD``-P)``#="0``W@D``-\)``#@"0``X0D``.()``#C"0``Y`D`
> M`.4)``#G"0``Z`D``/`)``#Q"0``\@D``/,)``#T"0``]0D``/8)``#W"0``
> M^`D``/D)``#Z"0``_`D``/T)```("@``"0H```H*```+"@``#`H```T*```.
> M"@``#PH``!`*```1"@``$@H``!0*``#\[/SL_.?L_.S\[/SL_.S\[/SG[/SL
> M_.S\[/SL_.S\Y^S\[/SL_.S\[/SL_.?L_.S\[/SL_.S\[/SG[/SL_.S\[/SL
> M_.S\Y]3\U/S4_-3\U/S4_```````)19H#R^A`#4(@4(J"$]*`P!02@,`44H#
> M`%P(@5Y*`P!P:/___P`)%F@U5@$`/`B!'Q9H#R^A`$(J`4]*`P!02@,`44H#
> M`%Y*`P!P:``````&%F@U5@$`4Y\)``"@"0``%P``````````````````````
> M``````````````````````````#H``!K9$0:```6)`$7)`%)9@$````"EFP`
> M`S0!!=88$`$!`!`!`0`0`0$`$`$!````````````"-:>``>4_V81'BC,,GH]
> M*$C64F1<(`8"#0@!`0`(`0$`"`$!``@!`0``!I40"@$0``H!$``*`1``"`$!
> M```&RP<*`1``"@$0``H!$``*`1````;+!PH!$``*`1``"@$0``H!$```!LL'
> M"@$0``H!$``*`1``"@$0```&RP<*`1``"@$0``H!$``*`1````;Y!@H!$``*
> M`1``"@$0``H!$``)U@(``0IT``#@`1+6"@```/____\````3UC``````$`$`
> M```````0`0```````!`!````````$`$``````/\`````````_P`````4]@/0
> M7!?V`P``&M8<`````,S,S`#,S,P`S,S,`,S,S`#,S,P`S,S,`!O6'`````#,
> MS,P`S,S,`,S,S`#,S,P`S,S,`,S,S``<UAP`````S,S,`,S,S`#,S,P`S,S,
> M`,S,S`#,S,P`'=8<``````````#,S,P`S,S,`,S,S`#,S,P`S,S,`#36!@`!
> M!0,``#36!@`!"@-L`&'V`P``930!<-8*````_____P`````!H`D``*$)``"G
> M"0``J0D``*L)``"M"0``KPD``+$)``#Y````````````````^0``````````
> M`````/````````````````#P````````````````\````````````````/``
> M``````````````#P````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> Path: news.eclipse.org!not-for-mail
> From: <forums-noreply@eclipse.org>
> Newsgroups: eclipse.birt
> Subject: =?utf-8?Q?Re:=20Compare=20value=20in=20detail=20row?=
> Date: Wed, 06 Jul 2011 05:39:19 -0400
> Organization: Eclipse Community Forums
> Lines: 3
> Message-ID: <iv19u3$td$1@news.eclipse.org>
> References: <iuv97g$ib$1@news.eclipse.org>
> Reply-To: <forums-noreply@eclipse.org>
> NNTP-Posting-Host: 172.30.206.106
> Content-Type: text/plain; charset=utf-8; format=flowed
> X-Trace: news.eclipse.org 1309944579 941 172.30.206.106 (6 Jul 2011
> 09:29:39 GMT)
> X-Complaints-To: news@news.eclipse.org
> NNTP-Posting-Date: Wed, 6 Jul 2011 09:29:39 +0000 (UTC)
> X-FUDforum: c7ed4ca4d6a4ff3b73a07e2176df25fb <693339>
> User-Agent: FUDforum
> Xref: news.eclipse.org eclipse.birt:42655
>
> Thank you!
> This is the solution, it works.
> :)
Re: Can not load the report query: 160. Errors occurred when generating the report document for the [message #693702 is a reply to message #693684] Thu, 07 July 2011 03:29 Go to previous messageGo to next message
SGT. Smith is currently offline SGT. SmithFriend
Messages: 2
Registered: July 2011
Junior Member
It is BIRT 3.7.
Re: Can not load the report query: 160. Errors occurred when generating the report document for the [message #693785 is a reply to message #693702] Thu, 07 July 2011 08:12 Go to previous messageGo to next message
vijay kumar is currently offline vijay kumarFriend
Messages: 26
Registered: October 2010
Junior Member
Yesterday i have faced similar problem, then i remmoved the jar file from that location freshly copied. Agian i have defined new database connection. there u can test test connection. I hope this might help you.

Thank you.
Re: Can not load the report query: 160. Errors occurred when generating the report document for the [message #699209 is a reply to message #693613] Thu, 21 July 2011 05:16 Go to previous messageGo to next message
ToroTo  is currently offline ToroTo Friend
Messages: 2
Registered: July 2011
Junior Member
Hi,

I encounter the same problem in BIRT 3.7.
My report works perfectely in Eclipse. But, when I deploy the report.rptdesign on the tomcat server, in the web-viewer directory, and then execute the report, I receive the following message :

Can not load the report query: 9. Errors occurred when generating the report document for the report element with ID 9. (Element ID:9)

The mysql-connector-java-bin.jar file is in the /WEB-INF/lib directory !!!
I've removed/installed the connector a second time and deploy another report, but it doesn't fix my problem !!! Sad

Where can i find more informations ? Where are the BIRT logs ?
Thank you.
Re: Can not load the report query: 160. Errors occurred when generating the report document for the [message #699404 is a reply to message #699209] Thu, 21 July 2011 13:52 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Are you using the new 3.7 runtime? Did you update the runtime from an
earlier version or is this a new app? In the web.xml for the viewer you
can set the log level and log location. If you are using 3.7 runtime
viewer putting the driver in the web-inf/lib should work.

Jason

On 7/21/2011 1:16 AM, ToroTo wrote:
> Hi,
>
> I encounter the same problem in BIRT 3.7.
> My report works perfectely in Eclipse. But, when I deploy the
> report.rptdesign on the tomcat server, in the web-viewer directory, and
> then execute the report, I receive the following message :
> Can not load the report query: 9. Errors occurred when generating the
> report document for the report element with ID 9. (Element ID:9)
> The mysql-connector-java-bin.jar file is in the /WEB-INF/lib directory !!!
> I've removed/installed the connector a second time and deploy another
> report, but it doesn't fix my problem !!! :(
> Where can i find more informations ? Where are the BIRT logs ?
> Thank you.
Re: Can not load the report query: 160. Errors occurred when generating the report document for the [message #699612 is a reply to message #699404] Thu, 21 July 2011 22:47 Go to previous message
ToroTo  is currently offline ToroTo Friend
Messages: 2
Registered: July 2011
Junior Member
Hi Jason,

Thanks for your reply.
I am using the Latest BIRT Runtime Release Build: 3.7.0, it's not an upgrade from an earlier version.

I finaly find the source of my trouble !
Tomcat and Mysql are installed in a virtualbox machine and Eclipse is installed on the host.

In order to access the database on the guest from Eclipse, I had configured the Nat of the VM like this :
Name	Protocol	Host IP	 	Host Port 	Guest IP 	Guest Port
MySQL	TCP		127.0.0.1	3306		10.0.2.15	3306
Tomcat	TCP		127.0.0.1	8080		10.0.2.15	8080


where 10.0.2.15 is the IP address of my VM. But I also needed to change the parameter bind-address of the MySQL configuration file my.cnf with the ip address of the VM : 10.0.2.15.

As the report is now executed by the server, I change the bind-address parameter to 127.0.0.1 and the report runs perfectly. Very Happy

Now, I have to find a way to access MySQL from both the host and the guest. It seems that the bind-address parameter does not support more than one address. but This is another question for another forum.

Thanks again

[Updated on: Thu, 21 July 2011 22:49]

Report message to a moderator

Previous Topic:Auto Drill-Through
Next Topic:Validate input parameter in script
Goto Forum:
  


Current Time: Thu Nov 27 21:12:44 GMT 2014

Powered by FUDForum. Page generated in 0.01976 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software