Protege 3.5 has an issue with MySQL v5.6 and higher where the length (in bytes) of the short_value column is insufficient. The resolution is to set this to 255 (the limit for UTF-8 text columns when they are used in indexes). The beauty of Protege is that we can do this without having to make any code changes - just by setting two properties in the Protege.properties file.
- Go to File -> Preferences and go to the ‘protege.properties’
- Create a new property called: Database.type.varchar.maxsize.com.mysql.jdbc.Driver and set the value to 255
- Create another new property called: Database.typename.short.value.type.com.mysql.jdbc.Driver and set that value to VARCHAR(255)
Now, when you perform the Convert to Protege Database, the short_value column will be adjusted and the project will save in to a MySQL 5.6+ table