Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » help: postgresql function Can't load the report query
help: postgresql function Can't load the report query [message #664310] Fri, 08 April 2011 10:59 Go to next message
No real name is currently offline 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
Re: help: postgresql function Can't load the report query [message #664400 is a reply to message #664310] Fri, 08 April 2011 16:16 Go to previous messageGo to next message
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?
Re: help: postgresql function Can't load the report query [message #664456 is a reply to message #664400] Sat, 09 April 2011 00:30 Go to previous messageGo to next message
No real name is currently offline 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>
Re: help: postgresql function Can't load the report query [message #664458 is a reply to message #664456] Sat, 09 April 2011 01:26 Go to previous messageGo to next message
No real name is currently offline 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: Sat, 09 April 2011 01: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 07:23 Go to previous message
No real name is currently offline 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.
Previous Topic:Correct way to specify rowFetchSize
Next Topic:Formatting seconds in Y axis to DD:HH:mm:ss
Goto Forum:
  


Current Time: Thu Oct 02 08:25:15 GMT 2014

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

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