For AI agents: visit https://docs.ol-hub.com/llms.txt for an index of all pages formatted in Markdown and endpoints in OpenAPI.
- Go to HOME.ol\cli\
- Create the extra-classpath-resources folder in the cli folder.
- Save the following files in extra-classpath-resources.
- db2jcc_license_cu.jar
- db2jcc4-10.5.jar
- db2jcc_license_cisuz.jar
Return to tutorial
[module folder]> ol test connection --url jdbc:db2://192.86.32.238:5035/DALLASB --driver-class-name --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 [some_value] --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 --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 [some_value] --pool-max-size 5 --use-time-zone-as-region false
Return to tutorial
[module folder]> ol add --procedure GET_ACCOUNT_ORDERS --schema DEMO001 --advanced-result-set-query CALL DEMO001.GET_ACCOUNT_ORDERS('A100054321')
[module folder]$ ol add --procedure GET_ACCOUNT_ORDERS --schema DEMO001 --advanced-result-set-query CALL DEMO001.GET_ACCOUNT_ORDERS('A100054321')
Return to tutorial
