Hi All,
I am working on implementing continuous integration for Oracle APEX clound application. I want to export and then import application using command line. I did some research and found that this can be done using APEXEXPORT command.
Environment:
APEX cloud
Build Environment:
Windows 10 Pro
SQLcl is installed
APEXExport is downloaded and available on VM
ojdbc8.jar downloaded from https://www.oracle.com/database/technologies/jdbc-ucp-122-downloads.html
Environment Variables set as follows:
sqlcl : C:\Setup\sqlcl\bin
APEX_BASE: C:\Setup\apex_20.1_en\apex
ojdbc8.jar: C\Setup\.\ojdbc8.jar
%APEX_BASE%\utilities
I tried APEXExport from utilities folder
java oracle.apex.APEXExport -db <apex cloud domain>:1521:xe -user "username" -password "password" -applicationid 001 -expOriginalIds
But i am getting an error "
Exception in thread "exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdbc/OracleDriver"
I want to know following:
- Is it possible to export APEX cloud application from remote machine?
- if yes what will be ( i am new to Oracle hence i am not sure about these values )
- hostname: www.apex.com or host name from url that i used to log in to apex application?
- service name: where can i find this information
- What could be the reason for above error? any pointers to resolve this?
- How sqlcl can be used to export application? if this is possible can you give connection command to apex server?
Any help is greatly appreciated.
Thanks,
Rahul