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?

Comments

Keep up to date on this post and subscribe to comments

June 12, 2019 - 8:07am

Hello, 

Are you really expecting a BLOB on your custom table?

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.

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?

June 12, 2019 - 9:55am
Response to LaurenceB_GCS

Hi LaurenceB_GCS,

I only see this error. also, I could not insert my data on blob or clob column.

June 12, 2019 - 10:20am

I'm not sure how to cater for the BLOB. But I'm pretty sure I've done this converting varchar2 to a CLOB in the past.

I was under the impression that it was seemless, but CLOB isn't available in early versions. Which version are you using?

June 13, 2019 - 1:01am
Response to LaurenceB_GCS

Our version is 7.1.7. My data is greater than 4000 characters. thats why  I could not use vharchar2 .

June 14, 2019 - 4:31am

I'm afraid I don't really have an answer for you here.

CLOB support wasn't available until 7.2 (7.2.1 I believe)

https://community.pega.com/support/support-articles/clob-support-pega-717

 

And even then, it appeared to need a hotfix to get it to work correctly within report definitions

https://community1.pega.com/community/product-support/question/reading-clob-data-using-report-definition