Sunday, January 02, 2011

Issue with JasperReportsIntegration and the XML DB Listener

Hi guys,

I have helped somebody troubleshoot an issue with my JasperReportsIntegration kit. Although he had followed the instructions correctly, the report wouldn't show in the application.

It worked correctly when calling the j2ee application in the tomcat directly, but not when calling the report using the plsql interface xlib_jasperreports (which calls the j2ee server using utl_http)

The issue is related to the XML DB listener (also the primary http listener of Oracle XE) not supporting the http 1.1 standard. Since the XML DB listener only supports the 1.0 standard, the http parameter chunked transfer encoding is not working properly. 

When calling the report through my JasperReportsIntegration toolkit you would either see an empty report or nothing at all.

See this thread for more details and your options:

Also, this problem will not crop up when you use a plain Apache as a proxy to your XE installation.



Learco Brizzi said...

I had some similar problems when building manually a webservice over utl_http. In the end a 1.0 in stead of a 1.1 in a parameter solved the problem. Very frustrating.

Regards and a good 2011,

Unknown said...

Hi Learco,

thanks, all the best for you, too :).

Yepp, this is a really nasty issue, hard to track down, took me several hours, too :(.