cancel
Showing results for 
Search instead for 
Did you mean: 

Message structure for JDBC receiver adaptor

Former Member
0 Kudos

Hi experts,

IN JDBC reciever adaptor i want to insert 3 fields in table.....!

the structure i have created is as follows:

TestReceiver

StatementName

Test

Action (attribute)

TABLE

access(1-unbound)

FirstName

MiddName

LastName

and source is

testSender

Row(1-unbound)

FirstName

MiddleName

LastName

I am getting error ="MAPPING">EXCEPTION_DURING_EXECUTE

can somebody plz tell me what is wrong?

Thanks

Rohan

Accepted Solutions (1)

Accepted Solutions (1)

justin_santhanam
Active Contributor
0 Kudos

Rohan,

Before executing the scenario, go to Test tab and execute the mapping. see whether you are getting your desired results.

As per your structure for each row in source access node in target has to be created.

raj.

Former Member
0 Kudos

in mapping test it is ok.

Actually i am using FCC...

I got the incoming message in message monitoring then got it's source and copied it in message mapping test.... got error

Target element can not produce...

Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd

justin_santhanam
Active Contributor
0 Kudos

Can u paste the copied xml over here.

raj.

Former Member
0 Kudos

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

<ns:TestSender xmlns:ns="http://test.com/EmpData">

<Recordset>

<Row>

<FirstName>Aaa</FirstName>

<MiddleName>Bbbbb</MiddleName>

<LastName>Ccccc</LastName>

</Row>

</Recordset>

</ns:TestSender>

justin_santhanam
Active Contributor
0 Kudos

Rohan,

Compare your first posting source structure with the above one. The first one doesn't have Recordset node. But the above one has. While doing content conversion use this parameter too

<b>ignoreRecordsetName</b> true

raj.

Former Member
0 Kudos

Hi Raj,

thanks for ur reply. I added the parameter as Row.ignoreRecordsetName true

but still i m getting Recordset Name in XML and error persists.

M i doing it in right way?

justin_santhanam
Active Contributor
0 Kudos

Rohan,

Don't give row.ignoreRecordsetName give only ignoreRecordsetName

raj.

Former Member
0 Kudos

Hey Raj,

Thanks... It worked.....

thanks a lot...

justin_santhanam
Active Contributor
0 Kudos

No Problem

raj.

Answers (0)