Scenario: Problem in JDBC to JDBC

[Former Member]

Hi Everybody,

we are developing one scenario JDBC to JDBC.

Steps:

1. Fetch the records from third party data base table using JDBC adapter. based on select query in the sender JDBC adapter, it will retrieve those records.

2. sending the data to RFC and based on RFC response we are updating the status in the third party system table.

MY PROBLEM IS:

Based on RFC response, for each error record we have to send a mail to user with error message and resubmission URL.

We are generating the resubmission URL using message ID(GUID).

Using resubmission URL user will resubmit the message again.

when I execute my select statement in JDBC SENDER adapter , it is returing multiple records and generating one MESSAGE ID(GUID).

For each record we have to generate seperate message ID, so that we can generate the resubmission URL.

but it should be in the same polling interval.

Please provide some solution to achieve this scenario.

Regards,

Venkata Narayana

[Former Member]

Hi !

I'm not sure if the current strategy is the best to solve your problem. To generate one message ID per row, just use a "SELECT TOP 1 xxxxxx" query statement to retrieve only 1 record per query. Of course it could cause too much overhead, maybe you can create your own ID for the URL. By the way, do you need that the ID to be the GUID? why?

Regards,

Matias.

ps: please award points if helpful