Srikanth Adapa

Bauke,

There are multiple reports being generated from the database and it is required to export to excel sheet for every individual report. so, it definitely counts the DB hits.

But currently, I am concerned to export the data that was already retrieved on the page to an excel sheet. I have done the same by adding a mime type for the same code as a seperate file.
<% response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-Disposition", "attachment; filename=testone.xls"); %

But it was required to hit the database again in this scenario.

will there be any other option of using the data that was retrieved in the jsp as a cache to open an excel sheet with the same data?

Please suggest me with a proper option.

Hi all,

I have retrieved data from back end to jsp page. I have used MIME TYPE to export the same data to an excel sheet. But I have used the similar code written for retrieval of data into jsp page. i.e., I was using the same logic twice to retrieve the data, and hitting the data base twice. Is there any way to export the data to excel directly from jsp page, rather than hitting the database again. Pl let me know if any suggestions.


Many thanks in advance

Hi all,

I need to retrieve a document which is external to .war file and with in the same server location. I dont want to hard code the file location path in my jsp. Is there any other alternative by using getRealPath() method. Pl let me know how to use application.getRealPath() if it makes any sense.


Hoping to hear from you soon

Hi all,

I need to retrieve the document on clicking a link in the jsp page. so, i need to code in the jsp. but the document to be retrieved is external to the current .war file. If the document is available with in the .war file, I used to code in the jsp as follows, when the document is available in the folder "docs" outside the WEB-INF by using onClick = window.open() :

<td class="FormLableLeft"><a rel="nofollow">")></td>




Hoping to see your views at the earliest..

so sorry if i ve posted in a wrong place..

As I want to code it in my jsp file, i ve posted my question here. But the solution given by you would solve my issue.

use a servlet to read the file from the file system and stream it as the response.

so, pl choose an option for me if I need to move to the servlet forum.

I need to retrieve the document on clicking a link in the jsp page. so, i need to code in the jsp. but the document to be retrieved is external to the current .war file. If the document is available with in the .war file, I used to code in the jsp as follows, when the document is available in the folder "docs" outside the WEB-INF:

<td class="FormLableLeft"><a rel="nofollow">")><%=colData.get("PROC_NAME")%></a> </td>


Please suggest me how to code when the document is external to .war file and with in the same server.



Hoping to hear from you soon...

Hi all,

I need to retrieve a document, which is stored out side the .war and available on the same server location. Could any one suggest me how to retrieve it from my current jsp?


Hoping to see your views at the earliest..

I got the result just by setting the width of the window with the screen width.

Any way, thank you all..

Thank you very much.. I ve solved my issue by using SimpleDateFormat class.

Hi all,

when I am opening a new page on clicking a hyperlink, it should display exactly at the centre of the screen. could any one help me in adding new attributes in the window.open() method? or any other alternate option??

hi,

I am retrieving data from backend(oracle) by means of jsp form. when I ve queried the date value is in the form '2/3/2009 12:39:58 PM'. but by the time I ve retrieved to the jsp, it is showing in different format. what would be the change to be done to retrieve the date value as it is.

hope some expert would share their views and suggest me.


thanks,
Sri

I ve a common frame from which all other frames are being extended. I found that the window size is set as: initFrame(new Dimension(1020, 720));





Thanks,
Sri

Dear Machael,

Can you please explain me a bit clear?


Thank you in advance,
Sri

All the individual modules are written using / extending JFrames internally.



Thanks,
Sri.

Hi all,

I ve a swing application which is having multiple modules(panels) and each module can be opened from every other module, as some menu items in the form of icons. But when I am trying to open and close any module multiple times, the window is moving down and to the right, so that the window buttons like minimum, restore, close are going outside the screen. Please let me know what modification can be done in order to view the complete window even on closing and opening multiple times.


Thank you in advance,

Sri.