Whats the database at the backend, soln depends on that as well; If oracle which version?
I think its possible to generate directly excel file in java from result set, so u can skip xml stage in that case.
I have reqt of getting the o/p in intermediate stage as XML (which will be archived) and then convert the same as PDF file for clients.
Why I want xml as intermeditate is becos :
1.The resulting data of xml is based on a lot of calculations, so i want intermediate stage for any manual corrections required.Also i want archiving of these xml files .
2. The resulting o/p from xml (using XSLT ), can vary in differnt formats , pie chart, excel , pdf etc.. as the need arises.
3.The read-only o/p (e.g pdf) represented can be sub-part of the xml or combination of 2 to 3 xml files generated as one report.
Now i want to know ,
-Q1 how is the xml generation performance(time taken) from Oracle (8i/9i/10g), the report can be 10- 60 pages long and of complex nature.
-Q2 why im specifying all 3 versions is becos if I have to build the diff o/p combinations, and xml is the only soln, then i can ask client to go for specific version (for a given performance reqt).
-Q3 How feasible is the PDF generation from this xml in terms of
- tools required
- time taken
- coding effort
-Will direct PDF generation from the database be beter soln in any other way.
Peformance is of utmost importance as we need to generate 5000 reports in 3hrs.