You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: