Re: com.mysql.jdbc.UpdatableResultSet.updateBlob gives AbstractMethodError

"pjvleeuwen@xxxxxxxxx" <pjvleeuwen@xxxxxxxxx> writes:

Hi all,

I'm quite new to all jdbc, but so far working with resultset's over
SQL seemed easy so far, but I'm having some problems writing a blob to
the database.
What I try to do is two steps:
1. read an image from the web and write it to a blob
2. read the blob and display it as an image

I did the same thing before without trying to write to the blob, but I
want to store the images in DB because the only stay on the web for a
couple of weeks.

Googling for UpdatableResultset updateBlob AbstractMethodError gets me
lost. Any help is well appreciated.

Why do you have to use an updatable result set to store the blob? Why
can't you use an ordnary update statment?

I don't know if MySQL supports updatable result sets with blobs, (it
probably does) but why make things more complicated than necessary...?

--
dt

.

Relevant Pages

  • Re: Some questions about sparse files
    ... The indiex is the cookie I returned from my Store() method. ... to be able to say that the benefit of using your sparse file is sufficient ... storing metadata creates the possibility of file corruption - consider ... the case of process termination during a blob insert. ...
    (microsoft.public.win32.programmer.kernel)
  • Re: Some questions about sparse files
    ... remove "nospam" change community. ... In my case they ask me to store a blob. ... In addition I have the ability to enumerate all the blobs in the store. ... Of course the primary reason to use a sparse file ...
    (microsoft.public.win32.programmer.kernel)
  • Re: Some questions about sparse files
    ... In my case they ask me to store a blob. ... In addition I have the ability to enumerate all the blobs in the store. ... remove "nospam" change community. ... Of course the primary reason to use a sparse file is ...
    (microsoft.public.win32.programmer.kernel)
  • Re: Some questions about sparse files
    ... In my case they ask me to store a blob. ... In addition I have the ability to enumerate all the blobs in the store. ... remove "nospam" change community. ... Of course the primary reason to use a sparse file ...
    (microsoft.public.win32.programmer.kernel)
  • Re: Viewing a bitmap Oracle Blob without writing it to file
    ... Image extent: extentPoint depth: aDepth bitsPerPixel: aBitsPerPixel palette: aPalette usingBits: myBits ... In this case you store the information required to recreate the image in the same table including the blob colum holding the the image bits. ... Using the Image class allows you to read all compatible image file formats and then store them into your database. ...
    (comp.lang.smalltalk)