cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Receiver adapter

Former Member
0 Kudos

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(&apos;02/02/2008&apos;, &apos;mm/dd/yyyy hh:mi:ss&apos;)</CREATED_ON>

<CREATED_BY>jorge</CREATED_BY>

<LAST_UPDATED hasQuot="No">to_date(&apos;02/02/2008&apos;, &apos;mm/dd/yyyy hh:mi:ss&apos;)</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(&apos;02/02/2008&apos;, &apos;mm/dd/yyyy hh:mi:ss&apos;)</CREATED_ON>

<CREATED_BY>jorge</CREATED_BY>

<LAST_UPDATED hasQuot="No">to_date(&apos;02/02/2008&apos;, &apos;mm/dd/yyyy hh:mi:ss&apos;)</LAST_UPDATED>

<LAST_UPDATED_BY>jorge</LAST_UPDATED_BY>

<APPROVE_STATUS>APPROVED</APPROVE_STATUS>

<KIT_FLAG>N</KIT_FLAG>

<PACKAGE_BEHAVIOUR>User&apos;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(&apos;02/02/2008&apos;, &apos;mm/dd/yyyy hh:mi:ss&apos;)</CREATED_ON>

<CREATED_BY>jorge</CREATED_BY>

<LAST_UPDATED hasQuot="No">to_date(&apos;02/02/2008&apos;, &apos;mm/dd/yyyy hh:mi:ss&apos;)</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(&apos;02/02/2008&apos;, &apos;mm/dd/yyyy hh:mi:ss&apos;)</CREATED_ON>

<CREATED_BY>jorge</CREATED_BY>

<LAST_UPDATED hasQuot="No">to_date(&apos;02/02/2008&apos;, &apos;mm/dd/yyyy hh:mi:ss&apos;)</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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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>