Question
Infosys
IN
Last activity: 8 Nov 2016 21:34 EST
Multiple Concrete Classes mapped to a single Database Table
In v6.3 I had faced a situation where two classes were mapped to a single database table. While performing a test connectivity on the classes, I used to get an error "External data table XYZ in database PegaRULES has more than one concrete class mapped to it ...". During runtime, the behaviour was pretty erratic. Either of the class instances used to have issues while save/commit. I dont remeber the exact error message that I used to get.
My question here is:
Is the above behaviour in Pega by design? If yes, why so? I think there might be situation when we might need more classes linked to a single table.
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Pegasystems
IN
Pega internally does support multiple classes getting mapped to the same table. To differentiate the records of each of those classes, the pxObjClass column is used.
For external tables, both pzInsKey and pxObjClass are not present and therefore having multiple class instances mapped to the same table is not handled.
That said, kindly share the use case(s) which requires multiple external classes to be mapped to the same database table.