Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 122194

Summary: Support native named parameters of an ODA driver at runtime
Product: z_Archived Reporter: jluo <jluo>
Component: BIRTAssignee: Linda Chan <lchan>
Status: RESOLVED FIXED QA Contact:
Severity: enhancement    
Priority: P3 Keywords: plan
Version: 2.0.0   
Target Milestone: 2.2.1   
Hardware: PC   
OS: Windows 2000   
Whiteboard:
Bug Depends on: 177266    
Bug Blocks:    

Description jluo CLA 2005-12-27 22:35:33 EST 
Sometimes oda driver will return parameter name when parameter is used, such as stored procedure in oda.jdbc. In data engine, it needs to know the parameter name information to display.

Two things needs to be done:
1) Add the method of getParameterName in IParameterMetaData of ODA
2) Change oda consumer to support this feature in consumer layer.
Comment 1 jluo CLA 2005-12-27 22:38:01 EST 
See bug122079.
Comment 2 Linda Chan CLA 2005-12-27 23:27:38 EST 
This feature would be a nice enhancement to have.
Though BIRT oda data set element, per the design intention behind the ROM Data spec, does not currently expect to use the parameter name this way.  
BIRT currently intends to use an oda data set parameter name as a user-defined parameter hint (specific to a BIRT report design element), and is for use in a name-to-position mapping.  That would have to change as well as part of this enhancement.
Comment 3 jluo CLA 2005-12-27 23:33:07 EST 
I am not sure whether there is need to change the inner implemenation of oda consumer. Currently what we only want to get is the parameter name from IParameterMetaData.
Comment 4 Linda Chan CLA 2005-12-28 15:44:38 EST 
We do need the changes I'd mentioned.  Once the underlying ODA driver's parameter name is exposed to an oda consumer application like BIRT, the consumer should treat this name as so, i.e. not just a user-defined name for a parameter name-to-position mapping, which is what BIRT does now.

So there may be changes in the public API of some BIRT components as well.  I will identify them when this is being worked on.
Comment 5 Wenfeng Li CLA 2006-03-07 21:52:05 EST 
defer to future since bug122079 is the client of this enhancement.  Need at least a client to make API changes.
Comment 6 Linda Chan CLA 2007-06-29 18:06:25 EDT 
The first item in the original description
1) Add the method to get parameter name in IParameterMetaData of ODA is delivered in DTP 1.5 and BIRT 2.2 (bug 177266).

Renamed the bug description to focus on the remaining item of
2) Change BIRT Data Engine to use a native named parameter at runtime
Comment 7 Linda Chan CLA 2007-08-27 22:25:40 EDT 
When interacting with an ODA runtime driver, the BIRT data engine odaconsumer now supports referencing a data set query parameter by its ODA driver-defined name.  This feature is triggered only if a data set parameter has no position defined (value <= 0), and "named parameters" is supported by the underlying ODA runtime driver.
(Note that the BIRT oda.jdbc driver does not currently support named parameters.)