[OPENJPA-1667] Incorrect column type for LOB streaming in MySQL

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.3.0, 2.0.0
• Fix Version/s: 1.3.0, 2.1.0
• Component/s: sql
• Environment: MySQL 5.1.30
• Assignee: Milosz Tylenda
• Reporter: Milosz Tylenda
• Created: 16/May/10 11:56
• Updated: 13/Jan/11 16:45
• Resolved: 26/May/10 09:58

Description

After the changes made in OPENJPA-740, a LOB streaming field is mapped to TINYBLOB instead of BLOB in MySQL. This is because column size is -1 and in MySQLDictionary.getColumnType we assume that only size = 0 means "size unknown". Adding a check for -1 will probably resolve the issue.

Issue Links

• relates to: OPENJPA-740 In MySQL use LONGBLOB, MEDIUMBLOB etc.. when needed, cause BLOB only holds 64kb of data.