I have a requirement whereby I need to generate a flat file where each elements have specific length of chars (positional flat file). The total char can easily run up to 1200000000 (We may consider splitting the file into smaller ones). The data for the flat file comes from a Oracle 10g (may be upgrated to 11g etc). My enterprise application is a J2EE application.
I would like to know what the industry practices are to generate the flat file in the above situation.
I am not sure what aspect of EJB I should use as it is a fresh project. I am looking to find out the most appropriate way - be it in J2EE application, of ouside of J2EE application but in the same server ,POL/SQL, from Oracke DB or other Oracle products.
As for the flat file it will be written to a directory and then FTP to another server in a different organization.
The reason I'm asking what aspect of JEE you are using is some (such as EJBs or Servlets) will have threading implications. If you have not written anything yet though, I'd suggest Oracle's bulk loading tools or a basic Java application.