Saving json objects to Oracle database (CLOB field)

604
0
09-26-2023 03:41 AM
wadsonmakari
New Contributor III

Hi all,

I am working on widget that creates user sessions as json objects that I then save to an Oracle database. I am saving the json definition to a CLOB field in Oracle. The tool is working fine except when my session contains graphics whose json definition includes the "imageData"  property. The imageData is typically a very long string > 4000 characters and the whole json string cannot be saved to a CLOB field in Oracle.

Is there a way round this issue? I can't use local storage to save the sessions as the sessions will get deleted if the user clears their cache and they will not have access to their sessions if there access the application from a different computer.

Any pointers will be gratefully received.

Regards,

W Makari.

 

0 Replies