|
|
|
|
Re: birt HSQL [message #628687 is a reply to message #627970] |
Thu, 23 September 2010 16:59 |
|
Uttam,
I seem to have lost the original thread. Did you post the log file for
this?
Jason
On 9/23/2010 4:07 AM, Uttam Ghosh wrote:
> Thanks for your reply.
>
> yes, The driver is in this directory
> eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_2.3.2.
> r232_v20090212\drivers
|
|
|
|
Re: birt HSQL [message #628901 is a reply to message #628783] |
Fri, 24 September 2010 16:38 |
|
Did the error come out of the log file? I assume this error is
happening when you are previewing the dataset? The error is complaining
about not finding the table. Can you verify the name and also I noticed
you did not specify a db like:
jdbc:mysql://localhost/mydb in the data source editor. Can you hit the
test connection button once you have entered a db?
Jason
On 9/24/2010 3:03 AM, Uttam Ghosh wrote:
> Plug-in Provider:Eclipse.org
> Plug-in Name:BIRT Data Engine
> Plug-in ID:org.eclipse.birt.data
> Version:2.3.0.v20080606
> Error Code:odaconsumer.CannotPrepareStatement
> Error Message:Failed to prepare the following query for the data set
> type org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet.
> [select *
> from PERSON_DETAILS]
> Error preparing SQL statement.
> SQL error #1: Table not found in statement [select *
> from PERSON_DETAILS]
|
|
|
|
Re: birt HSQL [message #629287 is a reply to message #629080] |
Mon, 27 September 2010 15:58 |
|
Uttam,
Can you open a bug for this? Do you know if there is another version of
the HSQL driver you could try?
Jason
On 9/27/2010 3:10 AM, Uttam Ghosh wrote:
> Thanks Jason
>
> yes , this error is happening when I am previewing the dataset.
> Also I verify the name and user_id and this is OK .
> You can see I specified a db like:jdbc:hsqldb:test
> and user is sa . When I hit the
> test connection button I can see "Connection successfum" message.
> Also i tried this report with mysql and this report is runing well with
> mysql.I am sending the same report with mysql which is OK.
> This is my data source ///////////////////////////// data source
> ///////////////////////////
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="6">
> <property name="odaDriverClass">org.hsqldb.jdbcDriver</property>
> <property name="odaURL">jdbc:hsqldb:test:</property>
> <property name="odaUser">sa</property>
> </oda-data-source>
> </data-sources>
> ///////////////////////////// end data source ///////////////////////////
>
>
>
> this is same report with Mysql which is OK.
>
>
> /////////// report with mysql///////////////////////////////
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.16"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.3.0.v20080606
> Build <2.3.0.v20080618-0630></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="6">
> <text-property name="displayName"></text-property>
> <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
> <property name="odaURL">jdbc:mysql://localhost/cce_mrinal</property>
> <property name="odaUser">root</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="7">
> <list-property name="columnHints">
> <structure>
> <property name="columnName">first_name</property>
> <property name="displayName">first_name</property>
> </structure>
> <structure>
> <property name="columnName">middle_name</property>
> <property name="displayName">middle_name</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">first_name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">middle_name</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">first_name</property>
> <property name="nativeName">first_name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">middle_name</property>
> <property name="nativeName">middle_name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> </list-property>
> <property name="queryText">SELECT first_name, middle_name
>
> FROM person_details</property>
> <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>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>first_name</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>50</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>first_name</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>first_name</design:label>
> <design:formattingHints>
> <design:displaySize>50</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>middle_name</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>50</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>middle_name</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>middle_name</design:label>
> <design:formattingHints>
> <design:displaySize>50</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="crosstab-cell" id="4">
> <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="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>
> </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>
> <table id="8">
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> <property name="width">100%</property>
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">first_name</property>
> <property name="displayName">first_name</property>
> <expression name="expression">dataSetRow["first_name"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">middle_name</property>
> <property name="displayName">middle_name</property>
> <expression name="expression">dataSetRow["middle_name"]</expression >
> <property name="dataType">string</property>
> </structure>
> </list-property>
> <column id="22"/>
> <column id="23"/>
> <header>
> <row id="9">
> <cell id="10">
> <label id="11">
> <text-property name="text">first_name</text-property>
> </label>
> </cell>
> <cell id="12">
> <label id="13">
> <text-property name="text">middle_name</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="14">
> <cell id="15">
> <data id="16">
> <property name="resultSetColumn">first_name</property>
> </data>
> </cell>
> <cell id="17">
> <data id="18">
> <property name="resultSetColumn">middle_name</property>
> </data>
> </cell>
> </row>
> </detail>
> <footer>
> <row id="19">
> <cell id="20"/>
> <cell id="21"/>
> </row>
> </footer>
> </table>
> </body>
> </report>
> ////////////////////////////////////////////////////////////
> ///////////////////////
|
|
|
|
Re: birt HSQL [message #630087 is a reply to message #629960] |
Thu, 30 September 2010 15:28 |
|
Did you open a bug for this?
Jason
On 9/30/2010 2:49 AM, Uttam Ghosh wrote:
>
> Thanks Jason
>
> Yes, also in tried with another version of
> the HSQL driver which is 1.8 but problem is same.
|
|
|
Powered by
FUDForum. Page generated in 0.03112 seconds