[IBMiOSS] Is anybody else finding issues using node.js with the DB2 toolkit?

Hi,

Our application development team are currently trying out node.js (v6) as a proof of concept on our IBM i, but have hit a number of problems already with accessing local DB2 tables using the (new) DB2 toolkit functions.

Is anybody else trying it out and encountering the the sort of problems we have been, which are such things as...


1. Intermittent memory fault/core dump errors on repeated fetches.

2. Truncation occurring when retrieving the contents of text columns > 1024 characters.

3. Intermittent failure and error 'SQLSTATE=22504 SQLCODE=-191 Mixed data or UTF-8 data not properly formed.' when inserting a row into a table with an empty string ('') value for a text column.

The developer has had to do workarounds for the issues he's found, but they aren't ideal. Some involve having to use blocking functions instead of non-blocking.

I've opened PMRs for all of these which are being looked at but was wondering what others experiences have been and whether we are just unlucky, possibly doing something wrong, or others have found the same.

I'm trying to advocate IBM i as being the right platform to use for these sort of projects since 5733OPS was made available, but it's getting harder to justify with each issue that's found.

Thanks,

Mark.

________________________________
Proud partner of The Ageas Bowl.

This email has been sent by and on behalf of one or more of Ageas (UK) Limited (registered no: 1093301 ), Ageas Insurance Limited (registered no: 354568), Ageas Retail Limited (registered no: 1324965), or a subsidiary of Ageas (UK) Limited (together "Ageas UK"). Ageas UK companies are registered in England and Wales, and each entity's registered office is Ageas House, Hampshire Corporate Park, Templars Way, Eastleigh SO53 3YA.

Ageas Retail Limited is authorised and regulated by the Financial Conduct Authority. Financial Services Register Number: 312468.

Ageas Insurance Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority. Financial Services Register Number: 202039

This e-mail together with any attachments are intended for the addressee only and may be private and confidential. If you are not the intended recipient, or the person responsible for delivering it to the intended recipient, you must not open any attachments, or copy, disclose, distribute, retain or use this e-mail, including any attachments, in any way whatsoever; please return it to us immediately using the reply facility on e-mail.

Consider the environment and think before you print this email.