Results 1 to 7 of 7
  1. #1
    fedex646 is offline Member
    Join Date
    Jun 2013
    Posts
    4
    Rep Power
    0

    Default Need to write huge data from oracle database to csv using java

    I need to write huge data of oracle table (3 million rows) to a csv file with java. I need to iterate through object to write the data.. please let me know how to do it..share some code if possible

  2. #2
    AndrewM16921 is offline Senior Member
    Join Date
    Jan 2009
    Location
    NJ, USA
    Posts
    263
    Rep Power
    6

    Default Re: Need to write huge data from oracle database to csv using java

    Look into JDBC for the database stuff, and look into the OpenCSV library for writing the file.

  3. #3
    fedex646 is offline Member
    Join Date
    Jun 2013
    Posts
    4
    Rep Power
    0

    Default Re: Need to write huge data from oracle database to csv using java

    i have connected to database and completed queries. I have all my database information saved in a object which I need to iterate and display as a csv file.

  4. #4
    DarrylBurke's Avatar
    DarrylBurke is offline Member
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,189
    Rep Power
    19

    Default Re: Need to write huge data from oracle database to csv using java

    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

  5. #5
    fedex646 is offline Member
    Join Date
    Jun 2013
    Posts
    4
    Rep Power
    0

    Default Re: Need to write huge data from oracle database to csv using java

    why i am a questioned for asking a question in different forum? is that a wrong?

  6. #6
    DarrylBurke's Avatar
    DarrylBurke is offline Member
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,189
    Rep Power
    19

    Default Re: Need to write huge data from oracle database to csv using java

    Quote Originally Posted by fedex646 View Post
    why i am a questioned for asking a question in different forum? is that a wrong?
    I don't see where anyone questioned you. However, you may like to read the page linked in my post on the other site.

    db
    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

  7. #7
    jim829 is offline Senior Member
    Join Date
    Jan 2013
    Location
    United States
    Posts
    2,940
    Rep Power
    4

    Default Re: Need to write huge data from oracle database to csv using java

    It also saves folks time from providing a lengthy and perhaps duplicate answer which is already provided elsewhere.

    Regards,
    Jim
    The Java™ Tutorial | SSCCE | Java Naming Conventions
    Poor planning our your part does not constitute an emergency on my part.

Similar Threads

  1. Java with Oracle Database
    By praneethpj in forum Advanced Java
    Replies: 1
    Last Post: 01-24-2013, 11:01 AM
  2. Replies: 3
    Last Post: 03-19-2010, 12:59 AM
  3. how to display data from oracle database?
    By deru4jesus in forum JavaServer Faces (JSF)
    Replies: 0
    Last Post: 04-16-2009, 08:46 AM
  4. Replies: 3
    Last Post: 08-05-2008, 03:19 AM
  5. Replies: 4
    Last Post: 08-09-2007, 10:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •