• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Flat file from Oracle DB

 
Ranch Hand
Posts: 73
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Paul !
reply
    Bookmark Topic Watch Topic
  • New Topic