• 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

Read XML file(Java/Oracle/Java+Oracle)

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Dear All,

I have a new enhancement in my project.
Breif Description of Enhancement : Read XML file , Do few validation and Store data in table. XML file is around 100 MB.

My current technology in the project is Java and oracle.

I have to use 1) Java OR 2)Oracle OR 3)java + Oracle.

Few of my team members are suggesting to do in Java and Few of them Suggesting to do in Java and Oracle.

I am confused here what to do.
Please suggest your opinion.

Regards,
Vivek Chavan
 
Author
Posts: 531
Mac OS X Netbeans IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Vivek,
You can read the xml file in your java application use stax or SAX to pars and perform your required operation and then store it in ORACLE. Try to use Stax or SAX and avoid using DOM.

Also, ORACLE has XML type and you can perform some XML processing using ORACLE on its XML type.

In your java code you have much more control and flexibility, so my suggestion is to go with JAVA side in processing your xml document.
 
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Brief Description of Enhancement : Read XML file , Do few validation and Store data in table

Validation is standard xml feature. Look for "XML schema" or "DTD" validation in your favorite search engine.

Oracle can do that validation, and store the XML for you.
Might be a good fit for you, if that's what you need to do.
Look on the Oracle TechNet: XML DB for info.


Regards, Jan
 
Vivek Chavan
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks for your suggesion.

I am planning to use both Java and Oracle.
java to read xml file and populate temp table.As validation of data in Java will take a lot of time.I am planning to do that in oracle.
Oracle : Do validation using temp table data and put that into target table.

Let me know your views.

Regards,
Vivek Chavan
 
I wasn't selected to go to mars. This tiny ad got in ahead of me:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic