File 2 JDBC - too less inserts

[Former Member]

Hi Experts,

i have an file to JDBC scenario.

i read several lines from a file which has this structure:

http://img255.imageshack.us/img255/5028/unbenannt1eg9.jpg

the message has all the data field i need,

but when inserting into a table,

it only inserts the first row:

http://img86.imageshack.us/img86/8976/unbenannt2tu7.jpg

how can i tell the jdbc receiver to insert all the data fields, not only the first one?

Regards

Christian

[Former Member · Accepted solution]

Hi all,

here are the occurences. what should i change?

http://img515.imageshack.us/img515/9855/unbenannt2yp4.jpg

Regards

[Former Member · Accepted solution]

Hi ,

Go to Datatype for the message and then change the occurence of access element in IR for 0..unbounded.

Regards

[Former Member · Accepted solution]

as you see,

access is 0 ... unbounded

regards

[Former Member · Accepted solution]

there is a problew with ur message mapping

regards

krishna

[Former Member · Accepted solution]

Hi,

why should there be a problem?

Mapping works fine, but it has only one insert, not multiple like it should..

can you please explain in more detail what you mean?

Regards

[Former Member · Accepted solution]

Map the target node "acceess" with the node "data field " in the source.

also check the context of the 'data field node"

regards

krishna

[Former Member · Accepted solution]

also,, give us a screenshot of ur mapping

regards

krishna

[Former Member · Accepted solution]

Thank you,

i had to connect access with data field.

Thanks krishna!

[Former Member · Accepted solution]

Hi,

I can see Access root node is not mapped on the element under access is mapped. map the Access root node with the Datafield root node.

So as many times ur DataField come ur Access node will repeate.

Thnx

chirag

[Former Member · Accepted solution]

I think i have found the reason...

You have to change the context of the node to "recordset"

why dont u give a try

regards

krishna

[Former Member · Accepted solution]

Sometimes the mistakes are too simple and silly

regards

krishna

[Former Member]

i think your element of the Message Type: MT_Data_JDBCReceiver

should have the 0-unbound occurencies for field access

and check your mapping whether you generate multiple line of access element

Edited by: Lawrence on Apr 10, 2008 11:39 AM

[Former Member]

Hi,.

I can see only one access record in ur MT hence it has insterted only one record in DB. check the occurance of accce.

chirag

[Former Member]

Hi

you can have a single STATEMENT tag with multiple ACCESS tags.

regards

Krishna