|
Home > Archive > BizTalk Server Orchestration > March 2005 > SQL Adapter response map is empty
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Adapter response map is empty
|
|
|
| I have a SQL Adapter which looks up two values from a database table. The SQL
Adapter uses a stored procedure.
From HAT I saved the received message (from the SQL Adapter), from which I
can see the correct values are selected (val1 and val2).
<ResApplValues xmlns="http://SQLApplValues">
<Schema name="Schema1" xmlns="urn:schemas-microsoft-com:xml-data"
xmlns:dt="urn:schemas-microsoft-com:datatypes">
<ElementType name="u" content="empty" model="closed">
<AttributeType name="Value1" dt:type="string" />
<AttributeType name="Value2" dt:type="string" />
<attribute type="Value1" />
<attribute type="Value2" />
</ElementType>
</Schema>
<appltable xmlns="x-schema:#Schema1" Value1="val1" Value2="val2" />
</ResApplValues>
In the orchestration, after receiving the above message, I map to the schema
I need to return from my orchestration. Its a pretty simple map (1:1). In the
Map designer I see the Value1 and Value2 attributes of the appltable node as
expected.
But the map does not fill in any values - I simply end up with an empty
message to return (send) from the orchestration.
Can anyone tell me why?
| |
|
| Got it...
Did two things:
1.
Removed the XMLDATA from the stored procedure after schema was generated
2.
Used the generated port type instead of creating a new when adding the port
to the stored procedure.
"Søren" wrote:
> I have a SQL Adapter which looks up two values from a database table. The SQL
> Adapter uses a stored procedure.
>
> From HAT I saved the received message (from the SQL Adapter), from which I
> can see the correct values are selected (val1 and val2).
>
> <ResApplValues xmlns="http://SQLApplValues">
> <Schema name="Schema1" xmlns="urn:schemas-microsoft-com:xml-data"
> xmlns:dt="urn:schemas-microsoft-com:datatypes">
> <ElementType name="u" content="empty" model="closed">
> <AttributeType name="Value1" dt:type="string" />
> <AttributeType name="Value2" dt:type="string" />
> <attribute type="Value1" />
> <attribute type="Value2" />
> </ElementType>
> </Schema>
> <appltable xmlns="x-schema:#Schema1" Value1="val1" Value2="val2" />
> </ResApplValues>
>
> In the orchestration, after receiving the above message, I map to the schema
> I need to return from my orchestration. Its a pretty simple map (1:1). In the
> Map designer I see the Value1 and Value2 attributes of the appltable node as
> expected.
>
> But the map does not fill in any values - I simply end up with an empty
> message to return (send) from the orchestration.
>
> Can anyone tell me why?
>
|
|
|
|
|