How to catch error DBBC.

3 messages Options
Embed this post
Permalink
Luis Cardozo

How to catch error DBBC.

Reply Threaded More More options
Print post
Permalink
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

Re: How to catch error DBBC.

Reply Threaded More More options
Print post
Permalink
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

Re: How to catch error DBBC.

Reply Threaded More More options
Print post
Permalink
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: users-unsubscribe@open-esb.dev.java.net
For additional commands, e-mail: users-help@open-esb.dev.java.net