on 10-12-2008 8:16 PM
I have multiple rows in the JDBC receiver adatper like below:
<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_Package xmlns:ns0="urn:xyz.com:ordermgmt:edaot">
<STRUCTURE>
<PackageTypeRow action="UPDATE">
<Table>PPD2_PRODUCT_TYPES</Table>
<access>
<PRODUCT_TYPE_ID>393922</PRODUCT_TYPE_ID>
<PRODUCT_TYPE>Contract</PRODUCT_TYPE>
<STATUS>APPROVED</STATUS>
<APPROVE_STATUS>APPROVED</APPROVE_STATUS>
<CREATED_ON hasQuot="No">to_date('02/02/2008', 'mm/dd/yyyy hh:mi:ss')</CREATED_ON>
<CREATED_BY>jorge</CREATED_BY>
<LAST_UPDATED hasQuot="No">to_date('02/02/2008', 'mm/dd/yyyy hh:mi:ss')</LAST_UPDATED>
<LAST_UPDATED_BY>jorge</LAST_UPDATED_BY>
<DESCRIPTION>Contract</DESCRIPTION>
</access>
<Key>
<PRODUCT_TYPE_ID>393922</PRODUCT_TYPE_ID>
</Key>
</PackageTypeRow>
<PackageAttributesRow action="INSERT">
<TABLE>PPD2_PACKAGES</TABLE>
<access>
<PACKAGE_ID>4568</PACKAGE_ID>
<PACKAGE_TYPE_ID>393922</PACKAGE_TYPE_ID>
<PACKAGE_NUMBER>PKC0103</PACKAGE_NUMBER>
<DESCRIPTION>CFM100 : Encounter (TM) Conformal - L (a.k.a Conformal ASIC) x 10 Qty</DESCRIPTION>
<USAGE_ATTRIBUTE>A</USAGE_ATTRIBUTE>
<STATUS>ACTIVE</STATUS>
<EOSUPPORT_DATE>20101220</EOSUPPORT_DATE>
<EOSALE_DATE>20081006</EOSALE_DATE>
<EFFECTIVE_DATE>20071220</EFFECTIVE_DATE>
<EDACARD_FLAG>N</EDACARD_FLAG>
<REMIX_FLAG>Out</REMIX_FLAG>
<CONTRACT_TYPE>N</CONTRACT_TYPE>
<MKTG_OWNER_LOGIN_ID> Don Miranowski</MKTG_OWNER_LOGIN_ID>
<LICENSE_LOCK_TYPE>N</LICENSE_LOCK_TYPE>
<ADMINISTRATOR> Don Miranowski</ADMINISTRATOR>
<ROYALTY_BEARING_FLAG>N</ROYALTY_BEARING_FLAG>
<INCLUDE_PRODUCTS_IN_LD>Y</INCLUDE_PRODUCTS_IN_LD>
<CREATED_ON hasQuot="No">to_date('02/02/2008', 'mm/dd/yyyy hh:mi:ss')</CREATED_ON>
<CREATED_BY>jorge</CREATED_BY>
<LAST_UPDATED hasQuot="No">to_date('02/02/2008', 'mm/dd/yyyy hh:mi:ss')</LAST_UPDATED>
<LAST_UPDATED_BY>jorge</LAST_UPDATED_BY>
<APPROVE_STATUS>APPROVED</APPROVE_STATUS>
<KIT_FLAG>N</KIT_FLAG>
<PACKAGE_BEHAVIOUR>User's Choice</PACKAGE_BEHAVIOUR>
<PROMOTIONAL_FLAG>N</PROMOTIONAL_FLAG>
</access>
<Key>
<PACKAGE_ID>4568</PACKAGE_ID>
</Key>
</PackageAttributesRow>
<PackageLongDescriptionRow action="INSERT">
<TABLE>PPD2_PRODUCT_DESCRIPTIONS</TABLE>
<access>
<PRODUCT_DESCRIPTION_ID>3939304</PRODUCT_DESCRIPTION_ID>
<GENERAL_DESCRIPTION>Test</GENERAL_DESCRIPTION>
<CREATED_ON hasQuot="No">to_date('02/02/2008', 'mm/dd/yyyy hh:mi:ss')</CREATED_ON>
<CREATED_BY>jorge</CREATED_BY>
<LAST_UPDATED hasQuot="No">to_date('02/02/2008', 'mm/dd/yyyy hh:mi:ss')</LAST_UPDATED>
<LAST_UPDATED_BY>jorge</LAST_UPDATED_BY>
<PACKAGE_ID>4568</PACKAGE_ID>
</access>
<Key>
<PRODUCT_DESCRIPTION_ID>3939304</PRODUCT_DESCRIPTION_ID>
</Key>
</PackageLongDescriptionRow>
<PackagePrices action="INSERT">
<TABLE>PPD2_PRODUCT_PRICES</TABLE>
<access>
<PRODUCT_PRICE_ID>324</PRODUCT_PRICE_ID>
<PRICE>2,000,000.00</PRICE>
<STATUS>ACTIVE</STATUS>
<CREATED_ON hasQuot="No">to_date('02/02/2008', 'mm/dd/yyyy hh:mi:ss')</CREATED_ON>
<CREATED_BY>jorge</CREATED_BY>
<LAST_UPDATED hasQuot="No">to_date('02/02/2008', 'mm/dd/yyyy hh:mi:ss')</LAST_UPDATED>
<LAST_UPDATED_BY>jorge</LAST_UPDATED_BY>
<APPROVE_STATUS>APPROVED</APPROVE_STATUS>
<PRICING_TYPE>99 Year</PRICING_TYPE>
<PACKAGE_ID>4568</PACKAGE_ID>
</access>
<Key>
<PRODUCT_PRICE_ID>324</PRODUCT_PRICE_ID>
</Key>
</PackagePrices>
</STRUCTURE>
</ns0:MT_Package>
-
But it is only procesing the first row. I have the batch mode on. Please give any suggestion.
Thanks,
Samir
Edited by: Samir Kumar on Oct 12, 2008 9:16 PM
You message format is incorrect.. i guess it should be
</PackageTypeRow>
<Statement2> tag is missing after the first table structure...Try separating each statement structure with the tags.
<PackageAttributesRow action="INSERT">
Eg. If you are missing </statement1><statement2>.
<statement1>
<table>
</statement1>
<statement2>
<table>
</statement2>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.