0 Replies Latest reply on Jul 10, 2019 5:50 PM by 4003809

    jdbc connection error - after deploying an API to oracle web logic server

    4003809

      Hi,

       

      I am encountering trouble to connect to the oracle autonomous database. The api works locally, but not when I start to deploy it.

       

      It gives the error: Failed to obtain JDBC Connection; nested exception is java.sql.SQLRecoverableException: IO Error: Invalid connection string format, a valid format is: \"host:port:sid\"

       

      in my code, i have the connection string as: ADW_JDBC_URL = "jdbc:oracle:thin:@<adw.service.alias>_low" + "?TNS_ADMIN=<wallet.location>";

      and then in my wallet folder, i have a tnsnames.ora file which specifies what  <adw.service.alias>_low is.

       

      I am not sure why after deployment, this code does not work any more. Any help would be appreciated! Thanks