Skip to Content
0
Apr 13, 2010 at 04:14 PM

inserting into two tables using JDBC Receiver Adapter

92 Views

I've defined following type for Receiver JDBC to save data in two different tables

Name		Category	Type		Occurrence
ReceiverDB_DT	Complex Type		
STATEMENT	Element				1..unbounded
TABLE_NAME	Element				1
ACTION		Attribute	xsd:string	required
TABLE		Element		xsd:string	1
ACCESS		Element		Table1_DT	1
STATEMENT2	Element				1..unbounded
TABLE_NAME	Element				1
ACTION		Attribute	xsd:string	required
TABLE		Element		xsd:string	1
ACCESS		Element		Table2_DT	1

When I send data of two tables, it is showing data for both the two tables in MONI of PI System, but ultimately it shows only one table's data in message monitoring payload.

what could be the problem?

Thanks,

-Haresh