Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Saving an XML to DB

 
surya naidu
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Pie
Posts: 20527
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic