Restrict number of business processes

[Former Member]

Hi everybody

Can some one give a hint on how to restrict the start of a business process. I have a JDBC Adapter configured, which is pooling every minute on a small table. A soon as certain entry a given by the polled message a business process starts. I would like to avoid that during the processing of the business process the next polling sequence is starting the next buisness process, because it could be that the next one accesses the same data.

I belive this question is not new, but obviously my search criteria are not sufficient to find the answere in the forum. ;->>

Regards Oliver

[MichalKrawczyk · Accepted solution]

Hi,

don't you think you need to recreate your JDBC query?

do you use update statement (in the JDBC sender adapter)

to make sure that:

>>>>because it could be that the next one accesses the same data.

this does not happen?

Regards,

michal

[Former Member · Accepted solution]

Hi,

If you have a flag that can be updated in your table then you can used the Update SQL statement to update the flag in your sender JDBC adapter.

Regards

Vijaya

[Former Member]

Using a table entrie or a file where the status for a certain process can be read solved the problem.

[bhavesh_kantilal]

Hi Oliver,

You can use the Update Statement of the sender JDBC adapter right?

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Also, you can use the Transaction handling of your Sender JDBC adapter. Try SERIALIZABLE.

regards,

bhavesh