Results 1 to 5 of 5
  1. #1
    liluma's Avatar
    liluma is offline Member
    Join Date
    May 2011
    Location
    belgium
    Posts
    50
    Rep Power
    0

    Default getting an attachement from MSAccess

    i have a question

    i'm just wondering how it is possible by using a JDBC bridge to get an attachement(all pics) from MSAccess2010.
    so how you can get that information from that table...

    i know how to it works for String(text in MSAccess) and ints(number in MSAccess) but how do you do the same for an attachement?

    all help is usefull. ^^

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,949
    Rep Power
    19

    Default

    Presuming by "attachment" you mean a Blob field in the database, then use getBlob or getBinaryStream.

  3. #3
    liluma's Avatar
    liluma is offline Member
    Join Date
    May 2011
    Location
    belgium
    Posts
    50
    Rep Power
    0

    Default

    en how do you make that blob file then into an image or imageIcon? O.o

  4. #4
    DarrylBurke's Avatar
    DarrylBurke is offline Member
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,193
    Rep Power
    19

    Default

    You reverse the process that saved the image as a blob.

    db

  5. #5
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,949
    Rep Power
    19

    Default

    ImageIO has a method for creating a BufferedImage that takes an InputStream.
    From that Image you can create an ImageIcon.

Similar Threads

  1. MSAccess, rs.next() and SELECT DISTINCT
    By mine0926 in forum JDBC
    Replies: 13
    Last Post: 01-26-2011, 01:23 AM
  2. Date problem in MSAccess
    By realosso in forum New To Java
    Replies: 1
    Last Post: 06-02-2010, 12:32 PM
  3. How to connect to msaccess?
    By azzaiel in forum New To Java
    Replies: 1
    Last Post: 06-28-2009, 02:19 AM
  4. Replies: 3
    Last Post: 04-30-2009, 09:28 AM
  5. MSAccess and hibernate
    By bbq in forum JDBC
    Replies: 3
    Last Post: 04-30-2008, 04:38 PM

Posting Permissions

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