JDBC to PROXY Sync Scenario
I am facing an issue during JDBC to Proxy sync scenario. In Sandbox, JDBC to RFC sync scenario is working fine, but in Dev (JDBC to Proxy sync scenario without BPM), the JDBC Sender CC is trying to pick data from DB but no processing happens. Instead, the JDBC Snd CC is locking that particular record. If we try to modify that particular record from db level, we are getting ORA-00054 error as the table is getting locked. To solve this, the DBA is killing the sessions from db level.
But still, even after killing the sessions, the JDBC Snd CC is not picking up the data and throwing the same error.
In JDBC Snd CC, QoS used is BE and both OB & IB Service Interface's were Sync.
Referred the below links while configuring the scenario:
Can someone help me in fixing the above mentioned issue.
Sai Ganesh replied
The issue should be wid the config of ur Sender JDBC Comm Channel. Make sure tat the option 'Disconnect from DB' under Advanced tab is chked as shown below and test again. This will surely work.
If the above option is not chked, the Snd CC while picking up the record tries to update the same using the update statement and since ur SI is a sync one, it expects a response and waits for the same. Meanwhile ur Rcv CC fetches the response and tries to update/insert and finds tat the record is locked and finally ends up in a long transaction. This results in a lock at the DB level.
Hope this helps.