QUESTION: Is there any support for oracle db connection over service name?

[mustafaguven]

Details:
I want to connect to oracle db with service name but could not find any way to get connected. Is there a way to do that or such feature not supporting yet?

the url pattern is like below

jdbc:oracle:thin:@//111.111.111.111:1521/service_name

Version Information [might be relevant to your issue]
Operating System:
web browser

[isauran]

same problem

rinie/dbgate-plugin-oracle#1

[rinie]

In

dbgate/plugins/dbgate-plugin-oracle/src/backend/drivers.js

Line 58 in fee438c

connectString: useDatabaseUrl ? databaseUrl : port ? `${server}:${port}` : server,

connectString: useDatabaseUrl ? databaseUrl : port ? ${server}:${port} : server
Is used
https://node-oracledb.readthedocs.io/en/latest/user_guide/connection_handling.html#connection-strings

Suggests connectString : "mydbmachine.example.com:1521/orclpdb1"
So instead of databaseUrl:port, databaseUrl could be used?

[janproch]

Service name is supported in latest BETA

https://github.com/dbgate/dbgate/releases/tag/v5.2.10-beta.2

or you can use databaseUrl, mydbmachine.example.com:1521/orclpdb1
It is fixed now, username and password is required for db url

[rinie]

Nice! Op za 1 jun 2024 om 14:58 schreef Jan Prochazka ***@***.***>:

…

Service name is supported in latest BETA https://github.com/dbgate/dbgate/releases/tag/v5.2.10-beta.2 — Reply to this email directly, view it on GitHub <#528 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABK33IH6W3NNXKTVE56DBLZFHAOJAVCNFSM6AAAAAAWI3BP4KVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNBTGQ2DAMJWGE> . You are receiving this because you commented.Message ID: ***@***.***>

-- Met vriendelijke groeten, Rinie Kervel. Don't walk behind me, I may not lead. Don't walk in front of me, I may not follow. Just walk beside me and be my friend.