Issue on Idoc - JDBC with multiple tables

[Former Member]

Hi Experts,

I'm working on a IDoc to JDBC scenario, wherein I need to insert data to mutiple tables which exist on the same database. So, I've used multiple statements in the same message type (as mentioned below)

But, the problem with this approach is, say if the Insert fails for table 1 (due to NULL value insert to Not Null Column) then the other queries (for table 2 & 3) are not getting executed. But, my requirement is to get them executed indepently and I'm not keen on using multiple message mappings for the same. Is there any work around for this? Please suggest.

MType

Stmnt1 (0..unbounded) (structure for table 1)

Stmnt 2 (0..Unb) (Str for table 2)

Stmnt 3 (0..Unb) (Structure for table 3)

Thanks,

Hussain.

[Former Member]

Hi

Either make sure all statements are getting populated with required data , means if DB has column (Not null) make sure u pass some value atleast Null using Mapwithdefaullt.

If basic required fields are passed then it will insert sucessfully , use mapwithdefault fuinction to pass the same id source has no value to send.This is the way for first option

R else u need to make independent mapping , which u r not willing to do so

Rgds

srini