Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
m1ssy0un opened this issue Nov 22, 2022 · 0 comments
Open

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

m1ssy0un opened this issue Nov 22, 2022 · 0 comments

Comments

@m1ssy0un
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant