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.
