from blob routines displayed at
http://lists.mysql.com/commits/11855
the allocation for BLOB column is has an upper limit of max(int) which is 64k
so any column (including BLOB) > 64k in size is truncated
anyone else?
Martin
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
> Date: Wed, 3 Jun 2009 23:42:11 -0700
> From: glassfish_at_javadesktop.org
> To: users_at_glassfish.dev.java.net
> Subject: @Lob
>
> I am using gf 2.1, Toplink to MySQL. I have a collection Vplist in my entity bean VpPairList and use @Lob when declaring it. The schema is correctly created with the column as BLOB. My session bean creates the entity correctly and it works. But for some processing, the session bean hits an exception saying that the data is too long:
>
> Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'VPLIST' at row 1
> Error Code: 0
> Call: INSERT INTO VPPAIRLIST (ID, VPLIST) VALUES (?, ?)
> .....
>
> I saw people discussing putting a binary file into a BLOB. So I expect there shouldn't be any limitation on the size of BLOB. Besides, my VpList isn't realy that large (it worked great previously when it was a String working in java client, JDO and MySQL. This was before I move the logic to a session bean). Or is the limitation in Toplink? How can I make it work?
> [Message sent by forum member 'senderj' (senderj)]
>
> http://forums.java.net/jive/thread.jspa?messageID=349063
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
_________________________________________________________________
Lauren found her dream laptop. Find the PC that’s right for you.
http://www.microsoft.com/windows/choosepc/?ocid=ftp_val_wl_290