Saving an Image object in JDBC

[Ike]

Does anyone have any clue how to save and retrieve an Image object under
JDBC ? //Ike

 

[Roedy Green]

Does anyone have any clue how to save and retrieve an Image object under
JDBC ? //Ike

look for the BLOB type. You can save it as array of bytes.

 

[Ike]

Ah...this is outstanding, if anyone needs this in the future:
http://developer.java.sun.com/developer/onlineTraining/Database/JDBC20Intro/exercises/BLOBPut/
and
http://developer.java.sun.com/devel...base/JDBC20Intro/exercises/BLOBGet/index.html
//Ike

 

[Roedy Green]

Ah...this is outstanding, if anyone needs this in the future:
http://developer.java.sun.com/developer/onlineTraining/Database/JDBC20Intro/exercises/BLOBPut/
and
http://developer.java.sun.com/devel...base/JDBC20Intro/exercises/BLOBGet/index.html
//Ike

for future reference, those links are at
http://mindprod.com/jgloss/blob.html

 

[Marco Schmidt]

xp comp.lang.java.databases,comp.lang.java.programmer
fup2 comp.lang.java.programmer

Ike:

Ah...this is outstanding, if anyone needs this in the future:
http://developer.java.sun.com/developer/onlineTraining/Database/JDBC20Intro/exercises/BLOBPut/

Which only copies a binary file into a BLOB column, it does not, as
you asked, work on an Image object.

[...]

Regards,
Marco

 

[Tim Jowers]

xp comp.lang.java.databases,comp.lang.java.programmer
fup2 comp.lang.java.programmer

Ike:


Which only copies a binary file into a BLOB column, it does not, as
you asked, work on an Image object.

Do you mean the binary data of the image cannot be saved into the db?
I had a problem like this saving class files in a database. If I
remember, the solution is to use base64 or uuencode etc. as the db
does not truly support binary. Like many things, BLOB was a false and
misleading acronym. I was developing on Access (argh!) and then we
were running on Teradata. Worked on production but not development

Tim

 

[Marco Schmidt]

xp comp.lang.java.databases,comp.lang.java.programmer
fup2 comp.lang.java.programmer

Please regard the followup-to!

Tim Jowers:

Do you mean the binary data of the image cannot be saved into the db?

No, I mean that in this particular example nobody is working on a
java.awt.Image object but they are copying the original image file
data into the database. Which is fine, but in some cases there may not
be such a file, because the image was generated in the program, or
acquired from a scanner. In those cases it is necessary to access the
raw image data, which is not possible with java.awt.Image itself. In
addition, it may make a lot of sense to first convert the raw image
data into some compressed form in order to save disk space.

There are certain pitfalls to consider when converting Image to BLOB,
that's all I'm saying.

[...]

Regards,
Marco

 

[Joris Van den Bogaert]

http://www.esus.com/docs/GetQuestionPage.jsp?uid=1458
and
http://www.esus.com/docs/GetQuestionPage.jsp?uid=1457