Forum Discussion

daybon's avatar
daybon
New Contributor
3 years ago

Failed to initialize the connection that uses the [oracle.jdbc.driver.OracleDriver] driver on MAC

So for repeated question but I've been looking for answers for about 2 days now but i still cannot figure out how to fix the error   Failed to initialize the connection that uses the [oracle.jdbc.d...
daybon's avatar
daybon
New Contributor
3 years ago

Update: I fixed the previous issue

 

Now I am getting

 

Can't get the Connection for specified properties; java.sql.SQLRecoverableException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor (CONNECTION_ID=Decqmb4OStCmgM+HcfGPNw==)

  • richie's avatar
    richie
    Community Hero
    3 years ago
    Hey daybon,

    Sounds like you need to alter the connection string parameters.

    Im going off memory here, but i remember reading a couple of years ago about differences between the connection string when you are using SERVICE NAME rather than SID.

    So! Obviously i dont know what setup you have and whether youre trying to connect using SERVICE NAME rather than SID, but Im guessing you have either the wrong parameters in your connection string (if connecting via SID) or the wrong connection string itself. Im typing this on my phone, but if i remember correctly, the default Oracle connection string in the JDBC config is for the SID option.

    So if i were trying to fix this on my laptop, id confirm whether SID or SERVICE NAME and if SID, Id confirm the parm values with the DBAs and if using SERVICE NAME, id create a second Oracle connection string in the JDBC preferences matching the published layout for trying to connect using JDBC using SERVICE NAME.

    Cheers,

    Rich

Recent Discussions