File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Flat file from Oracle DB

 
Pallav Bora
Ranch Hand
Posts: 73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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.

Thanks

Pallav
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

My enterprise application is a J2EE application.

Can you be more specific? What aspect of JEE are you using? Where will the file end up?
 
Pallav Bora
Ranch Hand
Posts: 73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Pallav Bora
Ranch Hand
Posts: 73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Paul !
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic