Message Split - JDBC receiver.

[Former Member]

Hi ,

I have a payload like -

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

<ns0:MT_JDBC xmlns:ns0="http://AIM/Pmation">

<STATEMENTNAME>

<PARTINFO ACTION="EXECUTE">

<TABLE>INSERT_HUB_PARTINFO</TABLE>

<I_CLINTERVALVALUE1 isInput="1" type="NUMERIC">9.6</I_CLINTERVALVALUE1>

<I_CLINTERVALVALUE2 isInput="1" type="NUMERIC">9.6</I_CLINTERVALVALUE2>

</PARTINFO>

</STATEMENTNAME>

<STATEMENTNAME>

<PARTINFO ACTION="EXECUTE">

<TABLE>INSERT_HUB_PARTINFO</TABLE>

<I_CLINTERVALVALUE1 isInput="1" type="NUMERIC">9.6</I_CLINTERVALVALUE1>

<I_CLINTERVALVALUE2 isInput="1" type="NUMERIC">9.6</I_CLINTERVALVALUE2>

</PARTINFO>

</STATEMENTNAME>

<STATEMENTNAME>

<PARTINFO ACTION="EXECUTE">

<TABLE>INSERT_HUB_PARTINFO</TABLE>

<I_CLINTERVALVALUE1 isInput="1" type="NUMERIC">9.6</I_CLINTERVALVALUE1>

<I_CLINTERVALVALUE2 isInput="1" type="NUMERIC">9.6</I_CLINTERVALVALUE2>

</PARTINFO>

</STATEMENTNAME>

</STATEMENTNAME></ns0:MT_JDBC>

I want to split this at each </STATEMENTNAME> into different payloads and send each to a JDBC receiver to call a stored procedure.

Is this possible using BPM. If so how?

Thanks,

Varghese.

[bhavesh_kantilal]

Varghese ,

Each of these STATEMENT is going to make a separate call to the Stored procedure anyways, so it should not be an issue.

But, if you still want to do this, use MultMapping withput BPM as shwon in this blog,

/people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible

But with my understanding the current Datatype itself should call the SP multiple times,

Regards

Bhavesh