Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2005
    Posts
    4

    Exclamation Unanswered: Inserting image (BLOB) into DB2

    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!

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    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...
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Nov 2005
    Posts
    4
    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

  4. #4
    Join Date
    Nov 2005
    Posts
    4
    Some body help!! Please ~~

  5. #5
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    There are Java samples showing how to insert a BLOB, check out

    sqllib/samples/java/jdbc/DtLob.java
    Last edited by J Petruk; 11-19-05 at 20:24.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •