Forum Discussion

Arun05's avatar
Arun05
New Contributor
10 years ago
Solved

JDBC connectivity to SQL Azure using SoapUI Basic.

Hi ,

 This is regarding JDBC connectivity to SQL Azure using SoapUI Basic. I was referring to Azure site to get the relevant driver and connection string. (https://azure.microsoft.com/en-us/documentation/articles/sql-database-develop-java-simple-windows/) .

I downloaded SQLJDBC driver (version4.2) and added its jar to ext folder of SoapUI . For my SoapUI project i added a JDBC step with driver (com.microsoft.sqlserver.jdbc.SQLServerDriver) and connection string (jdbc:sqlserver://<myServer>.database.windows.net:1433;database=<mydatabase>;user=<myusername>;password=<mypassword>;encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30; ).

My machine's port 1433 is open to make such communication. I am able to make connection through my eclipse editor using same string but this is not working through my SoapUI JDBC step or script step . I am neither able to see any error or logs for this , neither able to track any such TCP message sent through my machine.
 

Can you please suggest if I am missing out anything here.

Thanks,
Arun

JDBC
SoapUI
SQL Azure

1 Reply

Sort By
  • shamek's avatar
    shamek
    New Member
    5 months ago
    Copy Link
    gacekk wrote:

    Another issue I have is appears that when I try to move test case folders to parent folder testcasetree/move/foldertomoveid/to/0 or same with release ID after slash at the end does not work. Is there other way to moce test case folder to release parent folder?

    You need to use:
    .../testcasetree/move/{imported_folder_id}/{release_id}/to/0/{release_id}