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

 Srikanta Ghosh (SRIKANTA)
Cognizant Technology Solutions

Cognizant Technology Solutions
US
SRIKANTA Member since 2013 3 posts
Cognizant Technology Solutions
Posted: Nov 18, 2019
Last activity: Nov 19, 2019
Posted: 18 Nov 2019 13:53 EST
Last activity: 19 Nov 2019 2:07 EST
Closed

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***

To see attachments, please log in.
Pega Platform
Java and Activities
Data Integration
Support Case Exists

  • Divyasree Ch

Related content:

Related content has not currently been identified for this post.

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