For AI agents: visit https://docs.ol-hub.com/llms.txt for an index of all pages formatted in Markdown and endpoints in OpenAPI.
[module folder]> ol test connection --url jdbc:sqlserver://52.206.218.139:1450;databaseName=demo_db --username sa --password Open1egacy! --properties [some_value] --query-timeout 3000 --timezone [some_value] --auto-commit-mode false --connection-test-query "SELECT * FROM ACCOUNTS WHERE ID = 'A100000001'" --pool-max-size 5 --use-time-zone-as-region false
[module folder]$ ol test connection --url jdbc:sqlserver://52.206.218.139:1450;databaseName=demo_db --username sa --password Open1egacy! --properties [some_value] --query-timeout 3000 --timezone [some_value] --auto-commit-mode false --connection-test-query "SELECT * FROM ACCOUNTS WHERE ID = 'A100000001'" --pool-max-size 5 --use-time-zone-as-region false
Return to tutorial
[module folder]> ol add --executable demo_db.dbo.proc_get_employee_by_id
[module folder]$ ol add --executable demo_db.dbo.proc_get_employee_by_id
Return to tutorial
[module folder]> ol add --executable demo_db.dbo.proc_get_employee_by_id --result-set-fetch-mode advanced --advanced-result-set-query "EXEC proc_get_employee_by_id @val = 1;" --combine-result-sets true
[module folder]$ ol add --executable demo_db.dbo.proc_get_employee_by_id --result-set-fetch-mode advanced --advanced-result-set-query "EXEC proc_get_employee_by_id @val = 1;" --combine-result-sets true
Return to tutorial
