Question
Pegasystems Inc.
JP
Last activity: 1 Mar 2021 21:37 EST
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 Pega. 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.
Pega Platform automatically creates a table and columns as below - all with lower case letters.
This may sometimes cause an issue. For example, if you use Obj-Browse method in an activity to retrieve data from this table, it loads them all with lower case letters - hence you won't be able to reference the data by Property name.
In order to avoid this issue, you'll need to map them in the class form as below.
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 Pega. 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.
Pega Platform automatically creates a table and columns as below - all with lower case letters.
This may sometimes cause an issue. For example, if you use Obj-Browse method in an activity to retrieve data from this table, it loads them all with lower case letters - hence you won't be able to reference the data by Property name.
In order to avoid this issue, you'll need to map them in the class form as below.
This issue has been a while but is there any enhancement yet? It 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****
Self
IN
Hi
When we are mapping external class , then external mapping should be created and this is the OOTB behaviour .
For more details regarding the external mapping :
Regards
Updated: 1 Mar 2021 21:45 EST
Pegasystems Inc.
JP
If you map an existing table outside of Pega database using "External Database Class Mapping" tool, system will create classes and properties all by lower case from the beginning. So there is no need to update External mapping in a class form in that case. I am talking about when you create properties with upper case in an internal database using Data type - system doesn't update External mapping by itself.
Thanks,
Updated: 12 Jun 2020 22:10 EDT
Pegasystems Inc.
JP
I am using the latest version (8.4). Try the following steps.
1. Create a Data Type and define some properties with PascalCase (ex. BidPrice).
2. Obj-Browse the class and check the clipboard. You will find the property name on the clipboard is "bidprice", not "BidPrice".
These two properties are regarded as different things, and it doesn't work unless you define the external mapping manually by yourself.
Thanks,
* MarissaRogers, can we raise an enhancement request for this? Request is, for Pega Platform to handle the differences of DBMS without developers maintenance.
Pegasystems Inc.
US
Sure Kensho (@TSUCK) - do you want to add it as an Idea and then the Moderation Team can submit it into our internal enhancement system?
You can reference this post in the Idea and we'll make sure they're linked.
Thanks!
Marissa | Senior Moderator | Pega Collaboration Center