What is the JDBC url i need to give in the Database connector in order to query my external Oracle Db?
Hi everyone, I have been given some details in this format and need to connect to this DB: (values changed) Host/Server: uatdb1.xxxxxxxxxxxx.me-south-1.rds.amazonaws.com Port: 0000 DB Instance Name: ORCL User ID/Schema: aaaaa Password: pppppp TNS UATDB1= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=uatdb1.xxxxxxxxxxxx.me-south-1.rds.amazonaws.com) (PORT=0000) ) (CONNECT_DATA= (SERVER=dedicated) (SERVICE_NAME=ORCL) ) ) I have the following menu In the username and password areas i have given the appropriate inputs, but what do i enter in the jdbc url? Thanks in advance, Anirudh
JDBC uses the following format for connection URLs...
From your screenshot, it looks like you’ve missed the ‘//’ characters between the driver and hostname.
Hope this helps.
For everyone who is coming over this question:
In oracle jdbc urls you have to differentiate between service or SID.