can anybody tell me how to get an image out of mysql and into a java imageIcon or image object?

I'm placing the image using:

insert into table values(pKey, LOAD_FILE("c:/testPic.jpeg"));

I'm obviously using JDBC and resultsets to connect!

Any help would be super!

Regards,

sjl301

Hi,

This may or may not help...

You can use PrepareStatement's getObject(x) and setObject(x,y) methods to store and retrieve the values.

We use the Base64Encoder class (http://www.servlets.com/cos/index.html or similar) to encode and decode the objects (we store images, pdfs, worddocs, etc).

Once you retrieve the decoded object as a byte[], you can pass it into something like ImageIcon.

Chrs,
Ash

hi
I need to insert an image (gif file image[eg. client
photograph]) to a
long raw (not blob/bfile type) data type from PLSQL.
[from sql plus and from
a DB procedure/trigger] , Please send me the script
for the same
cheers
priya

Have a look at :

http://www.fawcette.com/javapro/2004...efault_pf.aspx

Should answer most of your Q's.....


H