SQL Statement out of BPM
maybe it will be a quick hit for you, but I searched hours to find the solution.
My scenario is the following:
I receive a resultset from an JDBC Adapter. The requested Table has only four rows
with to coulums. The table refelects the status of four scanning devices and has
different statuses like 1,2,3, etc. Therefore I get back a message like described
in the help (http://help.sap.com/saphelp_nw04/helpdata/de/7e/5df96381ec72468a00815dd80f8b63/frameset.htm)
This message is forwarded to a BPM which first do a switch. If all Status are 0
then send and update Statement to the database and set all statuses to 4, otherwise
To do that I would like to send just an update statement like described in the help
<access> UPDATE ScanningStatus SET Status=4
The Weblog "Save time with generalized JDBC datatypes"
(/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes) describes how to do a mapping
between these both messages but the source message will not transfer any values to the target
message. Can I send a fixed message, here my SQL Statement, directly to the database out of the
BPM without doing an unneeded mapping before?