JDBC Adapter - transaction handling

[Former Member]

Hi,

I have a question. I use graphical Message Mapping and standard documents formats for Receiver JDBC Adapter.

Now I need to push a delete call and insert calls in one message looks like that one f.e.:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_CostcentreUpdate xmlns:ns0="http://rtl.de/xi/TransCostcenter">

- <StmName>

- <dbTableName action="DELETE">

<table>KOSTENSTELLEN</table>

</dbTableName>

- <dbTableName action="INSERT">

<table>KOSTENSTELLEN</table>

- <access>

<KOSTL>0000001000</KOSTL>

<GUELTVON>2005-09-01</GUELTVON>

<GUELTBIS>9999-12-31</GUELTBIS>

<ABTEI>Test1</ABTEI>

<VERAK>Name1</VERAK>

<KHINR>K1000_1010</KHINR>

<KTEXT>Test1</KTEXT>

</access>

- <access>

<KOSTL>0000001001</KOSTL>

<GUELTVON>2005-03-01</GUELTVON>

<GUELTBIS>9999-12-31</GUELTBIS>

<ABTEI>Test1</ABTEI>

<VERAK>Name2</VERAK>

<KHINR>K1000_1010</KHINR>

<KTEXT>Test2</KTEXT>

</access>

- <access>

<KOSTL>0000001006</KOSTL>

<GUELTVON>2006-04-01</GUELTVON>

<GUELTBIS>9999-12-31</GUELTBIS>

<ABTEI>Test1</ABTEI>

<VERAK>Name3</VERAK>

<KHINR>K1000_1010</KHINR>

<KTEXT>Test3</KTEXT>

</access>

</dbTableName>

</StmName>

</ns0:MT_CostcentreUpdate>

Because I need to do both (delete & insert) in one transaction mode. But i will not work at the moment

I always get error:

com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'KOSTENSTELLEN' (structure 'StmName'): java.sql.SQLException: FATAL ERROR document format: invalid level 5' found (structure 'StmName')

Thanks for any help

Matt

[udo_martens · Accepted solution]

Hi Matthias,

you need to have two statements (StmName), one for delete, one for insert.

Regards,

Udo

[Former Member · Accepted solution]

Thanks Udo, this was exactly what I needed!

Regards

Matthias