Question

70
Views
X
SRIKANTA Member since 2013 3 posts
Cognizant Technology Solutions
Posted: 7 months ago
Last activity: 7 months 3 weeks ago

Can we use JDBC equivalent PreparedStatement in connect SQL for DB2 database.

The issue we are facing with Pega RDB-List is that we created a Connect-SQL with {ASIS:..} keyword to build a dynamic WHERE clause and executed the same query THOUSANDS of times by different threads with different value ( “PolicyNumber”) to fetch “Policy Details” from “External DB2 database”. As a result, the DB2 database receives thousands of SQLs and the SQLs are not closed. This causes performance issues. My questions are..

  1. Does Pega RDB-LIST .. {ASIS: keyword} use JDBC equivalent PreparedStatement ?
  2. When does JDBC connection in pega is released?
  3. Should we use a different connect-SQL to make use of JDBC PreparedStatement?

***Moderator Edit-Vidyaranjan: Updated SR details***

Pega Platform Data Integration Java and Activities Data Integration SR Exists
Share this page LinkedIn