Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Not receiving CQN notifications while in Node REPL #1217

Open
maxsatula opened this issue Feb 26, 2020 · 4 comments
Open

Not receiving CQN notifications while in Node REPL #1217

maxsatula opened this issue Feb 26, 2020 · 4 comments
Labels

Comments

@maxsatula
Copy link

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 maxsatula added the bug label Feb 26, 2020
@maxsatula
Copy link
Author

Tried both 4.1.0 and 4.2.0 versions

@vfro
Copy link

vfro commented Feb 26, 2020

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'

@cjbj
Copy link
Member

cjbj commented Feb 26, 2020

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?

@maxsatula
Copy link
Author

maxsatula commented Feb 26, 2020

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants