Skip to content

Issue with DB2 Deploy DataType Converter from String to Clob #305

@m1ssy0un

Description

@m1ssy0un

Description of problem:
The issue is when I try to do the db2 deploy using static data CSV files. One of the columns is CLOB type and as it put the data into the database, it shows ConversionException: Can't Convert value '' to type interface java.sql.Clob. Not sure if CLOB type conversion is supported or not.

Example of my dbSystemConfig in system-config.xml:
<dbSystemConfig type="DB2" csvVersion="2" dataDelimiter="|" nullToken="null" sourceDirs="sql">

Example DDL to reproduce the table:
//// CHANGE name="init_control" CREATE TABLE CONTROL( CONTROL_ID VARCHAR(255) NOT NULL, CONTENT CLOB(1073741824) NULL, PRIMARY KEY(CONTROL_ID) )

Example of control.csv:
CONTROL_ID|CONTENT
a|""
b|"xxx"

Obevo Version: 8.2.0
DBMS: DB2

Appreciate it if any of you can share ideas and a resolution to this issue soon.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions