Page 1 of 1

jdbc use

Posted: Fri Oct 20, 2017 6:25 am
by danpif
Good morning
I'm trying profoundjs with node installed on Windows 10 and not IBMI (unfortunately the system is V5R4M0 and I can not use connector module), I tried node-jt400 to access the data on the system.
If I use node-jt400 without Profoundjs everything OK, if used within the Framework always get the error:
' Profound. JS worker process 10944 ended with code 3221225477.
At EventEmitter. <anonymous> (C:\pjs\node_modules\profoundjs\server\server.js

Any ideas?

Greetings
Danilo

Re: jdbc use

Posted: Mon Oct 23, 2017 2:53 pm
by Scott Klement
Are you using fibers? In order to use Profound.js you'll need to make your calls use fibers instead of callbacks. Details can be found here:
http://www.profoundlogic.com/docs/display/PUI/Fibers

And here's the API reference for the various fibers API calls:
http://www.profoundlogic.com/docs/pages ... d=33096322

Re: jdbc use

Posted: Tue Oct 24, 2017 6:56 am
by danpif
Thanks for the reply!

I have already tried with fiber without results
Example
Without using Profoundjs:
--------------------------------------------------------------------------------------
var jt = require('node-jt400');

var pool = jt.pool({host: 'SomeHost', User: 'SomeUser', Password: 'Password'});

Pool.Query ('SELECT * from SomeTabel where field like \'%A% \''). Then (function (ret) {
Console. log (ret);
});
--------------------------------------------------------------------------------------
all ok

With Profoundjs:
--------------------------------------------------------------------------------------
function test () {
var jt = require('node-jt400');
var pool = jt.pool({host: 'SomeHost', User: 'SomeUser', Password: 'Password'});

ret = pjs.fiber.runPromiseNoFail(pool.Query('SELECT * from SomeTabel where field like \'%A% \''));
Console. log (ret);
}
exports.run = test;
--------------------------------------------------------------------------------------
Error: Profound. JS worker process 15888 ended with code 3221225477.
At EventEmitter. <anonymous> (C:\PJS\NODE_MODULES\PROFOUNDJS\SERVER\SERVER.JSE: 33:31)
At EmitThree (events. JS: 135:13)
At EventEmitter. Emit (events. JS: 216:7)
At ChildProcess. Worker. Process. Once (internal/cluster/master. JS: 185:13)
At Object. OnceWrapper (events. JS: 318:30)
At EmitTwo (events. JS: 125:13)
At ChildProcess. Emit (events. JS: 213:7)
At Process. ChildProcess. _ Handle. OnExit (internal/child_process. JS: 200:12)

Greetings
danilo

Re: jdbc use

Posted: Mon Jan 15, 2018 9:30 pm
by danpif
any idea

Re: jdbc use

Posted: Tue Jan 16, 2018 8:49 pm
by Kaylee Law
Hello Danpif!

This looks like you may have encountered a bug with profound.js. Could you please contact Profound Logic Support so that we can create an issue for you. You can either reach us via the contact form on our website http://www.profoundlogic.com/contact?type=support, or you can email us directly at support@profoundlogic.com

Thanks
~Kyle Law