This discussion is archived
9 Replies Latest reply: Nov 23, 2012 6:58 AM by 965124 RSS

Jasper response parsing

965124 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    Any thoughts are appretiated

    Regards
  • 2. Re: Jasper response parsing
    965124 Newbie
    Currently Being Moderated
    Any thoughts?
  • 3. Re: Jasper response parsing
    DietmarAust Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    DietmarAust Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    DietmarAust Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thanks for all the info, Dietmar. It was a pleasure and an honour to talk to you

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

    Regards

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points