openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Simone Gianni <simo...@apache.org>
Subject Re: [jira] Created: (OPENJPA-740) In MySQL use LONGBLOB, MEDIUMBLOB etc.. when needed, cause BLOB only holds 64kb of data.
Date Tue, 07 Oct 2008 22:26:21 GMT
Hi all,
I can try to patch the code and provide a patch by myself, I'd just like
to know if this bug is "real" or if I'm missing some important
workaround that would make this bug (and the patch) useless.


Thanks,
Simone

Simone Gianni (JIRA) wrote:
> In MySQL use LONGBLOB, MEDIUMBLOB etc.. when needed, cause BLOB only holds 64kb of data.
> ----------------------------------------------------------------------------------------
>
>                  Key: OPENJPA-740
>                  URL: https://issues.apache.org/jira/browse/OPENJPA-740
>              Project: OpenJPA
>           Issue Type: Improvement
>           Components: sql
>     Affects Versions: 1.2.0
>             Reporter: Simone Gianni
>
>
> When a column is annotated as a BLOB of using @Persistent to use streaming blobs, and
the underlying database is MySQL, OpenJPA will create a column of type BLOB. Unfortunately,
in MySQL a BLOB column can hold a (vary) limited amount of data, while (especially when using
streaming blobs) the user would probably expect it to hold a large amount of data.
>
> Also adding the @Column annotation and specifying a size bigger than what a BLOB column
in MySQL can hold, OpenJPA still creates only a BLOB column.
>
> I think OpenJPA should be able to create the proper column type depending on the @Column
annotation if present, or otherwise default at least to a MEDIUMBLOB to preserve cross-database
compatibility as expected.
>
> The simplest patch i can think of is setting blobTypeName="MEDIUMBLOB" in the MySQLDictionary
constructor.
>
> Otherwise, overriding the getTypeName to properly parse the length and return the correct
BLOB/TEXT type for mysql.
>
>   


-- 
Simone Gianni            CEO Semeru s.r.l.           Apache Committer
MALE human being programming a computer   http://www.simonegianni.it/


Mime
View raw message