Question

5
Replies
106
Views
TSUCK Member since 2010 123 posts
PEGA
Posted: 4 months ago
Last activity: 3 months 1 week ago

Upper case and Lower case issue with PostgreSQL database

Hi,

In PostgreSQL, database objects name (column name, table name, etc) are handled in lower case. This is by their design, and it's not up to us. Let's say, we create a class and properties with letters that starts with upper case (This is a Java/Pega standard practice) as below.

Class & Properties with Upper Case and Lower Case

Pega Platform automatically creates a table and columns as below - all with lower case letters.

PostgreSQL Table and Column with all lower case

This causes an issue. For example, if I use Obj-Browse method in an activity to retrieve data from this table, it loads them all with lower case letters - hence I can't reference to the data by Property name.

data loaded with lower cases

In order to avoid this issue, I have to map them in the class form as below.

External Mapping

This issue has been a while but is there any enhancement yet? This bug doesn't happen in Oracle.

 

FYI, below link talks about the same issue but there is not applicable solution provided.

https://collaborate.pega.com/question/obj-methods-return-properties-lower-case-postgresql

 

Thanks,

 

 

***Edited by Moderator Marissa to update Platform Capability tags****

Pega Platform 8.4 Data Integration
Share this page LinkedIn