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

Saving Doc as BLOB in SQL DB

 
Michael Paul
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ranchers,

I made a JFileChooser, so that you can select only textual documents, and then I want to be able to save this to a database but I really have no idea of where to start with BLOBs can someone give me a little starting push with this topic...I read examples online about how to retrieve BLOBS which seemed very easy...I am jsut not sure how to save a document as a BLOB to begin with..this is the code for my filechooser incase you wanted to see it:



Just so you know, I do know how to write to the DB, I just don't know how to handle BLOBs. Any help at all would be appreciated, =)

Thanks,
Michael
[ April 23, 2008: Message edited by: Michael Paul ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34422
347
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Michael,
The key is to create a binary input stream rather than a blob and call stmt.setBinaryStream().
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic