Eclipse Community Forums: EclipseLink » @Lob @Column (length=16777215) doesn't work with MySql to get a MEDIUMBLOB

Help

Home

Home » Eclipse Projects » EclipseLink » @Lob @Column (length=16777215) doesn't work with MySql to get a MEDIUMBLOB

Show: Today's Messages :: Show Polls :: Message Navigator

@Lob @Column (length=16777215) doesn't work with MySql to get a MEDIUMBLOB [message #388441]

Fri, 29 May 2009 09:46

Martin Dames

Messages: 28
Registered: July 2009

Junior Member

Hi guys,

I have a simple Table where one column should be from type LOB. I want to
store some picture data.
When Im connecting to MySQL with EclipseLink (JPA), it creates the tables
automatically and set the right column type for MySQL. But it just creates
columns from type BLOB (which is limited to 64kb in MySQL) and not
MEDIUMBLOB (which would be sufficient for my images).

One solution I found is to set the column length to a size greater than
64kb (see example below) so that EclipseLink (JPA) would create a column
from type MEDIUMBLOB if it is connected to MySQL automatically. This
doesn't work... it just creates columns from type BLOB, doesn't matter
which length im defining for the column.

I triple checked if the tables are being created by JPA, old and not
dropped tables are not the error.

Is this a bug? Thank you.

My annotated entity attribute:
@Lob
@Basic(fetch=FetchType.LAZY)
@Column (length=16777215, name="IMAGE") // length for mysql mediumblob
private byte[] mymage;

Report message to a moderator

Re: @Lob @Column (length=16777215) doesn't work with MySql to get a MEDIUMBLOB [message #388478 is a reply to message #388441]

Mon, 01 June 2009 03:26

Doug Clarke

Messages: 155
Registered: July 2009

Senior Member

If you ever need to customize the types used in the schema generation you
can use the columnDefinition attribute of the @Column annotation. This
allows you to specify the exact string that will be used.

@Lob
@Basic(fetch=FetchType.LAZY)
@Column(columnDefinition="MEDIUMBLOB(?)")
private byte[] image;

Doug

Report message to a moderator

Previous Topic:	List of Supertype and @OrderBy
Next Topic:	EclipseLink does not store in database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 16 06:34:27 GMT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter