I've inherited a JDBC driver developed elsewhere. Database
administrators are reporting that the ManagerID field is not getting
updated when it should. The driver code is simple:

set destination attribute value("ManagerID", Local
and I can see a valid value for pvarManagerID in the trace.
In other places in the driver I'm seeing a different approach to writing
to the database which is more complex. It is creating a variable (named
"query"), appending XML text that has the SQL statement in it ("insert
into" or "delete from") then using the destQueryProcessor to send the
command to the database.

I'm wondering if set destination attribute is even supposed to work in
this scenario or if you have to use the destQueryProcessor approach.

Any input much appreciated