9 Replies Latest reply: Nov 23, 2012 8:58 AM by 965124 RSS

    Jasper response parsing

    965124
      Hi All,

      I have a lot of problems in parsing SOAP web service response of Jasper
      The major problem is that the report document in the response appears at the end of the response. It appears even after the closing tag of the soap response. The images in the response are returned in binary form.

      Because the response is partially binary and partially characters so I am not able to parse it correctly. If i make a web service call using APEX webservice references and then put the response in a collection then I get an error. I guess APEX collections are not able to handle this response. I say this because If I call the webservice using UTL_HTTP, then I get the response.

      Has anybody parsed a Jasper SOAP web service response which has a report in it.

      I have gone through http://www.opal-consulting.de/apex/f?p=20090928:4: but I am not using it.

      My question is focused on parsing the response and not on finding other ways of getting it

      Thanking you in anticipation of your kind help

      Regards
        • 1. Re: Jasper response parsing
          965124
          Any thoughts are appretiated

          Regards
          • 2. Re: Jasper response parsing
            965124
            Any thoughts?
            • 3. Re: Jasper response parsing
              Dietmar Aust
              Hi,
              I have gone through http://www.opal-consulting.de/apex/f?p=20090928:4: but I am not using it.
              why don't you want to use the integration kit? Is there a problem with it?

              Or are you specifically integrating with the JasperServer portal?

              Cheers,
              ~Dietmar.
              • 4. Re: Jasper response parsing
                965124
                Hi Dietmar,

                Respect to you

                The reason of not choosing the solution is 2 fold

                I believe that your solution includes a web application and some pl sql packages. I feel that web services are simpler to use and hence I prefered this solution. I havnt downloaded the package but I believe that the code must be wrapped hence I will not be able to appretiate the beauty of the solution.

                The second reason to press for getting a solution for SOAP web service is that I want to understand the parsing of soap response of Jasper web service. The response is such that when I store it in an APEX collection, I get an error. Parsing using string functions also does not work. Its a strange response and I wanted to understand its parsing.

                I believe that you must have found a way out of this trouble since you have a solution in place. I humbly request you to suggest a possible way to parse SOAP web service response of Jasper

                Regards
                • 5. Re: Jasper response parsing
                  Dietmar Aust
                  Hi anonymous ;),
                  I believe that your solution includes a web application and some pl sql packages. I feel that web services are simpler to use and hence I prefered this solution.
                  I havnt downloaded the package but I believe that the code must be wrapped hence I will not be able to appretiate the beauty of the solution.
                  Well, yes and no. Here is a view of the architecture: http://www.opal-consulting.de/downloads/JasperReportsIntegration/images/screenshot.151.png .

                  The communication begins in the database by using the plsql package interface (the package is NOT wrapped by the way). There you specify which report you want to use on the server side (tomcat) including which parameters. The plsql package will just construct the url and call the url of the j2ee application residing in the tomcat using utl_http.

                  In the tomcat your report will be used and a jdbc connection will be initiated to call the database again.

                  In the whole process you don't need an installation of JasperServer, just my integration kit on tomcat. It includes the required JasperReports libraries.
                  I believe that you must have found a way out of this trouble since you have a solution in place. I humbly request you to suggest a possible way to parse SOAP web service response of Jasper
                  Well, I cannot help you here. If you want to learn to handle SOAP request, then please do. But I don't like the complicated stuff ;). Thus I have implemented a simple url interface which does the job nicely. All you get returned is a blob containing the generated report in the desired format .... very simple :).

                  Cheers and all the best,
                  ~Dietmar.
                  • 6. Re: Jasper response parsing
                    965124
                    Thanks Dietmar,

                    I thought that the pl sql packages in your solution are a wrapper around some java code which work with jasperserer using webservices and the java code is encapsulated in the WAR.
                    Anyways, I was clearly wrong. If i understand correctly, I believe, you are using Jasper classes and then you have a java application which generates the reports using Jasper libraries. If my understanding is correct then your inplementation is indeed very simple. Your WAR application then becomes an alternative to Jasper server. The only single doubt I have is, do we have to buy the license from Jasper if we use your solution? I believe we might have to buy it because the classes used in the solution are a property of Jasper and Jasper server is licensed. If we do not have to buy the Jasper license then do we have to buy the solution from you or is the solution free? If we have to buy the solution from you then do we also have some trial version of your solution for which we dont have to pay money?

                    Thanks for a detail explaination of the architecture and hope to get your kind reply on the pricing so that we could use your incredible solution in our project

                    Regards,
                    • 7. Re: Jasper response parsing
                      Dietmar Aust
                      Hi ??? whoever you are ???,

                      well, this is all very simple :).

                      My solution is available for free, you just don't get access to the Java source code. Here is the BSD license I use, no strings attached: http://www.opal-consulting.de/apex/f?p=20090928:6:1385809892154478::NO:6::

                      Since the JasperReports library is available under LGPL v3, you can freely use it in your applications as governed by the LGPL v3. You can have a look at the slides of my last KScope presentation on page 14: http://daust.blogspot.de/2012/07/odtug-kscope12-slides-and-samples.html

                      Be sure to use the officially supplied libraries from JasperReports, they make sure that the LGPL license agreement holds. Be aware of the special case of iText, version 2.1.7 is the last version using LGPL!!!

                      Thus you don't need to use JasperServer. In effect there is a difference between the licenses of the JasperReports library (LGPL) vs. the JasperServer (AGPL). Thus you would have be more careful when using JasperServer!.

                      Hope that helps,
                      ~Dietmar.

                      -----
                      blog: [ http://daust.blogspot.com ] JDD-Spreadsheet-Suite: [ http://jdd-software.com ]
                      JasperReportsIntegration: [ http://www.opal-consulting.de/tools ] [ https://www.opal-consulting.de/forums  ]
                      • 8. Re: Jasper response parsing
                        965124
                        Thanks for all the info, Dietmar. It was a pleasure and an honour to talk to you

                        Regards
                        • 9. Re: Jasper response parsing
                          965124
                          Appretiate any reply on the original question of Jasper webservice parsing

                          Regards