A problem about jdbc synchronous scenarios

[former_member319973]

hi,exports:

there is a jdbc synchronous scenarios:ECC->SQLServer,Data is passed to the PI by proxy,then PI insert these data into the database,and return the count of the sucessfully insert records with the item "count".ECC use this information to set the status of some items.

But there is a problem,when insert operation is failed,the "count " item will not return ,and how can i return this error information to the ECC.For example when insert is failed,pi returned "count" item with zero.

expect your anwers,thank you.

[stefan_grube · Accepted solution]

For a sync proxy, you receive a system fault exception when an error occurs.

So you can do an error handling based on that exception.

[Former Member]

Hi Yupeng,

If "Insert" fails, The total interface is failed.

If there is no records are to Insert in Database, Then count value "0".Then it returns the count value.

For just for identification send the JDBC REQUEST XML and JDBC Response XML, then we can easily to identify the error.

Thank you

Sateesh

[former_member319973]

Hi,Sateesh

Thank you for your reply

"For just for identification send the JDBC REQUEST XML and JDBC Response XML, then we can easily to identify the error."

Yes ,we can identify the error information by monitor PI,but Whether ECC report program can get this error information or not?

[Former Member]

Hi Yupeng,

In case of System errors,Application errors ECC report program can not get this back.

Thank you

Sateesh

[former_member319973]

HI ,Sateesh

In our scenario,after ECC send the data ,it will wait for the returned information,if insert failed,ECC report program can further process.how can i solve this problem?

thank you