transaction function of Xi JDBC Adapter?

[Former Member]

We are migrating SAP Business Connector to XI, there are something like commit, rollback. I'm wondering whether we can do this with XI?

Any information will be greatly appreciated.

Thanks.

[Former Member · Accepted solution]

Hi,

the is no commit or rollback function.

You could do this with a workaround. Instead of using e.g. an insert statement in the jdbc-adapter use a stored procedure. You have to develop the stored procedure on the database side.

Regards Mario

[aashish_sinha]

Hi,

In XI, as far as my knowledge, there is no rollback you can do, but you can do the Auto commit thing. Also you can write stored procedure and call it using JDBC Adapter.

you need to configure your JDBC adapter for that purpose related to particular database.

for commit you can use

db.autoCommit=NO|YES

There are different levels of database transactions known as isolation levels. The JDBC adapter uses the highest isolation level by default to avoid database inconsistencies arising from parallel database transactions. Some JDBC drivers or database products do not support this isolation level and it may therefore be necessary to lower it accordingly. Note, however, that lowering the isolation level can have an adverse effect on transaction security.

Therefore, only do this when necessary. The values listed above correspond to the following JDBC constants:

■ 0 u2013 TRANSACTION_NONE

■ 1 u2013 TRANSACTION_READ_UNCOMMITED

■ 2 u2013 TRANSACTION_READ_COMMITED

■ 4 u2013 TRANSACTION_REPEATABLE_READ

■ 8 u2013 TRANSACTION_SERIALIZABLE

If the parameter is not set, the default value of the connected database applies instead.

Hope this will help you. also refer this link for configuration of JDBC adapter

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm

Regards

Aashish Sinha

PS : reward points if helpful

Edited by: Aashish Sinha on Jun 17, 2008 9:18 AM

[Former Member]

If not auto-commit, how do we commit it?

[Former Member]

Hi Shen,

JDBC adapter is a means of connecting the DB to the integration server,be it the sender or the receiver,

Hence as ur scenario requires DB concepts as rollback and commit..u would have to do it on the DB side only.

[Former Member]

Hi Shen ,

What is the current scenario? What are the application that the BC connected to ? Is some Database like Oracle or SQL server involved?

[Former Member]

yes, of course , Oracle and SQL server.