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

 Eranda Weerasingha (Eranda10274)
Evonsys (PVT) LTD
Engineer- Technology
Evonsys (PVT) LTD
LK
Eranda10274 Member since 2021 50 posts
Evonsys (PVT) LTD
Posted: Mar 31, 2023
Last activity: Apr 4, 2023
Posted: 31 Mar 2023 14:57 EDT
Last activity: 4 Apr 2023 21:11 EDT
Closed

Insert Data to External PgAdmin DB table

Hi Team,

This is my PgAdmin 2 table structure,

Customer {ID, Name, Age, Country}

Address {CustomerID, City, Sate} -->> foriegn key (customerID)

 

Using RDB method I want to insert this data for 2 table. for this senario should I create tow activity or can it do withing one activity ?

                                               

To see attachments, please log in.
Pega Platform 8.7
Pega Express
Robotic Process Automation
App Studio
Low-Code App Development
System Architect

Posted: 2 years ago
Posted: 31 Mar 2023 23:53 EDT
Aruldevan Thangappan T (ArulDevan)
NCS Pte. Ltd
Aruldevan Thangappan T
NCS Pte. Ltd
SG

Hi @Eranda10274, Can we understand if you are facing any issues during implementation? Technically you can achieve this using single or different activities. It depends on your data structure too. In this case, I see 2 potential classes (Customer and Address). I would suggest to modularise the code ( activity / other code block) in a way that each works independently.  I would also suggest to check if you can make use of data pages for data retrieval and save.  Please let us know if you are facing any issues.

Thanks,

Devan

To see attachments, please log in.
Posted: 2 years ago
Posted: 1 Apr 2023 1:23 EDT
Eranda Weerasingha (Eranda10274)
Evonsys (PVT) LTD
Engineer- Technology
Evonsys (PVT) LTD
LK

@ArulDevan  No issue, have problem,  there is a  foriegn key in address so firstly customer should add to table then only we can add address table data, right ?

in my activity I have tried this way 

my Activity method for save data

 

1 -->> use for customer 

2 -->> use for address

 

If first or  second method failed , should I rallback all the db commit , right ?

my other problen - -> After the first save method is executed, then only  it goes to the bellow method, right ? 

To see attachments, please log in.
Posted: 2 years ago
Posted: 1 Apr 2023 2:32 EDT
Aruldevan Thangappan T (ArulDevan)
NCS Pte. Ltd
Aruldevan Thangappan T
NCS Pte. Ltd
SG

Hi @Eranda10274: With foreign key constraint in database, actions will fail if it doesn’t meet criteria. In terms of exception handling, yes you should do. But take note that RDB methods will do auto commit where you cannot handle transactions dependencies (here you can’t do rollback). Please try to use OBJ methods if you want to manage transactions. 

In terms of sequence in activity rule, yes it will follow executions step by step (will jump to other steps if any defined).

Please also see the below reference 

Activity

RDB-Save

Thanks. 

To see attachments, please log in.
Posted: 2 years ago
Updated: 2 years ago
Posted: 1 Apr 2023 4:53 EDT
Updated: 1 Apr 2023 5:49 EDT
Aruldevan Thangappan T (ArulDevan)
NCS Pte. Ltd
Aruldevan Thangappan T
NCS Pte. Ltd
SG

Hi @Eranda10274: If you want to rollback customer data if any failure in address save transaction, I suggest to use OBJ methods followed by commit. Obj method will add the save operation to deferred queue and the commit will be performed once. If any failure in one transaction, both will be rolled back. If this is called from activity, Commit is not mandatory because flow will take care of committing data.

Refer Obj-Save.

Thanks. 

To see attachments, please log in.

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