SQLLine is a java command line tool client
sqlline -u "jdbc:sqlserver://hostName.database.windows.net:1433;databaseName=dbName" -n login -p 'password' -e "select 1"
where:
- name: Testing the JDBC connectivity
command: "{{ sqlline_home }}/sqlline -u 'jdbc:sqlserver://{{ infa_db_endpoint }}:{{ infa_db_port }};databaseName={{ infa_domain_db_name }}' -n '{{ infa_db_user }}' -p '{{ infa_db_password }}' -e 'select 1'"
register: jdbc_test_result
changed_when: "jdbc_test_result.rc != 0"
failed_when: "jdbc_test_result.rc != 0"