Unable to get extended properties for stored procedure.

[akshy_harale]

Hi,

I need to do some decision making in the translator based on the stored procedure parameters and resultset.

My stored procedure getSomeInfo(?,?) takes two int type parameters and returns resultset with two columns.

For that, I have applied extended properties(unitName="Meter",unitType="Length") on stored procedure's ' IN parameters'  and 'Resultset columns' for source model using Teiid designer.

I am able to get the applied extended properties on resultset columns of procedure in the custome translator's RuntimeMetadata object.

I am using following code to get the properties :

Map<String, String> properties = procedureParameter.getProperties();

However I am not able get properties applied on those two input parameters at translator level.

Wanted to know if theres a way to get those properties.

Thanks,

Akshay.

[rareddy]

"IN" and "RETURN" are both parameters on the Procedure object. So, it should be same in accessing their properties.

[shawkins]

Can you attach a vdb so that we can validate the metadata?

Steve

[akshy_harale]

Hi Steve,

I have attached vdb file to the main thread.

Thanks,

Akshay

[shawkins]

On your source model I see a getEntity procedure with an IN ID parameter, but in the xmi file I don't see any properties associated with it.  What name value pairs should be on there?  If you save your model and restart eclipse does it still have extensions associated with the in parameter?

Steve

[akshy_harale]

Hi Steve,

Thanks for your quick reply. I was able to get this problem resolved.

Akshay.