wood burning stoves 2.0*
The moose likes XML and Related Technologies and the fly likes Replacement for SQLXML Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Replacement for SQLXML" Watch "Replacement for SQLXML" New topic
Author

Replacement for SQLXML

Vinod Borole
Greenhorn

Joined: Feb 25, 2009
Posts: 26
Hello,

I am currently using SQLXML as a xml processor in my java application which transfers data from an XML file to my database. The xml files we process are very large in size and have thousands of tags ranging from 10,000 to 80,000. Using traditional approach of XML parsing makes the process very very slow, for processing file having tags around 80.000 it takes 1hour and the same processing is done in minutes when we use SQL XML.

One problem with SQLXML is its licensed version which i cannot afford for a long time, So i am thinking of replacing it with something which is as good as he is. Can anyone suggest me any open source that does the same thing with the same efficiency.

Thank you!
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8836
    
    7

Exactly what are you using it for? There's no shortage of XML parsers. If you're just reading in values and updating the database, the SAX parser built into the JDK will probably be enough. Personally, I find XQuery (also available in the JDK) easier to work with.


"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
Vinod Borole
Greenhorn

Joined: Feb 25, 2009
Posts: 26
I have a import process that can take one or many XML files depending on user requirement at a time, this process is responsible for reading an XML file and adding the information to a set of relational tables. I have used SAX parser but when i use this import for multiple files at a time the performance degrades. As my system needs is to do this as fast as possible i have used SQLXML for which i just have to write a mapping information that's the only code i have to do, which it uses and transfers the data to the database.

Depending on my current requirement as mentioned above do you think XQuery would be a good option, i have not used it yet.

Does any one has any idea about Woodstox parser?
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8836
    
    7

Vinod Borole wrote: I have used SAX parser but when i use this import for multiple files at a time the performance degrades.


Odd. I'd think that since SAX processes tags as-it-goes, it would have pretty good throughput. Are you doing multiple files simultaneously? Have you tried benchmarking the database to make sure that it is not the bottleneck?

Vinod Borole wrote:
Depending on my current requirement as mentioned above do you think XQuery would be a good option, i have not used it yet.


I'm not doing anything demanding with it, so I can't speak to performance. I just like the query interface better than SAX's event-driven model.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Replacement for SQLXML
 
Similar Threads
SQLXML problem
OutOfMemory Using JDK 1.3
Rotation of text
Java version of sqlxml
SQLXML type