[jboss-user] [EJB 3.0] - image to blob

[argonist]

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));
  | .....
  | 

>From Image to Blob Object. But how???

  | 	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#4071499

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4071499