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
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.
answered 27 Mar '13, 07:27
Ibrahim Sand... ♦♦