This week's book giveaway is in the Features new in Java 9 forum.
We're giving away four copies of Java 9 Revealed and have Kishori Sharan on-line!
See this thread for details.
Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Problems with ResultSet.getBlob  RSS feed

 
Alejandro Barrero
Ranch Hand
Posts: 361
  • 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
Boost this thread!