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.

Sign up for GitHub

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

Jump to bottom

Can't connect to Oracle - Invalid node version: 10.16.3 #401

Closed
mtoma opened this issue Oct 2, 2019 · 3 comments
Closed

Can't connect to Oracle - Invalid node version: 10.16.3 #401

mtoma opened this issue Oct 2, 2019 · 3 comments
Labels
investigating

Comments

@mtoma
Copy link

mtoma commented Oct 2, 2019 •
edited

Describe the bug
Connection to an Oracle DB fails with: "Failed to install dependencies for OracleDB: Request DependencyInstaller/install failed with message: Invalid node version: 10.16.3"

To Reproduce
Create an Oracle DB connection and click "Connect"

Expected behavior
Should connect to the DB

Screenshots
Screenshot_20191002_120351

Desktop (please complete the following information):

  • SQLTools Version: 0.21.0
  • VSCode Version: 1.38.1
  • Dialect Used/Version: Oracle
  • OS: Linux (OpenSUSE Tumbleweed)

Additional context
node --version: v10.16.3
oracledb ** Node-oracledb 4.0.1 installed for Node.js 10.16.3 (linux, x64)

**Log:

INFO: Executing SQLTools.selectConnection
ERROR: Error:  { [Error: Request DependencyInstaller/install failed with message: Invalid node version: 10.16.3

	at /home/user/.vscode/extensions/mtxr.sqltools-0.21.0/extension.js:1:22985
	at /home/user/.vscode/extensions/mtxr.sqltools-0.21.0/extension.js:1:23392
	at Immediate.module.exports.messageQueue.size.setImmediate (/home/user/.vscode/extensions/mtxr.sqltools-0.21.0/extension.js:1:23936)
	at runCallback (timers.js:694:18)
	at tryOnImmediate (timers.js:665:5)
	at processImmediate (timers.js:647:5)] code: -32603, data: undefined }
@mtoma mtoma added the triage label Oct 2, 2019
@mtxr
Copy link
Owner

mtxr commented Oct 28, 2019

@mtoma did you get it working?

mtxr added a commit that referenced this issue Oct 28, 2019
@mtxr
package-managers: Add support to change package manager using setting…
45cbb89 
…s. Pending docs. Closes #414. Possible close to #401
mtxr added a commit that referenced this issue Oct 29, 2019
@mtxr
Package managers (#432)
79b26e7 
* package-managers: moved npm package manager to separated file

* package-managers: Add support to change package manager using settings. Pending docs. Closes #414. Possible close to #401

* package-managers: add docs for dependency manager

* package-managers: doc settings

* package-managers: redirects
@mtxr
Copy link
Owner

mtxr commented Nov 2, 2019 •
edited

Just a question, how did you get SQLTools to work use 4.0.1 while in the code it's fixed in 4.0.0? Did you manually updated or installed the driver in the extension folder?

This invalid node version is a message from node-oracledb package. not from the extension. I see in their page your node version should be supported.

Try to uninstall the extension and remove it from vscode extension folder to clear all caches.

  1. uninstall extension
  2. remove sqltool directory from https://code.visualstudio.com/docs/editor/extension-gallery#_where-are-extensions-installed
  3. reinstall extension
  4. try to connect to oracle again, it will ask to install dependencies again, accept and it should work.

@mtxr mtxr closed this as completed Nov 2, 2019
@mtxr
Copy link
Owner

mtxr commented Nov 2, 2019

Please, reopen if will still have issues after clearing deps cache reinstalling

@mtxr mtxr added investigating and removed triage labels Nov 2, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
investigating
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mtxr @mtoma