Update SQL in JDBC to Proxy

[Former Member]

Hi all,

I have a scenario to send JDBC data to Proxy from two tables:

(1) IN Query Statement : I create a View to connect the two table, and then select from the VIEW where statement field = 0 (statement field in Primary table)

(2) IN Update statement: I update Primary table and set the statement field = 1

But sometimes , for example, the primary table had 5 records which statement field = 1. Yet when I checked the corresponding Message in XI, it only had 4 records in the message.

And I checked the records in primary table, the Time the last record was inserted into the table nearly equl the Time the XI Query SQL executed.

How could I fix this problem? Thank you for your help

[Former Member · Accepted solution]

Hi,

The JDBC adapter uses the highest isolation level by default (serializable) to avoid database inconsistencies arising from parallel database transactions. Some JDBC drivers or database products do not support this isolation level and it may therefore be necessary to lower it accordingly.

You may use one of the following isolation level as per your need

· none

· Read-uncommited

· Read-commited

· Repeatable_read

· serializable

Please have a look on the following link for more information on these isolation levels

regards,

Jitender

[Former Member]

check the "Serializable" option in JDBC communication channel