• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problems with ResultSet.getBlob

 
Alejandro Barrero
Ranch Hand
Posts: 350
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am inserting files in databases and reading them back. I am having problems reading the blobs. In MySQL getBlob() fails with an exception and my solution was to use getObject() and cast to byte[]; that works perfect. But now, I am trying to do the same with Microsoft Access; getBlob() fails as before and (byte[])getObject() still works but the contents is different from what I stored. I can use whatever way there is to store the contents of files in an Access database (I know it is not a real database but when you have to use it you have to use it).
Your help will be greatly appreciated,

Alejandro Barrero
 
RaviNada Kiran
Ranch Hand
Posts: 528
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does MSAccess suppourts Blob Data Type??
 
Jhakda Velu
Ranch Hand
Posts: 167
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Try using the GetChunk and AppendChunk methods. Check this site.
MSDN Support Site

Hope it helps.

Jhakda
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic