abreits / node-red-contrib-oracledb

Node-RED oracle database nodes
8 stars 15 forks source link

oracledb node cannot be used with HTTP In and Out nodes #11

Open oazabir opened 6 years ago

oazabir commented 6 years ago

The node does not clone the entire msg. Thus the req and res properties of the message gets lost. As a result, HTTP Out node does not work.

oazabir commented 6 years ago

This seems to be the block where a new message getting pushed with payload. Thus the original msg with other properties associated to it are lost.

 switch (resultAction) {
                case "single":
                  requestingNode.send({
                    payload: result.rows
                  });
                  requestingNode.log("Oracle query single result rows sent");
                  break;
                case "multi":
                  node.fetchRowsFromResultSet(requestingNode, result.resultSet, resultSetLimit);
                  requestingNode.log("Oracle query multi result rows sent");
                  break;
                default:
                  requestingNode.log("Oracle query no result rows sent");
                  break;
              }