ORACLE-DB

ol test connection

[module folder]> ol test connection --url jdbc:db2://192.86.32.238:5035/DALLASB --driver-class-name oracle.jdbc.driver.OracleDriver --username demo --password 12345 --result-set-type RESULT_SET_TYPE --result-set-concurrency RESULT_SET_CONCURRENCY --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:db2://192.86.32.238:5035/DALLASB --driver-class-name oracle.jdbc.driver.OracleDriver --username demo --password 12345 --result-set-type RESULT_SET_TYPE --result-set-concurrency RESULT_SET_CONCURRENCY --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 stored procedure data fetching

[module folder]> ol add --executable DEMO.BANK_EXAMPLE.GET_ACCOUNT_BY_ID --overload [some_value]--update
[module folder]$ ol add --executable DEMO.BANK_EXAMPLE.GET_ACCOUNT_BY_ID --overload [some_value]--update

Return to tutorial

ol add for prepared statement (query) data fetching

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

Return to tutorial