ol test connection

[module folder]> ol test connection --url jdbc:jtds:sybase://52.206.218.139:5000 --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:jtds:sybase://52.206.218.139:5000 --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

ol add for prepared statement (query)

[module folder]> ol add --query "SELECT * FROM ACCOUNTS WHERE ID = ?" --operation-name account-by-id

[module folder]$ ol add --query "SELECT * FROM ACCOUNTS WHERE ID = ?" --operation-name account-by-id

Return to tutorial

ol add for stored procedure

[module folder]> ol add --executable demo_db.dbo.proc_get_employee_by_id --temp-table-query "SELECT * FROM ACCOUNTS WHERE ID = 'A100000001'"

[module folder]$ ol add --executable demo_db.dbo.proc_get_employee_by_id --temp-table-query "SELECT * FROM ACCOUNTS WHERE ID = 'A100000001'"

Return to tutorial

ol add for stored procedure in advanced mode

[module folder]> ol add --executable demo_db.dbo.proc_get_employee_by_id --advanced-result-set-query "EXEC proc_get_employee_by_id @val = 1;"

[module folder]$ ol add --executable demo_db.dbo.proc_get_employee_by_id --advanced-result-set-query "EXEC proc_get_employee_by_id @val = 1;"

Return to tutorial