Forum Discussion

StevenC's avatar
StevenC
Contributor
7 years ago
Solved

The JDBC driver [oracle.jdbc.driver.OracleDriver] is already registered.

Using SoapUI Pro in ReadyAPI 1.9.0 I am all of a sudden having trouble connecting to our Oracle Database. Testcases which have Database Steps in them which worked in the past can no longer connect. W...
  • StevenC's avatar
    StevenC
    7 years ago

    Found the issue.

    We have to reset our DB passwords every 60 days and I last had to update it at the same time as they made the server change to require a VPN connection to access the database. Oracle in their infinite wisdom allows you to create passwords that includes the at sign. SQLDeveloper apparently uses a connection string format which allows for this however the oracle jdbc driver connection strings do not because they use the at sign to denote the beginning of the server address (name or IP), then rather than giving a useful error code indicating that the connect string was incorrect they just throw an "unable to connect" error.

  • StevenC's avatar
    StevenC
    Contributor
    7 years ago

    no we do not use a tnsnames.ora file

    Further even if we did that would not explain why I used to be able to connect to the database but cannot any longer as nothing about that has changed.

    Literally the only change was in network routing where I need to be on the VPN to access it however I verified that I can reach the database on the VPN by connecting via SQLdeveloper at the same time I was unable to connect via SoapUi