JDBC connection string for oracle not connecting

Question

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:

Copy Code

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 27-Jan-21 19:01pm

Amey D

Updated 28-Jan-21 3:11am

v2

Add a Solution

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.

2 solutions

Add a Solution

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

Richard MacCutchan · Answer 1 · 2021-01-27T22:50:00

Solution 1

Check that you connection string parameters are valid: Features Specific to JDBC Thin[^].

Permalink

Posted 27-Jan-21 22:50pm

Richard MacCutchan

RickZeeland · Answer 2 · 2021-01-28T03:11:00

Solution 2

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[^]

Permalink

Posted 28-Jan-21 3:11am

RickZeeland

Updated 28-Jan-21 3:17am

v2

JDBC connection string for oracle not connecting

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

JDBC connection string for oracle not connecting

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us