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

Hi Aaron,

Thanks for the link/suggestion. I know that for the application code the developer is using connection pools, but we'll take a look at the article in case something has been missed on that front.

Thanks,

Mark



-----Original Message-----
From: OpenSource [mailto:opensource-bounces@xxxxxxxxxxxx] On Behalf Of Aaron Bartell
Sent: 03 August 2017 14:58
To: IBMi Open Source Roundtable
Subject: 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.

--
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.

--
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.

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.