How to catch error DBBC.

[Luis Cardozo]

Hi everyone,

I am doing a BPEL where I need to insert into SQL Server (2005) a new row, but when primary key is duplicated I need to catch that fault for to do a update with the same record.

I have used the DBBC wizard for create the wsdl.

Note: I found a message with same problem, but without solution. If exist the answer in any message posted, please post the link in this massage.

Best regards.

Luis

[Murali Pottlapelli]

Hi Luis,
You can add fault handler for SystemFault, refer to
http://wiki.open-esb.java.net/Wiki.jsp?page=UsingSystemFault. In the
fault handler add additional invoke, DB operation with modified data.

Regards
Murali

Luis Cardozo wrote:

> Hi everyone,
>
> I am doing a BPEL where I need to insert into SQL Server (2005) a new row,
> but when primary key is duplicated I need to catch that fault for to do a
> update with the same record.
>
> I have used the DBBC wizard for create the wsdl.
>
> Note: I found a message with same problem, but without solution. If exist
> the answer in any message posted, please post the link in this massage.
>
> Best regards.
>
> Luis
>
>  

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

[Luis Cardozo]

Hi Maruli,

I going to check the link posted.

Thanks.

Luis

Murali Pottlapelli wrote:

Hi Luis,
You can add fault handler for SystemFault, refer to
http://wiki.open-esb.java.net/Wiki.jsp?page=UsingSystemFault. In the
fault handler add additional invoke, DB operation with modified data.

Regards
Murali

Luis Cardozo wrote:
> Hi everyone,
>
> I am doing a BPEL where I need to insert into SQL Server (2005) a new row,
> but when primary key is duplicated I need to catch that fault for to do a
> update with the same record.
>
> I have used the DBBC wizard for create the wsdl.
>
> Note: I found a message with same problem, but without solution. If exist
> the answer in any message posted, please post the link in this massage.
>
> Best regards.
>
> Luis
>
>  

---------------------------------------------------------------------
To unsubscribe, e-mail: [e-mail]
For additional commands, e-mail: [e-mail]