JDBC Adaptor problem

[swatantra_vijay3]

Hi

I am doing JDBC-RFC-JDBC Scenario without BPM with quality of service BE.

In this, JDBC sender adaptor is updating the table1 with sent flag = 'X'. Now the prob is the receiver adaptor is also upadting table1 with some data and here it is hanging . Is JDBC sender adaptor locks the table1 till the whole cycle is completed or there is another reason?????? If it likes that how to solve this

Thanks in advance

Regards

Vijay

[jens_schmid4]

Hi.

JDBC is a synchronous adapter. I would use a BPM scenario and have a synchronous-asynchronous bridge from JDBC to RFC and back. This would ensure that your JDBC part isn't locked.

Another question will be on how you will trigger the JDBC sender adapter. It might be more adviceable to use a JDBC receiver one.

Cheers.

[bhavesh_kantilal]

What is the error that you are getting.?

Just for test purposes, in the Sender JDBC adapter, select Advanced Mode --> Database Transaction Level and select option --> None.

Regards

Bhavesh

PS : The setting described above should never be tried on a production environment.