Receiver JDBC Adapter Issue

[Former Member]

Dear Experts,

I came through a very unusual behavior of JDBC adapter .

while Inserting multiple records it is allowing only first record to insert for other two-three records not allowing....showing error related to column length....which is not true as on copy pasting the same SQL query at Oracle prompt...it went through.

But as all are in one transaction so not allowing the first record also to get in.

Kindly guide...!!!!

Regards,

[Former Member]

Needs to close the thread .!!!

[Former Member]

check your mapping,

It might not generate seprate sql statement for each record and mixing the records with each other.

[Former Member]

Put "logSQLStatement" as "true" in receiver Communication channel.

run ur scenario.

Goto Message Monitoring in RWB...

click on Adapter Engine.

then check the messages over...

check whether u r able to see as each (insert or update) statements for each records..

if u r not able to see the tat statments for each record, then check ur mappings

Edited by: ragu r on Sep 6, 2008 8:13 AM

[Former Member]

Hi,

If you have a source structure 0-Unbounded then map the unbounded node to access.

For table and statement just map with constants.

Regards,

Prakasu