Forum Discussion

joso1's avatar
joso1
New Contributor
4 years ago

ReadyAPI connectivity to Azure SQL

 Any pointers to configure Azure SQL with ReadyAPI. I am getting the following error on the below connection string:   groovy code:   def db = [url:"jdbc:sqlserver://" + serverName+ ":" + serverP...
  • richie's avatar
    richie
    4 years ago
    Hey joso1,

    I did a bit of googling and for some versions of the adal jar there were missing dependencies, so you might want to check this isnt a problem with your version of the .jar file.

    Stackoverflow link: https://stackoverflow.com/questions/52270540/not-able-to-get-azure-token-using-adal4j-api

    I know youre trying to connect using groovy, but when i try and setup new db connections using jdbc in ReadyAPI!, quite often if im having problems i'll try and setup the connection in a db interrogation tool first (removing some of the complication) like say DBVisualiser/TOAD etc. The JDBC config required in the db tools is identical to ReadyAPI! so doing it this way i at least know that the jdbc connection string parameters are correct (as they can change based on how the db is setup) which is most of the problem to be resolved. Once ive got my connection setup in the db tools i then know if i replicate the settings in ReadyAPI! and it doesnt work, the problem cant be incorrect driver .jar nor incorrect jdbc connection url and that it has gotta be something else (sticking .jar in wrong directory, etc.)

    Thats all i got im afraid...perhaps the other forum members have some better ideas?

    Ta

    Rich