Hi,
I want to persit a photo of a person in my database. In order to do that, I'am using the code below:
@Entity
@Table(name="PERSONNE")
@Inheritance(strategy=InheritanceType.JOINED)
public class Personne implements Serializable{
private ImageIcon photo;
...
@Lob
@Basic(fetch=FetchType.LAZY,optional=true)
@Column(name="PHOTO")
public ImageIcon getPhoto() {return photo;}
public void setPhoto(ImageIcon photo) {this.photo = photo;}
...
}
When I persist the entity, it's Ok but when I'am trying to extract it form the DB I got an EOFException.
@Lob make the attibute photo mapped as a blob but Blob type in MySQL seems to not support more than 64kB of data. In most of case my photos have a bigger size than 64KB and they are simply truncated.
To resolve the problem, I changed the type directly in the DB into LongBlob and now it is working fine.
So, my question is : Is there a way to have my attribute directly mapped as a LongBlob?
Thanks in advance
System informations:
jboss 4.0.4.GA
EJB RC8
MySQL 4.1.9 and connector 3.1.14