Click here to Skip to main content
14,825,149 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

[IMAGE Link]

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 28-Jan-21 3:11am
v2
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[^].
   
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[^]
   
v2

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

  Print Answers RSS
Top Experts
Last 24hrsThis month



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