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

Hi Mark,

Have you seen this article? http://krengel.tech/mcpress-node-db-pool

I do not know if it will address any of your current issues, but when I see
"intermittent", well, if you're not using connection pools then you will
most likely have issues.

Aaron Bartell
IBM i hosting, starting at $157/month. litmis.com/spaces


On Thu, Aug 3, 2017 at 8:38 AM, Mark Ford <Mark.Ford@xxxxxxxxxxx> wrote:

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.
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.