Discussions

General J2EE: inserting binary data(images,music) into MS Access using jsp

Bookmark and Share Get thread feed

  1. inserting binary data(images,music) into MS Access using jsp (3 messages)

    i have been tring to insert an image into ms access but it has not been working for me using the "setBinaryStream()", please can anyone help witha code for inserting binary files into a MS Access DB using JSP?
    Reply to this

    Threaded Messages (3)

  2. Re: inserting binary data(images,music) into MS Access using jsp[ Go to top ]

    Which driver are you using?
    Reply to this Reply to original

  3. Re: inserting binary data(images,music) into MS Access using jsp[ Go to top ]

    File file=new File("c:/testpic.jpg"); FileInputStream in=new FileInputStream(file); PreparedStatement ps=connection.prepareStatement("insert into image_table (IMAGE) values(?);"); ps.setBinaryStream(2,in,(int)file.length()); ps.execute(); ps.close(); And make sure the Type is OLE for the field which contains the Image data.
    Reply to this Reply to original

  4. Re: inserting binary data(images,music) into MS Access using jsp[ Go to top ]

    one correction , the index 2 should be 1 ps.setBinaryStream(1,in,(int)file.length());
    Reply to this Reply to original