Click here to Skip to main content
15,441,629 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Below are my connection settings for Oracle SQL Developer with tnsnames.ora

Imgur: The magic of the Internet[^]

The pattern of jdbc string required is as below :

jdbc:oracle:thin@:1521:<database_name>

What I have tried:

I have tried the following :
jdbc:oracle:thin:@ServerIP:1521:test2 , jdbc:oracle:thin:@ServerIP:1521:orcl.5bfzmyo25mfutjqfmvvj0cmrya.rx.internal.cloudapp.net:test2

But it is not connecting.
Posted
Updated 15-Jul-22 2:47am
v3
Comments
Richard Deeming 28-Jan-21 3:54am    
We have no idea what your connection details are supposed to be, so we can't tell you why your connection string isn't working.

Check that you connection string parameters are valid: Features Specific to JDBC Thin[^].
 
Share this answer
 
Check if your firewall does not block the port.

Also see: Java JDBC - How to connect to Oracle using Service Name instead of SID - Stack Overflow[^]
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900