Inserting image (BLOB) into DB2

kofij · #1 (**permalink**) 11-18-05, 12:57

Hello,
I am new with the BLOB tyoe and I am having problems trying to insert an image into my db2 database. I will really appreciate if some one can help me out on how to go about it.
Thanks you!

J Petruk · #2 (**permalink**) 11-18-05, 13:26

More details please.

What are you trying to insert, where is it before you put it in db2, what language is your application written in, what version of db2, what platform, etc. etc...

kofij · #3 (**permalink**) 11-18-05, 13:49

I am running 8.1 not very sure but it's one of the first release for the 8 versions. This picture (image) is on my hard drive with the db too. I am runing on windows XP.
I have the db setup and have the field for the image set to take blob. I want to use java application to do that.
Thanks

kofij · #4 (**permalink**) 11-19-05, 16:19

Some body help!! Please ~~

J Petruk · #5 (**permalink**) 11-19-05, 19:16

There are Java samples showing how to insert a BLOB, check out

sqllib/samples/java/jdbc/DtLob.java

Internet Services

Web Development

Digital Marketing

Consumer Tech