armygrad
2 years agoContributor
JDBC Oracle thin connection string
HI
I have the connection string below
dbc:oracle:thin:A_USER[IRM]/PASS_VALUE@oda23:1111:DBSCHEMA
And im getting the error below, i am using the details from the connection for this schema that is in PL/SQL Developer, and its connecting to the DB
With no issues, what am i doing wrong?
Cannot get a connection for the specified properties java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor (CONNECTION_ID=Ks5zc1X4QcCabkq8DQ6lxQ==)
This is my connection string template
jdbc:oracle:thin:<USER>/<PASSWORD>@<HOST:127.0.0.1>:<PORT:1111>:<SID>
Thanks