DataBase table test connectivity unsupported type BLOB or CLOB

Published on June 12, 2019 - 7:05am

Last updated June 14, 2019 - 4:31am

Question

DataBase table test connectivity unsupported type BLOB or CLOB

Hi All,

I created a database table for my class. There is a blob or clob columns. When I try test connectivity in database table definition, I get this Issues "Class MyClassName is mapped to table MyTableName in database MyDatabaseName, which has column TESTBLOBCOLUMN of unsupported type BLOB"

How can I solve this problem?

Data management

System administration

Comments

Keep up to date on this post and subscribe to comments

MarcLasserre_GCS

Pega

June 12, 2019 - 8:07am

Hello,

Are you really expecting a BLOB on your custom table?

RecoD

June 12, 2019 - 8:55am

Response to MarcLasserre_GCS

Hi MarcLasserre_GCS,

Thank you for your response. Blob or other data type is not important for me. I mean, I have a text value property in pega class. Normally, I did not create custom column for it but I could not show my data on report definition. Because my data is too big. Thats why I used this way.

LaurenceB_GCS

Pega

June 12, 2019 - 9:29am

I've seen this before the CLOB object.

For example, if you open up the Rule-Obj-FieldValue class or database table mapping and click on the Test Connection button, you see the same warning.

Do you have any problems outside of the warning the the Test Connection button?