Hello, I have problem with Blob type. A Image should be uploaded then stored in tempory file. The image should be stored from tempory file into mysql over enitity bean as Blob Object. How can I make from image to blob object without SQL-statement? Enitity Bean InterpreterImage | public class InterpreterImage implements Serializable | { | private static final long serialVersionUID = 1L; | | @Id | @Column(name="ID") | private int id; | | @Column(name="GALLERYFILENAME") | private String galleryFilename; | | @Column(name="GALLERYIMAGE") | private Blob galleryImage; | | @Column(name="PROFILFILENAME") | private String profilFilename; | | @Column(name="PROFILIMAGE") | private Blob profilImage; | Store Blob Object into entity Bean Interpreter.interpreterImage | ...... | interpreter.getInterpreterImage().setProfilImage( | setImagetoPath(profilFile.getInputStream(), filename)); | ..... | | private Blob setImagetoPath(InputStream input, String Filename) { | | FileOutputStream fos; | Blob blob = null; | String realPath=null; | byte[] buff = new byte[8192]; | int len = 0; | | try { | System.out.println(Filename); | realPath = ((ServletContext) FacesContext.getCurrentInstance().getExternalContext().getContext()).getRealPath("/images"); | fos = new FileOutputStream(realPath+"/"+Filename); | while (0 < (len = input.read(buff))){ | fos.write(buff, 0, len); | } | System.out.println(fos.toString()); | fos.close(); | input.close(); | } catch (FileNotFoundException e) { | // TODO Auto-generated catch block | e.printStackTrace(); | } catch (IOException e) { | // TODO Auto-generated catch block | e.printStackTrace(); | } | try { | //Image over byte[] buff to Blob Object | // HOW???? | } catch (SQLException e) { | // TODO Auto-generated catch block | e.printStackTrace(); | } | return blob; | } | Store simple Bean into database | public void createInterpreter(Interpreter interpreter) { | manager.persist(interpreter); | } | I hope, that you have an idea... Thank you in advance Manu View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4071499#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...