how to store image file in database using hibernate?

edward · **Posted:** Tue Jun 27, 2006 4:28 am

hi,

i want to store image file in any database using hibernate?
Is it possible?

A. Edward Durai

hlfsousa · **Posted:** Tue Jun 27, 2006 1:10 pm

Try using a byte array (byte[]) property mapped to a BLOB column. Using annotations that property would be flagged @Lob. Can't quite remember about XML mapping.

edward · **Posted:** Wed Jun 28, 2006 12:48 am

I am Using MSSQL. I think MSSQL don't have BLOB Type. Then how can I handle this.

Thanks
edward

hlfsousa · **Posted:** Fri Jun 30, 2006 10:33 am

I think you can use column type "image" for MS SQL. I think JDBC (and therefore Hibernate) treats it just like a BLOB.