Eclipse Community Forums: BIRT

Help

Home

Home » Eclipse Projects » BIRT » birt HSQL

Show: Today's Messages :: Show Polls :: Message Navigator

birt HSQL [message #560067]

Tue, 21 September 2010 02:36

Uttam Ghosh
Messages: 39
Registered: July 2009

Member

Hi
I created a report using birt 2.3 and hsql .

database connection is successful but when i am trying to run this report
the error is occur. Please reply my
this is the error
///// error///////////////////////

A BIRT exception occurred.
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]
///////////////////////////////

////////////////////////////////this is my simple report.///////////////////////////////////////////
<?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">
<property name="odaDriverClass">org.hsqldb.jdbcDriver</property>
<property name="odaURL">jdbc:hsqldb:test:</property>
<property name="odaUser">sa</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">
<structure name="cachedMetaData"/>
<property name="dataSource">Data Source</property>
<property name="queryText">select *
from PERSON_DETAILS</property>
<xml-property name="designerValues"><![CDATA[]]></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>
</report>
//////////////////////////////////////////////////////////// //////

Report message to a moderator

Re: birt HSQL [message #560068 is a reply to message #560067]

Tue, 21 September 2010 02:38

Uttam Ghosh
Messages: 39
Registered: July 2009

Member

No Message Body

Report message to a moderator

Re: birt HSQL [message #560225 is a reply to message #560067]

Tue, 21 September 2010 11:23

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Is your driver in this directory?
eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_2.3.2. r232_v20090212\drivers

Jason

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: birt HSQL [message #627970 is a reply to message #560225]

Thu, 23 September 2010 04:07

Uttam Ghosh
Messages: 39
Registered: July 2009

Member

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

Report message to a moderator

Re: birt HSQL [message #628687 is a reply to message #627970]

Thu, 23 September 2010 12:59

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: birt HSQL [message #628783 is a reply to message #628687]

Fri, 24 September 2010 03:03

Uttam Ghosh
Messages: 39
Registered: July 2009

Member

Thanks Jason
This is the log and the rptdesign file

///// error///////////////////////

A BIRT exception occurred.
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]
///////////////////////////////

////////////////////////////////this is my simple report.///////////////////////////////////////////
<?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">
<property name="odaDriverClass">org.hsqldb.jdbcDriver</property>
<property name="odaURL">jdbc:hsqldb:test:</property>
<property name="odaUser">sa</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">
<structure name="cachedMetaData"/>
<property name="dataSource">Data Source</property>
<property name="queryText">select *
from PERSON_DETAILS</property>
<xml-property name="designerValues"><![CDATA[]]></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>
</report>
//////////////////////////////////////////////////////////// //////

Report message to a moderator

Re: birt HSQL [message #628901 is a reply to message #628783]

Fri, 24 September 2010 12:38

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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]

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: birt HSQL [message #629080 is a reply to message #628901]

Mon, 27 September 2010 03:09

Uttam Ghosh
Messages: 39
Registered: July 2009

Member

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>
//////////////////////////////////////////////////////////// ///////////////////////

Report message to a moderator

Re: birt HSQL [message #629287 is a reply to message #629080]

Mon, 27 September 2010 11:58

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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>
> ////////////////////////////////////////////////////////////
> ///////////////////////

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: birt HSQL [message #629960 is a reply to message #629287]

Thu, 30 September 2010 02:49

Uttam Ghosh
Messages: 39
Registered: July 2009

Member

Thanks Jason

Yes, also in tried with another version of
the HSQL driver which is 1.8 but problem is same.

Report message to a moderator

Re: birt HSQL [message #630087 is a reply to message #629960]

Thu, 30 September 2010 11:28

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:	reset pagenumber on group without interval
Next Topic:	How to use caching in BIRT Jsp Page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 10:21:56 EDT 2013