Getting "Table or View does not exist" with Oracle Blob
I am using the version 5.3.1 of Enterprise Data Integration. My job simply moves data from one Oracle 11g database to another Oracle 11g database based upon a date comparison. Many of the rows fail with "Table or view does not exist", but not all rows are failing. In Oracle, the field is defined as BLOB. In the Talend schema it is defined as Object with a length of 32767. In the Java code I see this declaration which appears incorrect.
public String toString() {
StringBuilder sb = new StringBuilder();
sb.append(super.toString());
sb.append("");
return sb.toString();
}
Is it possible that this is the cause of the issue? Obviously the table exists if it reads all data and writes some data. The amount of error messages is the same as the amount of records not written.
Thank you