Receiver JDBC adapter parameter functionality

[Former Member]

Hi All,

What is the use of " Database Auto-Commit-Enabled (No Transaction Handling)" parameter in JDBC receiver adapter?

Thanks & Regards,

Purushotham

[Former Member]

http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

[former_member238007]

Hi Purushotham,

This option comes under advanced mode in ADVANCED tab,

Which is used to commit the database without any transaction.. i.e if we do any transactions with the database such as insert, it will be in virtual table if we commit it goes to the table which we defined, so there we use commit statement to store in the table to process this statement automatically we may use this option, we can say more or less it is an authentication to commit with the database..

regards

Kishore

[Former Member]

Hi,

My requirement is " My database is using some other application. I should not insert new records when ever third party application is pulling data from the database. Once database is free then only i have to insert new records. How can i achieve this? Is this option will help me to do the same functionality?

Thanks & Regards,

Purushotham

[former_member238007]

HI Purushotham,

If my understanding is correct...

u can assign a flag field addittion to the existing fields , so while updating the data from the xi system set that flag as default as NO, if once the records was pulled by the third party system make that flag as YES , it may differentiate in between the to be process and processed files ..

reply if any queries..

regards

Kishore

[Former Member]

Hi Kishore,

Dont we have any predefined parameter in Receiver JDBC adapter?

Thanks & Regards,

Purushotham

[prateek]

The functionality u require is already provided by the standard databases. So no need to handle it separately. Which database are u using? As I mentioned earlier, if ur database does not follow transaction property, only then u have to look for other options.

Regards,

Prateek

[former_member238007]

Hi Purushotham,

i think no processsing parameters exists which suits ur requirement...

In addition to this we have an operating system commands.. where we can clear the database before inserting the data.. using stored procedures.. it may solve it i think.

try to explore with this option

regards

Kishore

[kkram]

Purushotham

You should use the isolation level option in the communication channel for achieving this (Serializable being the highest isolation level). Check this link for understanding what an isolation level means.

http://en.wikipedia.org/wiki/Isolation_(computer_science)

KK

[prateek]

This is just for preventing database inconsistencies. It is required only for those JDBC drivers that do not support transactions.

Regards,

Prateek