JDBC to JDBC scenario - not getting update response

[Former Member]

Hello Experts,

We have a JDBC to JDBC scenario using BPM. In our scenario sender system is checking the status of the flag and once it is LOADED status it starts picking and updates the receiver data base. Till this it is working fine. But once after inserting the data into receiver database we are not getting the updated status message back in the sync process. Following is the error.

Delivery of the message to the application using connection AFW failed, due to: Sync application request expired.. Setting message to status failed

Please some one even tell us the syntax of how to keep ReadTimeout, CONNECT_TIMEOUT in receiver CC connecting to DB2.

Driver:???.ReadTimeout

Driver:???. CONNECT_TIMEOUT

Can any one tell us, do we need to increase the inserting time or response time or any other option where I can do changes?

Is there any other way other then increasing the time to solve this issue?

Thanks in advance,

Rama

[marksmyth]

Hello Rama

The syntax of these parameters are:

driver.com.ibm.db2.jcc.DB2Driver.ReadTimeout

driver.com.ibm.db2.jcc.DB2Driver.CONNECT_TIMEOUT

sqlquerytimeout

Also check the notes below:

1078420 XI/PI JDBC Adapter: Setting JDBC driver properties for DB

1385571 PI JDBC adapter: Connecting a DB2 for IBM i

Regards

Mark