Eclipse Community Forums: BIRT » help: postgresql function Can't load the report query

Help

Home

Home » Eclipse Projects » BIRT » help: postgresql function Can't load the report query

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

help: postgresql function Can't load the report query [message #664310]

Fri, 08 April 2011 06:59

No real name
Messages: 4
Registered: April 2011

Junior Member

i use posgresql 9.0 and tomcat, and birt can display data set use select query, but when use function, it can't work, thows the error 'Can't load the report query'; and the report works fine in eclipse Preview. anyone have this problem?how can i do ?
thanks

Report message to a moderator

Re: help: postgresql function Can't load the report query [message #664400 is a reply to message #664310]

Fri, 08 April 2011 12:16

JulioC Missing name is currently offline

JulioC Missing name
Messages: 33
Registered: March 2011
Location: Ottawa, Canada

Member

What is the data source are u using?

Report message to a moderator

Re: help: postgresql function Can't load the report query [message #664456 is a reply to message #664400]

Fri, 08 April 2011 20:30

No real name
Messages: 4
Registered: April 2011

Junior Member

<oda-data-source extensionID="com.genuitec.eclipse.reporting.oda" name="Data Source" id="7">
<property name="meDriver">PostgreSQLDriver</property>
<property name="odaDriverClass">org.postgresql.Driver</property>
<property name="odaURL">jdbc:postgresql://127.0.0.1:5432/test</property>
<property name="odaUser">test</property>
<encrypted-property name="odaPassword" encryptionID="base64">dGhlcnA=</encrypted-property>
</oda-data-source>

Report message to a moderator

Re: help: postgresql function Can't load the report query [message #664458 is a reply to message #664456]

Fri, 08 April 2011 21:26

No real name
Messages: 4
Registered: April 2011

Junior Member

DataSet1 is OK, and DataSet is the problem

<oda-data-set extensionID="com.genuitec.eclipse.reporting.oda.SPDataSet" name="Data Set" id="8">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">id</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">id</property>
<property name="nativeName">id</property>
<property name="dataType">integer</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[{call test(1)}]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="com.genuitec.eclipse.reporting.oda.dataSet" name="Data Set1" id="85">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">id</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">id</property>
<property name="nativeName">id</property>
<property name="dataType">integer</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select *
from tb_test]]></xml-property>
</oda-data-set>

[Updated on: Fri, 08 April 2011 21:29]

Report message to a moderator

Re: help: postgresql function Can't load the report query [message #665059 is a reply to message #664458]

Wed, 13 April 2011 03:23

No real name
Messages: 4
Registered: April 2011

Junior Member

ok, i find the solution, postgresql funtion is not sp, so SPDataSet is out of work, and i write the sql select *
from test() in the xml using com.genuitec.eclipse.reporting.oda.dataSet, and it's ok. but eclipse designer can't support "()" in select query , i modified the xml directly.

Report message to a moderator

Previous Topic:	Correct way to specify rowFetchSize
Next Topic:	Formatting seconds in Y axis to DD:HH:mm:ss

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 03:14:54 EDT 2013