I have an update JDBC adapter service that updates say field A and Field B where field C
In the database A & B are mandatory but in the input to my service sometimes only A or B are populated. When this happens I get exception cannot update (A or B) to null
What I would hope for is that if only A has data A is updated (ignoring B) and if only B has data only B is updated (ignoring A)
Is there something I can do to get around the current behaviour?
I hope not to have to create multiple adapter update services and surrounding flow logic e.g. If A call update A, If B call update B, If A&B; update A&B; because the real table i’m talking about is 20 or so fields where this condition could occur.
(It’s Oracle 10g, JDBC 6.0.3 and IS 6.5)
P.s. I can’t beleive I haven’t come accross this before…