MQSeries.net :: View topic

scravr · Posted: Mon May 17, 2010 6:11 am Post subject: Broker 7: DataInsert Node

HI all,

MB7:
I am trying to DataInsert a row into Oracle table with 2 columns:
ID: Integer
NAME: VARCHAR(100)

The ID goes in well but the NAME gets NULLS.

The DataInsert as a XML Message Set/Definition as a Source, and oracle database table definition as a Target.

The ID mapping is:
xs:integer($source/FoodStampSubmissionRequest/Account/ID)

The NAME mapping is:
$source/FoodStampSubmissionRequest/Account/NAME

Any ideas why NAME gets NULLS (like these Â¿Â¿Â¿Â¿Â¿ )

Here is the DataInsert MSGMAP file:

<?xml version="1.0" encoding="UTF-8"?>
<xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:gplang="http://www.ibm.com/wbi/2005/gplang" xmlns:maplang="http://www.ibm.com/wbi/2005/maplang" xmlns:msg="http://www.ibm.com/wbi/2005/msg" xmlns:rdb="http://www.ibm.com/wbi/2005/rdb">
<maplang:MapOperation name="MF_TEST_DB_ISRT_DataInsert" version="7.0.0.v20091028_2100" prefixes="/0/@namespaces.0/@prefix /0/@namespaces.1/@prefix /0/@namespaces.2/@prefix">
<blockContents xsi:type="maplang:ForEachStatement">
<blockContents xsi:type="rdb:InsertStatement" targetMapName="$db:insert" dsnName="DDEV" schemaName="MELSERVER" tableName="PAVANTEST">
<blockContents xsi:type="rdb:ColumnStatement" mappableName="ID">
<blockContents xsi:type="maplang:MapFromStatement">
<value xsi:type="gplang:FunctionCallExpression" name="xs:integer" text="xs:integer($source/FoodStampSubmissionRequest/Account/ID)"/>
</blockContents>
</blockContents>
<blockContents xsi:type="rdb:ColumnStatement" mappableName="NAME">
<blockContents xsi:type="maplang:MapFromStatement">
<value xsi:type="maplang:MappableReferenceExpression" name="$source" text="$source/FoodStampSubmissionRequest/Account/NAME"/>
</blockContents>
</blockContents>
</blockContents>
<source xsi:type="maplang:MappableReferenceExpression" name="$source" text="$source/FoodStampSubmissionRequest/Account"/>
</blockContents>
<eParameters xsi:type="msg:MsgSourceMapRoot" name="$source" eType="/1"/>
<namespaces namespaceName="http://www.w3.org/2001/XMLSchema">
<prefix prefixName="xsd"/>
</namespaces>
<namespaces namespaceName="http://www.w3.org/2001/XMLSchema-instance">
<prefix prefixName="xsi"/>
</namespaces>
<namespaces namespaceName="http://niem.gov/niem/appinfo/2.0">
<prefix prefixName="dfta"/>
</namespaces>
</maplang:MapOperation>
<msg:MessageHandle messageSetName="MS_TEST_DB_ISR" namespaceName="" simpleName="FoodStampSubmissionRequest" messageKind="assembly">
<headers name="Properties" rootElementName="Properties"/>
</msg:MessageHandle>
</xmi:XMI>

Thanks,
Moshe