Skip to Content

JDBC to PROXY Sync Scenario

Hi All,

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.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 25, 2012 at 11:23 AM

    Hi Praneeth,

    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.



    Add comment
    10|10000 characters needed characters exceeded

  • Jul 24, 2012 at 11:48 AM

    Hi Praneeth,

    Did you try to test the proxy itself? My suspiction is that your proxy receiver is working for a very long time (performance issues), which you misinterpret as a lock on the table. I mean: PI locks the DB table entries while processing the data and sending it to proxy, and since the latter takes a lot of time, the locks stay there for so long. Can you confirm if my suspiction is true?



    Add comment
    10|10000 characters needed characters exceeded