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 shekhar,

U are rite, u will get only

<update_count></update_count>

<insert_count></insert_count>

in your response message if you use INSERT_UPDATE.

B'cos this action basically will tell you whether yoour record has been successfully inserted or updated.

If successfully updated the value inside update_count will be 1 and insert_count is set to 0. similarly if the record is inserted the value insert_count will be 1 and update_count will be set to 0.

U will get <delete_count> in response only when you map "delete " to action attribute.

Hope this helps you.

cheers,

Siva Maranani.

[Former Member]

Hi Siva ,

Thanks for the reply.

So i have to do one more mapping for delete operation rite ?

Regards,

sekhar.

[Former Member]

Hi sekhar,

But why do you need a delete_count when u are performing a insert/update operation. delete_count is obtained in response when you are actually mapping the action attribute -- "DELETE".

Let me know why do u need another mapping..?

cheers,

Siva Maranani.

[Former Member]

Hi Siva,

I did not use another mapping.

In my scenario , I am creating (Creating,updating ,deleting) the sales orders.Before that i need to perform operations in Global Data Store.

So my scenario is(DataBase--Global Data Store -- SAP).

For this scenario i have to do compensation.so first i am storing the data in the temporary table. I am catching the response.I am only catching two responses (update,insert) if i put UPDATE_INSERT. I am catching one response (delete) if i put DELETE in a single map.

But I have to check the condition Before Call goes to SAP. After successful transmission,the data is moving from temporary table to Main table.

Any ideas about catching response from data base ?

Thanks,

sekhar.

[Former Member]

Hi,

The response should be like

<messagetype_<b>response</b>>

<statement<b>_response</b>>

<row>

<XYZ<b>_count</b>>

</row>

</statement_<b>response</b>>

<messagetype_<b>response</b>>

When a request is sent to DB, the response from the DB has a different kind of message structure, like the one mentioned above. So u need to perform 2 message mappings..

1 request mapping (source-->RequestDB)

1 response mapping (Response DB-->target)

and 1 interface mapping in which you will select your request and response message mappings.

U can refer to my weblog to look at the response message in synchronous case.

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

If u can post you scenario in detail i can help you more.

Cheers,

Siva Maranani.

[Former Member]

Hi Siva,

My scenario is DataBase to GlobalDataStore (DataBase). If the data is successfully entered in the GDS then I have to send the same data to SAP to create/update/delete the salesorder.

For this(DataBase to GDS ) I created request mapping and response mapping like which u have suggested. I am catching that response(Here is the issue...).And I am checking the condition before sending to the SAP in BPM.

isssue : I am catching the update_count and insert_count if i use UPDATE_INSERT action in reuest mapping by using one message type.

For delete action shall i use another message type ?

Because I am sending the status(create/update/delete) to the database in only one map.

[Former Member]

Hi sekhar,

Yes u are rite. For Delete action, u should use another message type.

let me know if this helps. (did ur multiline problem got solved..?)

Cheers,

Siva Maranani.

[Former Member]

Hi Siva & Sudir,

My problem was solved regarding response from the data base.Thanks for u r help.

Siva : till now i am working on these issues.Still I have to work on that multiple line items issue.

I am using parent & child relationship here.

I am taking the Id as a key in the parent & child also.So it did not accept multiple line items in child table.

k i have to take another filed as primary key in the child table right ?

After that i have to accept muliple items and split those items which is shown in ur weblog.

Can u please guide me some step by step procedure to this issue.Because I am using Graphical mapping here and i have to include those steps in BPM.

Thanks,

sekhar.

[Former Member]

Hi,

Nice to hear that your DB Probelm is solved. )

Cheers,

Siva Maranani.

[Former Member]

Hi Siva,

i'm tring to setup an scenario similar as you explain there

RFC (sync) -- XI -- (sync) DB

i cant get the response on my rfc function but yes it's working the insert on the DB. and when i go to the sxmb_moni i didnt see nothing.

any idea?

thanks