CLOB data type give only EMPTY_CLOB

[sriramcms]

Hi:

This is a very useful project based on logminer.
My data is Oracle 12c release 2.

In the SQL_REDO=insert statement i get EMPTY_CLOB for the CLOB data type column. every insert operation in the database i get one insert SQL and no other updates.

Do i need to make a separate query to lookup the CLOB column via JDBC. I dont know what else needs to be done to get CLOB data values along with the insert statement.

Thanks

[lidoudou1993]

There is a bug in this project.
You can add some code in createDataSchema like this.

for (String col :dataMap.keySet()) {
String value = dataMap.get(col);
String keyTabCol=owner+"."+tableName+"." + col;
dataStruct.put(col, value.equals(NULL_FIELD) ? null : reSetValue(value, tabColsMap.get(keyTabCol).getColumnSchema()));
}

then you can get CLOB data values along with the insert statement and update statement.