Description | Apache Derby has both BLOB and VARBINARY data types. SymmetricDS is working with the BLOB data type, but not VARBINARY. Example table definition: CREATE TABLE TEST (ID INTEGER, VARCHAR (100) FOR BIT DATA); During an initial load or a data change capture, the following exception occurs in the DerbyFunctions.blobToString(): Caused by: java.sql.SQLException: The exception 'java.sql.SQLException: An attempt was made to get a data value of type 'java.sql.Blob' from a data value of type 'VARCHAR () FOR BIT DATA'.' was thrown while evaluating an expression. |
---|