***Idoc to JDBC scenario

[Former Member]

Dear all,

Mt requirement is that, under segment say E1mvkem i have a sub segment .When I give this segment to Access ,I don't get all the fields to the JDBC.ie my idoc is sending around 18 E1mvkem fields but my jdbc is receiving only 3 fields.

any pointers would be appreciated.

Thanks,

Srini

[rajasekhar_reddy14 · Accepted solution]

The best way to check is test your mapping program in ESR with test data , and debug it. if it is giving reqquired out put in mapping then it will work.

Regards,

Raj

[Former Member]

Hi,

Did you crosschecked the table structure to which you are inserting the data into...

Also enable logSQLStatement to true in the advanced parameters of the JDBC to know the insert statement issued to the database...

HTH

Rajesh

[Former Member]

access -

---

1to unbounded

all the filelds ---0..1 cardinality

The other scenario file to JDBC is working fi fine using the same table.

[Former Member]

Check the audit logs of your receiver channel ...

As said above enable sql statement to log in audit logs which shows the exact sql statement trying to issue to the database..

later you can take that statement and can execute in database to see whats happening ....

Hope this is not a production problem...

HTH

Rajesh

[Former Member]

Nope its is Dev

[Former Member]

ok,Now it is inserting duplicate line items in to the database.