| New ODA Datasource [message #76830] |
Fri, 23 September 2005 15:00  |
Eclipse User |
|
|
|
Originally posted by: peter.fopma.ifbag.com
I am trying to develop a new datasource using ODA. Modifying the
flatfile example already yields interesing and useful results.
Getting really exited about these first successful steps
I took a look at the interfaces which are probably needed to
use stuctured datasets IParameterRowSet and IAdvancedQuery and
my understanding of ODA slowly crumbled to nothing...
Could someone point out to me how the input/output parameters
fitt in with the IQuery and IAdvancedQuery? Careful interpretation
of the term input parameter and Query reminds me of what I saw
in a SQL Datasets where a parameter could be inserted in a SQL
statement. OK... but what about output parameters? I have no
imagination how output parameters could be set (neither scalar nor
structure) or how this could be visualized in Eclipse or how
this could be used in a report...
Sorry for my limited imagination any help is appreciated.
An example using the mentioned interfaces is probably to much to
hope for - on the other hand, someone designed this stuff!?
Thanks for your help
Peter
|
|
|
| Re: New ODA Datasource [message #85093 is a reply to message #76830] |
Fri, 28 October 2005 00:16  |
Linda Chan
Messages: 845
Registered: July 2009 |
Senior Member |
|
|
Hi Peter,
>> how the input/output parameters fit in with the IQuery and
IAdvancedQuery?
The ODA IQuery is designed to handle scalar input parameters, which is
common in most query syntax. IAdvancedQuery is designed to handle more
advanced query features, including output parameters and any structured
input/output parameters. Output parameters are common in SQL stored
procedures. Complex/structured parameters are found in some data
sources, such as a SAP R/3 BAPI. Thus the IAdvancedQuery has interface
methods to access the values of output parameters.
So if your custom ODA driver's is designed to access an underlying data
source that do not support these advanced query features, you do not
need to implement IAdvancedQuery. The IConnection.newQuery method may
return an IQuery or an IAdvancedQuery instance, based on the given
dataSetType.
The latest source in the org.eclipse.birt.report.data.oda.jdbc project
has the example of implementing IAdvancedQuery to support scalar output
parameters.
>>how output parameters could be set (neither scalar nor structure) or
how this could be visualized in Eclipse or how this could be used in a
report?
Your custom ODA driver would assign the value of the output parameters
after a query is executed. An ODA consumer application, such as BIRT,
would retrieve the output parameters' values using the getter methods in
IAdvancedQuery from an ODA run-time driver.
BIRT 2.0 will add support of binding an output parameter to a report
data item, plus script access to the output parameters' values.
Please see the spec in BIRT wiki web page:
http://eclipse.org/birt/wiki/index.php?n=BPS.BPS24
Linda
------------------------
Peter Fopma wrote:
> I am trying to develop a new datasource using ODA. Modifying the
> flatfile example already yields interesing and useful results.
>
> Getting really exited about these first successful steps
> I took a look at the interfaces which are probably needed to
> use stuctured datasets IParameterRowSet and IAdvancedQuery and
> my understanding of ODA slowly crumbled to nothing...
>
> Could someone point out to me how the input/output parameters
> fitt in with the IQuery and IAdvancedQuery? Careful interpretation
> of the term input parameter and Query reminds me of what I saw
> in a SQL Datasets where a parameter could be inserted in a SQL
> statement. OK... but what about output parameters? I have no
> imagination how output parameters could be set (neither scalar nor
> structure) or how this could be visualized in Eclipse or how
> this could be used in a report...
>
> Sorry for my limited imagination any help is appreciated.
> An example using the mentioned interfaces is probably to much to
> hope for - on the other hand, someone designed this stuff!?
>
> Thanks for your help
> Peter
|
|
|
Powered by
FUDForum. Page generated in 0.03048 seconds
] 
Search
Help
Register
Login
Home
