JDBC SQL Query Transactionality

[Former Member]

Hi Experts,

If possible, please can you let me know how the JDBC SQL Query Transactionality works?

For example, in the JDBC communication channel configuration parameters,

if I use "SELECT * FROM orders WHERE new = 'TRUE' " for the select query and;

if I use "UPDATE orders SET new = 'FALSE' WHERE new = 'TRUE' " for the update query;

does the UPDATE query just update the records contained in that particular record set (for a particular polling instance)?

What happens if someone inserts new records into the orders table just before the update query executes? Will the update query update those records too? Or just those records in the record set for a particular polling instance? How does XI/PI distinguish between the records contained in the record set for (for a particular polling instance) and the records inserted just before the update query executes?

Thanks and regards,

Brendon

[MichalKrawczyk · Accepted solution]

hi,

as far as I remember this works correctly only when you set Transaction Isolation Levels to repeatable_read or serializable

have a look at those levels :

http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/TransactionIsolation.html

so I guess both of them should prevent situations you're talking about

Regards,

Michal Krawczyk

[Former Member · Accepted solution]

Thank you for the quick response