Sequence statement JDBC receiver Adapter

[Former Member]

Hi,

I would like to know if the JDBC adpater respect the order of the description data type to process statements.

for instance if I have a structurte like:

<root>

<Statement1>

<dbTableName action='DELETE>

<table>MY_TABLE</table>

<key1>

<col1>val1old</col1>

<col2>val2</col2>

</key1>

</dbTableName>

</Statement1>

<Statement2>

<dbTableName action='INSERT'>

<table>MY_TABLE</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</Statement2>

</root>

The Statement1 will be always process before Statement2 ? because in this case it's important for me to delete before the insert.

Thanks in advance for your answer,

Antoine.

[VijayKonam]

Its thread based. Logically it should but may not be all the time, since the transactions are not possible in XI.

My suggession would be to go with calling a stored procedure which would give us 100% control over executing queries on the database.

VJ

[Former Member]

I am not exactly sure of the way the JDBC Adapter handles it but I ahve used the same logic as mentioned by you earlier and it is working in Production for more than a year now, without any problems.

[Former Member]

Thanks for your experience feedback, I will try like that.