node-oracledb icon indicating copy to clipboard operation
node-oracledb copied to clipboard

Not receiving CQN notifications while in Node REPL

Open maxsatula opened this issue 5 years ago • 4 comments

A simple CQN example does not receive notifications when running in Node interactive REPL.

Example code is here https://gist.github.com/maxsatula/90584883001f95214e619bbd2022da08

While having successful CQN subscription, events are not coming upon table changes in REPL mode.

The same code works absolutely fine in any non-interactive mode I could think of.

> process.platform
'linux'
> process.version
'v12.14.1'
> process.arch
'x64'
> require('oracledb').versionString
'4.1.0'
> require('oracledb').oracleClientVersionString
'19.3.0.0.0'

Actually that is WSL on Windows 10 if that matters. Oracle Instant Client is used.

Database version is 11.2.0.4.0

maxsatula avatar Feb 26 '20 21:02 maxsatula

Tried both 4.1.0 and 4.2.0 versions

maxsatula avatar Feb 26 '20 21:02 maxsatula

Same problem. CQN subscription works when I run the script in node but doesn't work when I run it in node REPL.

> process.platform
'win32'
> process.version
'v13.5.0'
> process.arch
'x64'
> require('oracledb').versionString
'4.2.0'
> require('oracledb').oracleClientVersionString
'19.3.0.0.0'

vfro avatar Feb 26 '20 21:02 vfro

Is this just a curio, or do you have some importance for this?

At first glance, it sounds like a REPL behavior which may be out of our control. Have you done any investigation into REPL limitations?

cjbj avatar Feb 26 '20 22:02 cjbj

It is definitely not an emergency, all the time spent to figure it out has already been spent. No REPL limitations I’m aware of, all other asynchronous stuff been working well in REPL except oracledb CQN callbacks. I have a concern that a possible bug sitting at root cause of this may cause other unwanted effects outside of the discussion scope.

maxsatula avatar Feb 26 '20 23:02 maxsatula