db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mehmet Nuri Deveci (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-247) Any DB TEXT Type to Derby CLOB
Date Tue, 28 Apr 2009 07:42:30 GMT
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.


Mime
View raw message