Hi,

Here is the code to read image (file) from database. Read tutorial Read image from database.

The relevant part of code is:

  rs1 = st1.executeQuery("select image from pictures where id='5'");
  if(rs1.next()){
    int len = imgLen.length();
    byte [] rb = new byte[len];
    InputStream readImg = rs1.getBinaryStream(1);
    int index=readImg.read(rb, 0, len);  
    System.out.println("index"+index);
    st1.close();
    response.reset();
    response.setContentType("image/jpg");
    response.getOutputStream()**.write(rb,0,len);**
    response.getOutputStream().flush();        
  }

After reading the image you can save into file or attach as attachment in your email.

Thanks

Hi,

Example code of Java email with attachment.

Thanks

hie thank you so much could you help me out for a code with the pdf or a text file from the data base where the contents of file are stored int binary format

i am making use of POJO

i get the following exception from my code
javax.mail.MessagingException: IOException while sending message; nested exception is: java.io.IOException: No content

hey my code works fine thank you