Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

57
Views
 Saket Ranjan (SAKETRANJAN-1) Cognizant Technology Solution Manager-Projects
Cognizant Technology Solution
IN
SAKETRANJAN-1 Member since 2013 2 posts
Cognizant Technology Solution
Posted: December 10, 2019
Last activity: December 10, 2019
Posted: 10 Dec 2019 13:17 EST
Last activity: 10 Dec 2019 13:17 EST
Closed

Class Abc-Data-Xyz is mapped to external DB table which has column 'image' of unsupported type LONGBLOB

Report

Hi All,
We want to get image from an external table present in MySql DB.
The pega platform version is 8.1 on cloud and DB is PostgreSQL.
When we are trying test the connection and map the column 'image' of type LONGBLOB in data class Abc-Data-Xyz, we are getting error
"Class Abc-Data-Xyz is mapped to table which has column 'image' of unsupported type LONGBLOB"
PostgreSQL DB is expecting column type as 'Bytea' while MySql DB has option as 'BLOB' or 'LONGBLOB'."

Can anyone please help in selecting the column type to store image which can be supported by both type of DB server and the property type in Pega to map with it.

Thanks in advance!!

Dev/Designer Studio Data Integration

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice