Serializable Vs Repeatable read

[Former Member]

Hi All

What is the difference and exact usuage of the parameters Serializable Vs Repeatable read in Sender JDBC Adapter?

Thanks

Sai

[former_member556603 · Accepted solution]

Hi Sai,

What is the difference and exact usuage of the parameters Serializable Vs Repeatable read in Sender JDBC Adapter?

Go through this links,

http://help.sap.com/saphelp_srm40/helpdata/pt/7e/5df96381ec72468a00815dd80f8b63/content.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6a90d6aa-0b01-0010-8a83-cf0e6c70...

Sender JDBC Adapter

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

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

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

Thanks,

Satya

Edited by: SATYA KUMAR AKKARABOYANA on May 8, 2008 4:52 PM

[Former Member]

Hi All

Still i am not clear about the differences. Do you have any real time problems encountered with Sender JDBC adapter?

Thanks

Sai

[sunil_singh13]

Hi Sai,

Go through the following Note it has answer to your quetion to some extent

Reward Points if Helpful .

Thanks

Sunil Singh

[GabrielSagaya]

TRANSACTION_REPEATABLE_READ – this level guarantees that the data the transaction reads is not being modified by another transaction and will not change unless the reading transaction modifies it and commits

TRANSACTION_SERIALIZABLE – this level guarantees maximum data integrity, since only one transaction run as a single serial operation can both read and modify the data at a time. Other transactions can access the data only after the serializable transaction has committed or rolled back.

Note :avoid using the TRANSACTION_SERIALIZABLE isolation level if speed is important for your system

http://help.sap.com/saphelp_nw04/helpdata/en/79/8995c2ebc0dc48a3ba428da6cb1c9b/frameset.htm