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.

Discussion

 Anirvan Das (AnirvanD)
Virtusa Consulting Services Pvt. Ltd.
Senior Consultant
Virtusa Consulting Services Pvt. Ltd.
IN
AnirvanD Member since 2015 4 posts
Virtusa Consulting Services Pvt. Ltd.
Posted: Jul 1, 2015
Last activity: Aug 31, 2015
Posted: 1 Jul 2015 8:04 EDT
Last activity: 31 Aug 2015 5:37 EDT
Closed

When to use rdb methods over obj methods

Hi,

I am looking for a clear explanation on where to use RDB methods instead of Obj methods. I have already considered the following points.

  1. To access tables outside pega database. However, we can use external class to map to outside db table and use Obj methods. One point to note here, Pega recommends to use Obj methods for external tables in rare occasions and use of Rdb methods are preferred. Not sure why. Would be great if anybody can explain this as well.
  2. Complex query. However, we can use Report definition etc. which can achieve similar output
  3. rdb methods does instant commit while you can have deferred commit in obj methods. However obj methods also have Write Now option which will commit instantly.

Given the above points please let me know if there are any particular reasons / situations where I should use RDB methods over Obj.

Thanks to all the great minds in advance.

To see attachments, please log in.
Java and Activities

Posted: 9 years ago
Posted: 1 Jul 2015 8:16 EDT
Teng Hao Chua (chuat)
PEGA
Senior Principal Technical Trainer
Pegasystems Inc.
SG

Generally all queries should be through the use of Obj methods. If you use RDB methods, you will not be able to access BLOBs. However, RDB methods are necessary if you want to execute stored procedures.

To see attachments, please log in.
Posted: 9 years ago
Posted: 1 Jul 2015 8:29 EDT
Anirvan Das (AnirvanD)
Virtusa Consulting Services Pvt. Ltd.
Senior Consultant
Virtusa Consulting Services Pvt. Ltd.
IN

Thanks for the quick reply Chuat. I agree rdb is required to execute stored procedure. So this probably be the only actual reason to use RDB methhods.

However, could you please also explain why pega recommends to use RDB methods to access tables outside Pega DB?

Thanks again.

 

To see attachments, please log in.
Posted: 9 years ago
Posted: 1 Jul 2015 8:34 EDT
Teng Hao Chua (chuat)
PEGA
Senior Principal Technical Trainer
Pegasystems Inc.
SG

As you highlighted, it's in rare occasions. I won't sweat it and stick with Obj methods even with external tables, unless the Obj method is unable to perform what is required, then I'll go with a RDB method as it permits more complex statements to be performed.

To see attachments, please log in.
Posted: 9 years ago
Posted: 31 Aug 2015 5:37 EDT
Anirvan Das (AnirvanD)
Virtusa Consulting Services Pvt. Ltd.
Senior Consultant
Virtusa Consulting Services Pvt. Ltd.
IN

Hi All,

Thanks for all your inputs. I am pretty clear on this now. However I have another question posted on integration. If anyone has some idea please check the following url and share your thoughts.

https://pdn.pega.com/forums/authenticationtype/runtimeservletname-and-secureservletname

Thanks in advance.

To see attachments, please log in.

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