Any DB TEXT Type to Derby CLOB ------------------------------ Key: DDLUTILS-247 URL: https://issues.apache.org/jira/browse/DDLUTILS-247 Project: DdlUtils Issue Type: Improvement Components: Core - Derby/Cloudscape/JavaDB Affects Versions: 1.0 Environment: jdk 1.6.07 MySql 5.x Derby 10.4.x Reporter: Mehmet Nuri Deveci Assignee: Thomas Dudziak
When you export a database from MySql (which i tried) and import it into a Derby database, if one of the tables includes a field with LONGTEXT type, it converts it into LONGVARCHAR but when you insert data in that table, it throws an exception about the size limitations. If you manually change it to CLOB data type in Derby, it successfully inserts data. I think if type is LONGTEXT it must be matched to CLOB in Derby. I do not know exact size for field which creataes a problem for it. in mysql: CREATE TABLE TEST ( TXTFIELD LONGTEXT ) in derby, it must be: CREATE TABLE TEST( TXTFIELD CLOB ) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.