This content has been marked as final. Show 9 replies
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?
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
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.Well, yes and no. Here is a view of the architecture: http://www.opal-consulting.de/downloads/JasperReportsIntegration/images/screenshot.151.png .
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 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 JasperWell, 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,
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
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,
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 ]