File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Saving an XML to DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Saving an XML to DB" Watch "Saving an XML to DB" New topic

Saving an XML to DB

surya naidu
Ranch Hand

Joined: Jul 26, 2010
Posts: 32
hi everyone

I have a formfile object which has an XML which is uploaded from the UI
I need to save this in to a DB
Can anyone suggest the best way to do this
The XML is going to be very huge,And we also dont have a table structure(like a bean) which can hold this

Please suggest
Rob Spoor

Joined: Oct 27, 2005
Posts: 19544

You should use a CLOB field for this. The name for the field type may differ though; MS SQL Server calls it "text" (or "ntext for Unicode) for instance.
After that you use PreparedStatement with setCharacterStream / setClob (or setNCharacterStream / setNClob for Unicode text fields). You can use a StringReader to convert a String into a Reader if necessary.

How To Ask Questions How To Answer Questions
I agree. Here's the link:
subject: Saving an XML to DB
Similar Threads
Match XML data value with the mysql database
copy right and trade mark
How to read XML file ?
How to store an XML file as a string in database and retrieve in Java code
Parsing SOAP Message