6 Replies Latest reply on Aug 24, 2012 3:55 PM by PCHIU

    listener 2.0 EA export problem

    PCHIU
      In listener 1.1.x release, we can do
      java -cp apex.jar:/path/to/ojdbc6.jar  oracle.dbtools.apex.utilities.APEXExport
      to export the applications. http://krisrice.blogspot.com/2010/10/apex-exportsplitter.html

      In 2.0 EA, I cannot find the apex.jar in the WEB-INF/lib directory. What is the new procedure to export all applications?

      Edited by: PC8888 on Aug 19, 2012 6:49 PM
        • 1. Re: listener 2.0 EA export problem
          Prabodh
          Hi PC8888,
          In listener 1.1.x release, we can do
          java -cp apex.jar:/path/to/ojdbc6.jar  oracle.dbtools.apex.utilities.APEXExport
          to export the applications. http://krisrice.blogspot.com/2010/10/apex-exportsplitter.html

          In 2.0 EA, I cannot find the apex.jar in the WEB-INF/lib directory. What is the new procedure to export all applications?>

          Did you execute the first step outlined in the blog?
          jar xvf  apex.war WEB-INF/lib/apex.jar
          It is this command that puts the apex.jar in the WEB-INF/lib folder.

          Cheers,
          • 2. Re: listener 2.0 EA export problem
            PCHIU
            Yes. apex.jar nowhere to be found
            oracle@11gxe:lib$ ll
            total 18920
            -rw-r--r-- 1 root root   81961 Aug 12 02:49 avalon-framework-4.2.0.jar
            -rw-r--r-- 1 root root 3318083 Aug 12 02:49 batik-all-1.7.jar
            -rw-r--r-- 1 root root    9877 Aug 12 02:49 cloud.jar
            -rw-r--r-- 1 root root    3573 Aug 12 02:49 cloudserviceapi.jar
            -rw-r--r-- 1 root root  386437 Aug 12 02:49 common.jar
            -rw-r--r-- 1 root root   57779 Aug 12 02:49 commons-fileupload-1.2.1.jar
            -rw-r--r-- 1 root root   83613 Aug 12 02:49 commons-io-1.3.1.jar
            -rw-r--r-- 1 root root   38015 Aug 12 02:49 commons-logging-1.0.4.jar
            -rw-r--r-- 1 root root  107748 Aug 12 02:49 db-common.jar
            -rw-r--r-- 1 root root 3079811 Aug 12 02:49 fop.jar
            -rw-r--r-- 1 root root  454192 Aug 12 02:49 identitystore.jar
            -rw-r--r-- 1 root root  215828 Aug 12 02:49 identityutils.jar
            -rw-r--r-- 1 root root 2102741 Aug 12 02:49 je-4.0.103.jar
            -rw-r--r-- 1 root root 1637761 Aug 12 02:49 ldapjclnt11.jar
            -rw-r--r-- 1 root root  128901 Aug 12 02:49 listener.jar
            -rw-r--r-- 1 root root 2111220 Aug 12 02:49 ojdbc6-11.2.0.jar
            -rw-r--r-- 1 root root   24609 Aug 12 02:49 ojmisc-11.2.0.jar
            -rw-r--r-- 1 root root   10278 Aug 12 02:49 oracle.dbtools.icap.jar
            -rw-r--r-- 1 root root 1546293 Aug 12 02:49 poi-3.5-beta5.jar
            -rw-r--r-- 1 root root  825715 Aug 12 02:49 resource-templates.jar
            -rw-r--r-- 1 root root  355096 Aug 12 02:49 static.jar
            -rw-r--r-- 1 root root  447280 Aug 12 02:49 ucp-11.2.0.jar
            -rw-r--r-- 1 root root  244453 Aug 12 02:49 xdb-11.2.0.jar
            -rw-r--r-- 1 root root   85686 Aug 12 02:49 xml-apis-ext-1.3.04.jar
            -rw-r--r-- 1 root root  569113 Aug 12 02:49 xmlgraphics-commons-1.4.jar
            -rw-r--r-- 1 root root 1393651 Aug 12 02:49 xmlparserv2-11.2.0.jar
            • 3. Re: listener 2.0 EA export problem
              Prabodh
              Hi PC8888,

              Looks like things are not the same in ApexListener 2 EA as in 1.1.X. There is no apex.jar included in the apex.war in 2 EA as you have already found out.

              The Blog is for 1.1 EA, and is not applicable to 2.0 EA is the only conclusion one can draw.


              Cheers,
              • 4. Re: listener 2.0 EA export problem
                Udo
                Hello Peter,

                you could still use the APEXExport that ships with APEX (subdirectory utilities/oracle/apex of your APEX installation package). The fact that it had been bundled with APEX Listener doesn't mean the other one is deprecated. I think they are actually the same, it's just more convenient to have everything in APEX Listener, e.g. because you already have your JDBC drivers in place...

                -Udo
                • 5. Re: listener 2.0 EA export problem
                  PCHIU
                  Hi Udo,

                  I completely forgot about the old way. Now that you mention it, it is still working. Thanks.
                  • 6. Re: listener 2.0 EA export problem
                    PCHIU
                    I was looking for way to export every from APEX and found something interesting.
                    Using the APEXExport method, with some shell script programming, you can dump the whole apex setup (workspace, css files, static files, images, feedback etc) to files easily. yay!

                    I was using apex.jar method all along and didn't realize, until today, the features between apex.jar and APEXExport are different. Probably you guys knew that already.

                    using the apex.jar method
                    oracle@11gxe:lib$ java -cp apex.jar:$ORACLE_HOME/jdbc/lib/ojdbc6.jar  oracle.dbtools.apex.utilities.APEXExport
                    Usage APEXExport -db  -user  -password  -applicationid  -workspaceid -instance -skipExportDate -expSavedReports -debug  
                        -db               : Database connect url in JDBC format 
                        -user             : Database username
                        -password         : Database password
                        -useAliasFileName : use alias.sql instead of f12345.sql
                        -application      : ID or name for application to be exported
                        -workspace        : Workspace ID or Name for which all applications to be exported
                        -outDir           : Directory to export to
                        -instance         : Export all applications
                        -skipExportDate   : Exclude export date from application export files
                        -expSavedReports  : Export all user saved interactive reports
                        -split            : Split the export files
                        -flat             : Split into a Flat file structure
                        -update           : < create update file >
                        -nochecksum       : < don't check for changes >
                    Using APEXExport directly
                    oracle@11gxe:lib$ java -classpath /u01/apex/utilities:$ORACLE_HOME/jdbc/lib/ojdbc6.jar oracle/apex/APEXExport 
                    Usage APEXExport -db  -user  -password  -applicationid  -workspaceid -instance -expWorkspace -expFiles -skipExportDate -expPubReports -expSavedReports -expIRNotif -expTranslations -expTeamdevdata -expFeedback -deploymentSystem -expFeedbackSince -debug  
                        -db:              Database connect url in JDBC format 
                        -user:            Database username
                        -password :       Database password
                        -applicationid :  ID for application to be exported
                        -workspaceid :    Workspace ID for which all applications to be exported or the workspace to be exported
                        -instance :       Export all applications
                        -expWorkspace :   Export workspace identified by -workspaceid or all workspaces if -workspaceid not specified
                        -expFiles :       Export all workspace files identified by -workspaceid
                        -skipExportDate : Exclude export date from application export files
                        -expPubReports :  Export all user saved public interactive reports
                        -expSavedReports: Export all user saved interactive reports
                        -expIRNotif :     Export all interactive report notifications
                        -expTranslations : Export the translation mappings and all text from the translation repository
                        -expFeedback :    Export team development feedback for all workspaces or identified by -workspaceid to development or deployment
                        -expTeamdevdata : Export team development data for all workspaces or identified by -workspaceid
                        -deploymentSystem : Deployment system for exported feedback
                        -expFeedbackSince :  Export team development feedback since date in the format YYYYMMDD     
                    Edited by: PC8888 on Aug 24, 2012 11:55 AM