Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 351990

Summary: [DB][Mysql] Default BLOB size is not sufficient
Product: [Modeling] EMF Reporter: Egidijus Vaisnora <vaisegid>
Component: cdo.net4j.dbAssignee: Egidijus Vaisnora <vaisegid>
Status: CLOSED FIXED QA Contact: Eike Stepper <stepper>
Severity: normal    
Priority: P3 CC: saulius.tvarijonas, stefan
Version: 4.1Flags: stepper: review+
Target Milestone: ---   
Hardware: All   
OS: All   
Whiteboard:
Attachments:
Description Flags
Patch none

Description Egidijus Vaisnora CLA 2011-07-13 11:12:35 EDT 
BLOB type is mapped to MySQL BLOB type, however it's default size is too small ~ 64kb. I prefer to increase it to 4G to accept large binary data
Comment 1 Egidijus Vaisnora CLA 2011-07-13 11:14:46 EDT 
Created attachment 199595 [details]
Patch
Comment 2 Stefan Winkler CLA 2011-07-14 02:24:11 EDT 
Is there any drawback when the default size is increased?
If yes, would it make more sense to make the value configurable?
Comment 3 Egidijus Vaisnora CLA 2011-07-14 02:52:31 EDT 
(In reply to comment #2)
> Is there any drawback when the default size is increased?
> If yes, would it make more sense to make the value configurable?

It will increase size of BLOB by the size required to tell length of data. Default BLOB will have 2 byte prefix, large will have 4 byte prefix. http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html
But anyway, I think your idea with configuration is great and should fulfill everybody needs. Now it seems that each adapter is overloading default types for some reasons.
Comment 4 Egidijus Vaisnora CLA 2011-07-18 03:30:59 EDT 
Committed revision 8719, to TRUNK
Comment 5 Eike Stepper CLA 2012-09-21 07:18:17 EDT 
Closing.