Excecution in transaction mode

[sabyasachi_mohapatra3]

I have 3 SQL statements to be exceuted . The XML SQL message format is

<Statement 1>

Delete Query

</Statement 1>

<Statement 2>

Insert Query

</Statement 2>

<Statement 3>

Stored Procedure

</Statement 3>

Are all these stetements going to be execurted in one transaction mode.How to achieve this in terms of configuration in JDBC adapter

Will all the statements will be executed sequqentially.

If one statement did not execute properly will other stetements be executed after that .

Thanks

Sabyasachi

[sabyasachi_mohapatra3]

answred

[rodrigoalejandro_pertierr]

hi

why dont you create a SP that call those three SP. if error occurs define the proper control error. so, you can execute the main SP from jdbc sender in PI and in an error occurs no result will be returned to PI and a log message will be created in the DB locally.

Thanks

Rodrigo P.

[Former Member]

When the XML message comes to adapter engine, it consider that as one XML. It means if one SP call failed , then the whole message will fail in adapter engine.( Even if you define XSLT mapping also)..

So, please try to use java proxy if you can't change anything in DB. Otherwise please have one common SP for PI and handle all logics inside main SP.

[Former Member]

Hi,

Are all these stetements going to be execurted in one transaction mode.

I believe you want this at receiver side.

It will be easier to handle in the XSL mapping. Yes, all 3 statements will be executed in one transaction mode.

How to achieve this in terms of configuration in JDBC adapter

No special configuration required.

Will all the statements will be executed sequqentially.

Yes.

If one statement did not execute properly will other stetements be executed after that .

What do you mean by "not execute properly"? the queries will either be executed or none will be executed - which might be due to DB being down or the connection getting failed.

Let us know if you have any further questions.

Regards,

Neetesh