|
Home > Archive > BizTalk Server Orchestration > September 2005 > Problem with SOAP and SQL adapters
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 |
Problem with SOAP and SQL adapters
|
|
|
| Hi Everyone,
I have faced a problem in a very simple situation. I have stored which
creates new item:
CREATE PROCEDURE CreateItem
(
@ItemID int out,
@Name varchar(50)
)
AS
....
@ItemID returns id of a newly created item.
I need to call this stored from BizTalk orchestration and get new ID. I
have tried 2 ways to achieve this:
1) SQL Adapter.
The problem is that the output parameter @ItemID is not shown when you
use "Add Generated Schema" wizard. So it is impossible to generate
the schema for SQL adapter and use it for storeds with output
parameters. Is it true?
2) SOAP adapter.
I have exposed this stored as a Web Service through SQLXML. And it's
ok it can be called. But in this case the problem is to path NULL value
to parameter (i.e. @Name). I don't have "NameSpecified" property
in web service request message part.
When I set "Name" part to null in assignment I get the following
error during execution of orchestration:
The part 'Name' of message ' CreateItemRequest' contained a null value
at the end of the construct block.
Exception type: NullPartException
Source: Microsoft.XLANGs.Engine
Target Site: Void ConstructionCompleteEvent()
It's strange, because it works this way when I call service from .Net
Studio. Is it a bug in SOAP adapter?
Thank you in advance.
| |
|
| Hi
SQL adapter:
----------------
To Generate Schema for your SP,
Did you use this key word " xml auto ,xmldata" in your select statement
Check that
Thanks
B
"Phil" wrote:
> Hi Everyone,
>
> I have faced a problem in a very simple situation. I have stored which
> creates new item:
>
> CREATE PROCEDURE CreateItem
> (
> @ItemID int out,
> @Name varchar(50)
> )
> AS
> ....
>
> @ItemID returns id of a newly created item.
>
> I need to call this stored from BizTalk orchestration and get new ID. I
> have tried 2 ways to achieve this:
>
> 1) SQL Adapter.
> The problem is that the output parameter @ItemID is not shown when you
> use "Add Generated Schema" wizard. So it is impossible to generate
> the schema for SQL adapter and use it for storeds with output
> parameters. Is it true?
>
> 2) SOAP adapter.
> I have exposed this stored as a Web Service through SQLXML. And it's
> ok it can be called. But in this case the problem is to path NULL value
> to parameter (i.e. @Name). I don't have "NameSpecified" property
> in web service request message part.
>
> When I set "Name" part to null in assignment I get the following
> error during execution of orchestration:
>
> The part 'Name' of message ' CreateItemRequest' contained a null value
> at the end of the construct block.
>
> Exception type: NullPartException
> Source: Microsoft.XLANGs.Engine
> Target Site: Void ConstructionCompleteEvent()
>
> It's strange, because it works this way when I call service from .Net
> Studio. Is it a bug in SOAP adapter?
>
>
>
> Thank you in advance.
>
>
| |
|
| Actually, I don't have any select statement in my stored proc. I just
call another stored to obtain new id and then perform insertion.
The problem is that the output parameter is not even seen in the wizard
and it fails to generate correct request to sp. I can finish wizard
only if I specify default value for the out parameter, but in this case
the out parameter doesn't appear in generated schema.
So I don't understand how to use such storeds with SQL adapter.
| |
| Tom Fry 2005-09-07, 5:52 pm |
| Phil, did you ever resolve this? and if yes how so?
"Phil" wrote:
> Actually, I don't have any select statement in my stored proc. I just
> call another stored to obtain new id and then perform insertion.
>
> The problem is that the output parameter is not even seen in the wizard
> and it fails to generate correct request to sp. I can finish wizard
> only if I specify default value for the out parameter, but in this case
> the out parameter doesn't appear in generated schema.
>
> So I don't understand how to use such storeds with SQL adapter.
>
>
|
|
|
|
|