JDBC FILE MApping error

[Former Member]

Hello Friends ,

I am configuring JDBC to flat file scenario. the JDBC sender struture is

SQL_MT

-->row

-->A

-->B

and its is populated properly. The flat file structure i created is

DATA_MT

-->root

-->item

-->A

-->B

I have mapped SQL_MT <--> root occurences 1

row <---> item 0..unbounded

A<-->A

B<-->B

while execution I get only

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

<ns:DATA_MT xmlns:ns="uri:dp:transfer" />

so the flat file is always empty.and there is data in incoming XML in SXMB_MONI.

Could you pls tell me where i am wrong.

Thanx

Anu

[Former Member]

<i>>>and its is populated properly. The flat file structure i created is

DATA_MT

-->root

-->item

-->A

-->B</i>

Have you specified the content conversion parameters correctly(for file receiver).....counterchk with this blog:

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

[MichalKrawczyk]

Hi Anu,

copy the incomming XML

from sxmb_moni (view -> source)

and paste it to your mapping program

check if it works over there (the mapping itself)

Regards,

michal