search

smchamberlin / node-red-contrib-ibm-db2

Node-RED nodes to work with a Db2 LUW database. Works with "Db2 on Cloud" and "Db2 Warehouse on Cloud" services as well as standalone installation of Db2 LUW.
4 stars 14 forks source link

NODE-RED crashes when i use dashDB node #18

Open arjunsanchala opened 5 years ago

arjunsanchala commented 5 years ago

i am using node-red flows for my application. in that i am using dashDB node and ibm iot node. whenever i apply any small change in my flow (like remove a small wire), and deploy, it gives me connection lost. so every time i lost my connection and every small change i make, takes 5 minutes. i am attaching my logs. 1 2 3 4 5

jcostello93 commented 5 years ago

Sorry this is late, but in my experience, I've noticed two odd behaviors with this node:

  1. If you're binding parameters to a query, there cannot be a space between the word and comma. For example,

Do this: msg.payload.time,msg.payload.value,msg.payload.device

Instead of this: msg.payload.time, msg.payload.value, msg.payload.device

The latter would crash my IBM Cloud application.

  1. The table name and parameters must all be uppercase, even if that's now how you defined them in your SQL statement.
arjunsanchala commented 5 years ago

Thank you for reply. I will check this.

On Wed, 7 Nov 2018, 5:57 p.m. jcostello93 <notifications@github.com wrote:

Sorry this is late, but in my experience, I've noticed two odd behaviors with this node:

  1. If you're binding parameters to a query, there cannot be a space between the word and comma. For example,

Do this: msg.payload.time,msg.payload.value,msg.payload.device

Instead of this: msg.payload.time, msg.payload.value, msg.payload.device

The latter would crash my IBM Cloud application.

  1. The table name and parameters must all be uppercase, even if that's now how you defined them in your SQL statement.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/smchamberlin/node-red-nodes-cf-sqldb-dashdb/issues/18#issuecomment-436607161, or mute the thread https://github.com/notifications/unsubscribe-auth/AnBI_xtuxTNmwFq8QO_iwVhyrrq8CzDtks5ustHIgaJpZM4WgyKt .