Hi,

I am using:

JBoss 4.0.3 SP1 with the EJB3 features and MySQL.

I have a simple Entity EJB and created the following Blob attribute:

@Entity
public class File implements Serializable{

private int id;
private String fileName;
private String contentType;
private int fileSize;
private Blob file;

@Lob(fetch=FetchType.EAGER)
public Blob getFile() {
return file;
}
public void setFile(Blob file) {
this.file = file;
}
[..]
}

This works fine, but I can only store very small files as the MySQL coloumn which is dynamically created is 'tinyblob'.

How can I change this to 'longblob' which can take larger files?

Thanks.

Stefan

@Column(length=...)