oceanbase / odc

OceanBase Developer Center(ODC), An open-source, enterprise-grade database tool for collaborative development
https://github.com/oceanbase/odc
Apache License 2.0
538 stars 55 forks source link

[Bug]: oracle2OBoracle archiving failed, exception log 'oracle.sql.BLOB cannot be cast to com.oceanbase.jdbc.Blob' #3166

Closed Huangxiao-mas closed 1 month ago

Huangxiao-mas commented 2 months ago

ODC version

ODC432

OB version

independent

What happened?

oracle2OBoracle archiving failed, exception log 'oracle.sql.BLOB cannot be cast to com.oceanbase.jdbc.Blob' image image

What did you expect to happen?

How can we reproduce it (as minimally and precisely as possible)?

taskId= 801 table like this

CREATE TABLE "TC_TARCHIVES" 
   (    "VC_TENANT_ID" VARCHAR2(32) NOT NULL ENABLE, 
    "VC_ARCHIVES_NO" VARCHAR2(24) NOT NULL ENABLE, 
    "VC_REQUEST_NO" VARCHAR2(32), 
    "C_ARCHIVES_TYPE" CHAR(2), 
    "B_ARCHIVES_CONTENT" BLOB, 
    "VC_OP_TIME" VARCHAR2(14), 
    "VC_OPERATOR_NO" VARCHAR2(16), 
    "C_AUDIT_FLAG" CHAR(1), 
    "VC_AUDIT_NO" VARCHAR2(16), 
    "C_ARCHIVES_STATE" CHAR(1), 
    "VC_CUST_NO" VARCHAR2(12), 
    "L_SERIAL_NO" NUMBER, 
    "VC_DESCRIBE" VARCHAR2(256), 
    "VC_STORAGE_FILE_NAME" VARCHAR2(255), 
    "VC_TRADE_ACCO" VARCHAR2(32), 
    "VC_MANAGER_CODE" VARCHAR2(18), 
    "VC_REJECT_REASON" VARCHAR2(100), 
    "VC_REMARK" VARCHAR2(256), 
    "VC_PRODUCT_CODE" VARCHAR2(32), 
    "VC_STORAGE_FILE_PATH" VARCHAR2(256), 
    "VC_STORAGE_FILE_NO" VARCHAR2(100), 
    "VC_BATCH_NO" VARCHAR2(32), 
     CONSTRAINT "PK_TC_TARCHIVES" PRIMARY KEY ("VC_TENANT_ID", "VC_ARCHIVES_NO")
   )

Anything else we need to know?

No response

sl01388797 commented 1 month ago

Image The problem still exists