File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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

Win a copy of Storm Applied this week in the Other Open Source APIs forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 19972

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