on 02-24-2014 6:03 AM
Hi ,
My interface is Proxy to JDBC(MS-SQL)
Sending multiple tables by using single interface.
Now below requirement has been raised by the client,Please help
1. Will you be using transaction to encapsulate all the inserts/updates of an interface. ??
what is transaction in PI.?
regards,
Vinod
Hello,
By default, transaction level is with PI which means that in case any update/insert gets failed (for that specific message) then by default PI will rollback the entire transaction.
Thanks
Amit Srivastava
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Amit,
My issue is :
Let’s say an update for one interface consist of the following SQL changes:
If query 2 (table B) fails because of an invalid foreign keys, I do not want any of the 3 tables to be updated.
Is it possible through our PI interface
Please help me on this
regards,
Vin
Hello,
>>If query 2 (table B) fails because of an invalid foreign keys, I do not want any of the 3 tables to be updated.
I think, yes it's possible. Create below structure in PI and test ur requirement.
BTW, make sure to put StatementName** occ as 0..Unbounded.
<MessageType>
<StatementName1> ----- 0...Unbounded
<dbTableName action=”Update_Insert”>
<table>Table1</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
<Key>
…….
</Key>
</dbTableName>
</ StatementName1>
< StatementName2>
<dbTableName action=”Update_Insert”>
<table>Table2</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
<Key>
…..
</key>
</dbTableName>
</ StatementName2>
</MessageType>
Thanks
Amit Srivastava
Hi Vin,
Talk with your DB team to do an statement procedure with all insert/update logic encapsulated.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.