Forum Discussion

sandeepkb's avatar
sandeepkb
New Contributor
7 years ago

how to configure Database step when DB connection is not jdbc url

connection string connects to oracle db is in the format 

 

(DESCRIPTION = (ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCPS)(HOST = {hostname})(PORT = 2484)))(CONNECT_DATA =(SERVICE_NAME = {SERVICE_NAME})))

 

When I tried these connection details in SOAPui  Pro I get below message: 

Can't get the Connection for specified properties; java.sql.SQLRecoverableException: IO Error: An existing connection was forcibly closed by the remote host, connect lapse 1 ms., Authentication lapse 0 ms.

  • sandeepkb's avatar
    sandeepkb
    New Contributor
    7 years ago

    I have some progress: I tried this in sql developer and works perfectly fine

     

    jdbc:oracle:thin:Username/Password@(DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = protocol) (HOST = hostname) (PORT = port)      )    )    (CONNECT_DATA =      (SERVICE_NAME = service_name)    )  )

     

    Have gone and updated the oracle thin driver on preferences to the one above and when I add db step it gives me below error

     

    Failed to get a connection for the specified properties; java.sql.SQLRecoverableException: IO Error: General SSLEngine problem, connect lapse 4 ms., Authentication lapse 0 ms.