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
Posted: 18 Nov 2019 13:53 EST
Last activity: 19 Nov 2019 2:07 EST

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 Support Case Exists
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.