Java class in Java Stored Proc to create native Excel file
Hi all,
I developed a small Java program that uses Apache POI SXSSF libraries to create Excel file. It runs on my PC and gets the data via JDBC from Oracle DB server running on IBM AIX. The good thing about this library is I can control the number of rows it keeps in memory, so even though the output file is 27 MB, and I'm running many applications on my PC, the program managed to create the Excel smoothly, although it took longer than I like (45 min), and created a 300 MB temp file, which was removed automatically when program finished.
Just wondering if it is possible to create a Java stored proc to embed this program inside the DB server, so it can avoid all the network traffic time. The problem is it uses a lot of libraries that need to be imported into the DB server as well, just for this little report program.
The program can be called from PL/SQL program, which in turn can be scheduled by concurrent manager.
The result can be stored inside some BLOB column and FTP-ed to some remote server for user access.
Do you think this is a viable project? Or simply too much trouble to create an Excel report?
Many thanks.