Question
AI4Process Ltd
GB
Last activity: 27 Mar 2018 13:31 EDT
Do we need to have a JVM installed for an external Database server in order to retrieve data of a BLOB column into Pega?
Consider a scenario where a select query is executed to retrieve data from a typical BLOB column which is defined in a DB table that exists in an external schema (on a separate DB server).
It is known that JVM allocates a large chunk of memory in order to read the data stream transmitted from the BLOB column. However, in the case of above scenario, it is not clear whether the JVM utilized is of DB server or Pega Application Server?
Kindly clarify whether having JVM installed on an external DB server is mandatory to retrieve the BLOB data?
Thank You very much!