Close popover
Srikanta Ghosh (SRIKANTA)
Cognizant Technology Solutions

Cognizant Technology Solutions
SRIKANTA Member since 2013 3 posts
Cognizant Technology Solutions
Posted: November 18, 2019
Last activity: November 19, 2019

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 SR Exists
Moderation Team has archived post