|
Home > Archive > BizTalk Server General > July 2005 > Sql Adapter
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]
|
|
| kailux4 2005-07-13, 6:00 pm |
| i am using sql adapter to insert a row in the database, for this i am calling
a
stored proc. In my orchestration i want to catch primary key violation
error. What type of error should i catch.
Currently i am catching Delivery failure exception in the exception
handler block and sendind and Ack to file directory, but it seems my
orchestration doesnt catch that exception, i have set notification to
transmitted
Thanks
| |
| Michel Prévost 2005-07-13, 6:00 pm |
| You can catch a Sytem.Data.SqlClient.SqlException. I have done this in a
project and it works fine.
"kailux4" <kailux4@discussions.microsoft.com> wrote in message
news:A7F7AC32-7AD8-446F-9FE6-04C1590539B4@microsoft.com...
>i am using sql adapter to insert a row in the database, for this i am
>calling
> a
> stored proc. In my orchestration i want to catch primary key violation
> error. What type of error should i catch.
>
> Currently i am catching Delivery failure exception in the exception
> handler block and sendind and Ack to file directory, but it seems my
> orchestration doesnt catch that exception, i have set notification to
> transmitted
> Thanks
| |
| kailux4 2005-07-14, 5:51 pm |
| Hi Michel,
now i have got some other issues
i have a store proc that insert a row in the table and return different
success/error code.
insert into x table
Select @Status for xml raw
To handle this i have added scope shape with LR transaction and sync
prop=false. inside scope i have request and response shape(conected to
req-response port).
Things work fine when when i send a proper record and i get response back
from
store proc. But if i send duplicate record, my orchestration give error at
response shape( of Request-respose port) and error is of type xlang instead
of primary key violation error. My response shape is talking message of type
XmlDocument
i tried setting both options for delivery notification
I dont know how request-response/solicit-response will work in case of error
occoured
what i want to do is, if everything is proper, send success message
but incase or error, i want to return error code, like PK Violation/Server
down etc,
Can any one help
"Michel Prévost" wrote:
> You can catch a Sytem.Data.SqlClient.SqlException. I have done this in a
> project and it works fine.
>
> "kailux4" <kailux4@discussions.microsoft.com> wrote in message
> news:A7F7AC32-7AD8-446F-9FE6-04C1590539B4@microsoft.com...
>
>
>
|
|
|
|
|