tag:blogger.com,1999:blog-2473156384972050726.post7525879437506183318..comments2024-03-15T00:37:18.503-07:00Comments on Vishal's blog: My upcoming book - Oracle APEX 4.2 reportingVishal Pathakhttp://www.blogger.com/profile/01850811202460421677noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-2473156384972050726.post-25946485231099227482013-11-30T20:37:00.002-08:002013-11-30T20:37:00.002-08:00Hi Damir,
Jasper has SOAP web services as well. Y...Hi Damir,<br /><br />Jasper has SOAP web services as well. You can try those. The following guide talks in detail about these webservices.<br /><br />http://community.jaspersoft.com/sites/default/files/docs/jasperreports-server-web-services-guide.pdf<br /><br />Regards,<br />Vishal Vishal Pathakhttps://www.blogger.com/profile/16879954344929617672noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-36856693790939737572013-10-26T10:47:41.854-07:002013-10-26T10:47:41.854-07:00Visham,
THX for reply but...
"http://:/jasper...Visham,<br />THX for reply but...<br />"http://:/jasperserver[-pro]/rest//path/to/object?arg1=value1&arg2=value2&.."<br />is exactly what I want to avoid because user may change arguments and make URL tampering very easy ...<br /><br />And this was mine initial ask ... how to avoid that?<br />Brg<br />DamirDamir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-60798223471425738992013-09-25T04:18:00.037-07:002013-09-25T04:18:00.037-07:00Hi Damir,
On the question of Authentication:
The...Hi Damir,<br /><br /><b>On the question of Authentication:</b><br /><br />The following code is a part of the book.It shows the use of utl_http.set_authentication function to pass the credentials that can be used for authentication. The book also demonstrates the method to pass credentials from the URL itself using other examples<br /><br />DECLARE<br /> l_http_req UTL_HTTP.req; l_http_resp UTL_HTTP.resp;<br /> l_web_serv_end_pt_url VARCHAR2 (2000) := 'http://localhost:8444/jasperserver-pro/rest_v2/reports/reports/samples/AllAccounts.pdf';<br /> l_blob BLOB; l_raw RAW(32767);<br />BEGIN<br /> l_http_req := UTL_HTTP.begin_request (l_web_serv_end_pt_url, 'GET', 'HTTP/1.1');<br />DBMS_LOB.createtemporary(l_blob, FALSE);<br /> utl_http.set_authentication(r => l_http_req, username => 'jasperadmin', password => 'jasperadmin', scheme => 'Basic', for_proxy => FALSE);<br />l_http_resp := UTL_HTTP.get_response (l_http_req);<br /> BEGIN<br /> LOOP<br /> UTL_HTTP.read_raw(l_http_resp, l_raw, 32767);<br /> DBMS_LOB.writeappend (l_blob, UTL_RAW.length(l_raw), l_raw);<br /> END LOOP;<br /> EXCEPTION<br /> WHEN UTL_HTTP.end_of_body THEN<br /> UTL_HTTP.end_response(l_http_resp);<br /> END;<br />owa_util.mime_header('application/pdf',false); htp.p('Content-length: ' || dbms_lob.getlength(l_blob));<br />owa_util.http_header_close; wpg_docload.download_file(l_blob);<br />end;<br /><br /><b>On the question of passing arguements:</b><br /><br />The following syntax can be used to pass arguements to restful webservice.<br /><br />http://:/jasperserver[-pro]/rest//path/to/object?arg1=value1&arg2=value2&..<br /><br />The book does not mention this syntax of passing arguements but has a link to http://community.jaspersoft.com/sites/default/files/docs/jasperreports-server-web-services-guide.pdf<br />The above documentation talks in detail about this syntax<br /><br /><b>Other methods</b><br /><br />Apart from RESTful webservice, SOAP web service of Jasper can also be used in APEX.<br /><br />The book has a link to http://www.opal-consulting.de/apex/f?p=20090928:4 as well. This link also gives a method to link Jasper to APEX<br /><br />Regards,<br />VishalVishal Pathakhttps://www.blogger.com/profile/16879954344929617672noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-69147639168165334102013-09-24T10:08:46.111-07:002013-09-24T10:08:46.111-07:00Hi!
Did I missed something but I didn't find ...Hi!<br /><br />Did I missed something but I didn't find how to pass parameters to Jasper Reports with proper security...I mean no way for URL tampering or any kind of modifications to sent parameters to Jasper.<br /><br />Hope I'll get an answer ..<br /><br />Brg<br />DamirDamir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-411807337993534042013-08-28T19:38:16.995-07:002013-08-28T19:38:16.995-07:00Thanks Martin. The book is out. It is now availabl...Thanks Martin. The book is out. It is now available at http://www.packtpub.com/oracle-apex-4-2-reporting/book<br /><br />-VishalVishal Pathakhttps://www.blogger.com/profile/16879954344929617672noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-87155006323093614762013-08-26T06:35:37.895-07:002013-08-26T06:35:37.895-07:00Very comprehensive list! Looking forward to readin...Very comprehensive list! Looking forward to reading it when it comes out.Martin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-24120820681601091912013-08-13T06:26:09.152-07:002013-08-13T06:26:09.152-07:00Congrats Man!...Congrats Man!...Balaji Subramaniamhttps://www.blogger.com/profile/17426159458414775720noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-34554072806017080822013-07-18T19:37:02.327-07:002013-07-18T19:37:02.327-07:00It will be available everywhere around the world o...It will be available everywhere around the world once it is published. The book can be pre ordered at http://www.packtpub.com/oracle-apex-4-2-reporting/book<br /><br />The book is expected to be published in the next month<br /><br />Vishal<br /><br />Vishal Pathakhttps://www.blogger.com/profile/16879954344929617672noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-81125913458637166322013-07-18T10:52:57.711-07:002013-07-18T10:52:57.711-07:00Hi Vishal,
Is your book available in India ???Hi Vishal,<br /><br />Is your book available in India ???Anonymousnoreply@blogger.com