Easy points; is this correct XML to pass to a JDBC receiver?

[Former Member]

Can somebody cerify if this is correct XML to pass to a JDBC receiver? I need to eliminate this as the cause for not posting data successfully:

<?xml version="1.0" encoding="utf-8"?>
<a:MT_BalForCustomer_JDBC xmlns:a="urn:BalancedForecastCustomer">
	<root>
		<Statement1>
			<TransferBalancedCustomerForecast action="INSERT">
				<table>dbo.TransferBalancedCustomerForecast</table>
				<access>
					<ZAMATNR>8000016</ZAMATNR>
					<ZFC_CUSTC>1BLDISRET</ZFC_CUSTC>
					<CAL_YEAR>2009</CAL_YEAR>
					<CAL_MONTH>200902</CAL_MONTH>
					<AVERSION>001</AVERSION>
					<ATOTFCF>000000000000000.000</ATOTFCF>
					<ZPRSALPR>000000000000000.000</ZPRSALPR>
					<BASE_UOM>M3</BASE_UOM>
					<CURRENCY>EUR</CURRENCY>
				</access>
				<access>
					<ZAMATNR>8000023</ZAMATNR>
					<ZFC_CUSTC>1BLDISRET</ZFC_CUSTC>
					<CAL_YEAR>2013</CAL_YEAR>
					<CAL_MONTH>201309</CAL_MONTH>
					<AVERSION>001</AVERSION>
					<ATOTFCF>000000000000000.000</ATOTFCF>
					<ZPRSALPR>000000000000000.000</ZPRSALPR>
					<BASE_UOM>M3</BASE_UOM>
					<CURRENCY>EUR</CURRENCY>
				</access>
			</TransferBalancedCustomerForecast>
		</Statement1>
	</root>
</a:MT_BalForCustomer_JDBC>

BR,

Tony.

[udo_martens]

Hi Tony,

the hierarchy is too deep, just put the statements direct into element MT_BalForCustomer. You dont need element "root"

Regards,

Udo

[Former Member]

You need to remove the root tag..

that is the hierarchy level epxected is more than one here

root is your messgeType tag...

no need to have root tag agian

Rajesh

[Former Member]

Thanks!

BR,

Tony.