DataBase Response

[Former Member]

Hi all,

I am working on the following scenario Jdbc to Jdbc. I am successfully sending the data to the detination.Jdbc is asynchronous application. But I want the response whether it is success or failure.

Could anybody please suggest the steps?

Thanks & Regards ,

sekhar.

[Former Member]

Hi,

As sasi suggested, you cannot use know whether the records have been successfully processed or not in an asynchronous case.

1)If your DB channel process in asynchronous mode:

Usage of Transport level acknowledgements in BPM. Refer to the blog... how to setup trasport level acknowledgements. /people/siva.maranani/blog/2005/03/01/usage-of-transport-level-acknowledgements

2) If your DB channel process in synchronous mode:

Use the response message to look if the record have been successfully processed.

<update_count>count</update_count>

<insert_count>count</insert_count>

<delete_count>count</delete_count>

Cheers,

Siva Maranani.

[Former Member]

Hi Siva ,

Thanks for the reply.

But I am getting only <update_count>count</update_count>

<insert_count>count</insert_count> as a response. I did not get delete count. I used Update_Insert in the action.

Is there anyother option ?

Thanks & Regards,

sekhar.