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?
Turkiye Finans
TR
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.
PEG
GB
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?
PEG
GB
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?
PEG
GB
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://collaborate.pega.com/question/reading-clob-data-using-report-definition