This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes Flat file from Oracle DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Flat file from Oracle DB" Watch "Flat file from Oracle DB" New topic
Author

Flat file from Oracle DB

Pallav Bora
Ranch Hand

Joined: Oct 13, 2009
Posts: 73
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

Joined: Apr 14, 2004
Posts: 10336


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?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Pallav Bora
Ranch Hand

Joined: Oct 13, 2009
Posts: 73
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

Joined: Apr 14, 2004
Posts: 10336

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

Joined: Oct 13, 2009
Posts: 73
Thanks Paul !
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Flat file from Oracle DB
 
Similar Threads
Data Import design issue
SCJD
need to generate some numbers using loop, the number of times condition met
Fastest way to insert 1 Lac records in a table
Insert and retrieve new line character in DB2