I am not sure who/what is to blame but what I see is that when I use api_datasource.printToExcel and there is no output, that the Oracle session that ran the code is not returned to the jdbc pool. There are no messages in the server.log, the excel file is generated with just the headers in it and - as expected - without data. The function that generates the data is a table function and the loop that is supposed to pipe the rows is empty; no rows satisfied the selection. Is this a formspider problem or a glassfish problem? The last sql from that session is "BEGIN :1 := BDF_ENGINE.generateExcelXML(:2 ,:3 ,:4 ); END;" After the call, the session is waiting for SQL*Net message from client, indicating that the Oracle session expects something from the client .... the middletier.

thanks for any insights, Ronald.

asked 27 Mar '13, 04:00

ik_zelf's gravatar image

accept rate: 16%

Hi Ronald,

Thank you for the feedback, there was a problem related to the middletier. We have fixed this problem, it will be available in the next version.

Best Regards,


answered 27 Mar '13, 07:27

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
accept rate: 25%

Thanks for your response Ibrahim, good to know it is already fixed. Is an ETA available for the availability for the new version?

regards, Ronald.

(27 Mar '13, 07:44) ik_zelf

Hi Ronald,

The new version will be available within next week.


(27 Mar '13, 08:17) Ibrahim Sand... ♦♦

I just upgraded to FS-1.3.0 and tested the download to excel as specified above. It does download, as before but now even the DAS no longer responds and none of the application is available after downloading an empty excel file. The behaviour changed but problem is not solved.

(11 Apr '13, 14:24) ik_zelf

Thanks for your feedback and collaboration Ronald. We have checked the problem again and noticed that the issue occurs only while exporting excel files in XSLX format. Essentially, it was caused by an undocumented difference existing in the Apache POI library, for XLSX export. The problem is fixed for the next version.

(13 Apr '13, 05:40) Ibrahim Sand... ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 27 Mar '13, 04:00

Seen: 1,826 times

Last updated: 13 Apr '13, 05:40

© Copyright Gerger 2017