Urgent: SAP BC how to use the Flow Service: Pub.DB.StartTransaction.?

[Former Member]

---

Hi !

I am using the SAPBC 4.7 against a SAP CRM 3.0.

My client want to replicate the CRM (Ebpro) catalogue to a web site (B2C) running SQLServer 2000.

My goal is to get the Catalogue in XML (complete and-or partial load) and upload the SQLServer tables.

I am using the Microsoft JDBC driver to do that.

Now my, question

I am trying to postpone the commit (to the sqlserver database) at the end of my flow service and to do that, I use the Pub.DB.StartTransaction. According to the documentation, this FlowService is supposed to set the autocomit to off, so it (the commit) can be controlled manually.

Here is what happened …The first insert does not show up in the DB (so it seem to be working) … but after the second insert, all subsequent insert are committed … Even it I use the Pub.DB.StartTransaction !!

What am I doing wrong

Thank in advance!

[bhavesh_kantilal]

Michel,

If you are using the JDBC adapter, you can use the Transaction Handling on JDBC adapter to turn of commit.

Set <b>Isolation Level for Transaction</b> to DEFAULT and then, turn off the COMMIT in yoru Database and it would solve your problem.

Another option would be to use <b>Database Auto-Commit-Enabled (No Transaction Handling)</b>

Just check this link on the same,

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Regards,

Bhavesh