I was able to search the Support Portal and found this and thought it might prove helpful:
The following is a workaround that uses the java code (invoked from an activity) to retrieve the clob data and gets past the 4K limitation. The database ( Data-Admin-DB-Name ) is configured to connect using a JDBC url.
The code is working perfectly if i am hardcoding the connection details, In our application we don't have the Database instance defined.The connection is established through configuration preferences defined in the prconfig file like java:comp/env/jdbc/PegaRULES.Could you please help me out, how to establish the connection through pega which returns the java object,so that i can make use of this object to prepare the statement and execute the query.Thanks for your help!!!
I am glad that the code is working out however don't know if I understand your question. I haven't had the opportunity to work with Java Objects in Pega. Perhaps you might submit a service request using the My Support Portal. Hope they will be able to better assist you.
I have an external table A with few CLOB columns. I wanted to created a database table rule that maps the class containing these properties to this table.Unfortunately the properties are of type text and the columns are CLOB. So when i do test connectivity it gives an error saying that CLOB is unsupportable. In the same scenario, i am not sure how BIX framework works?. In order to avoid the bix we wanted to use direct obj- save for an external table. The class as all the necessary keys defined.