dbgate / dbgate

Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application
https://dbgate.org
GNU General Public License v3.0
4.75k stars 279 forks source link

oracle version is too old, The thin mode is not supported #843

Open acracker opened 5 days ago

acracker commented 5 days ago

How to solve this problem

Oracle version : 11.2 error: Connect failed: NJS-138: connections to this database server version are not supported by node-oracledb in Thin mode Show detail

Error: NJS-138: connections to this database server version are not supported by node-oracledb in Thin mode at Object.h [as throwErr] (D:\dbgate\resources\app.asar\packages\plugins\dbgate-plugin-oracle\dist\backend.js:2:253451) at t.exports.connect (D:\dbgate\resources\app.asar\packages\plugins\dbgate-plugin-oracle\dist\backend.js:2:369839) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async Object. (D:\dbgate\resources\app.asar\packages\plugins\dbgate-plugin-oracle\dist\backend.js:2:318608) at async Object.connect (D:\dbgate\resources\app.asar\packages\plugins\dbgate-plugin-oracle\dist\backend.js:2:664500) at async e.exports (D:\dbgate\resources\app.asar\packages\api\dist\bundle.js:2:2118145) at async process. (D:\dbgate\resources\app.asar\packages\api\dist\bundle.js:2:2076719)

Error JSON: { "code": "NJS-138" }

Connection: { "server": "", "engine": "oracle@dbgate-plugin-oracle", "sshMode": "userPassword", "sshKeyfile": "", "serviceName": "", "user": "", "password": "***" }

Platform: win32

ProjectInfinity commented 4 days ago

That version is from 2013. Is it not time to update? :)

acracker commented 3 days ago

That version is from 2013. Is it not time to update? :)

yes, Government enterprise. If it is not necessary, will not upgrade the version

acracker commented 3 days ago

This link may be the solution, but I don't know how to fix it

https://github.com/oracle/node-oracledb/issues/1587

paulovnas commented 1 day ago

I was supposed to comment on this at the beginning of the month, then I saw that someone else went through this too.

I even tried the oracledb.initOracleClient() solution However, it still didn't work here, since you need to have instantClient configured, but I have it configured and it still doesn't work correctly.

I loved dbgate, I really wanted it to work with Oracle too 💔