Article - CS426370

ThingWorx Database template thing fail to save Json data into PostgreSQL json or jsonb column

Modified: 10-Jun-2025   


Applies To

  • ThingWorx Platform 9.4 to 9.5

Description

  • In ThingWorx Foundation, define a SQL Command service of Database Template thing to insert Json data into PostgreSQL json or jsonb column
  • Service fail with below error
    • Unable to Invoke Service *** on ***: class org.json.JSONObject cannot be cast to class java.lang.String (org.json.JSONObject is in unnamed module of loader org.apache.catalina.loader.ParallelWebappClassLoader @53cdecf6; java.lang.String is in module java.base of loader 'bootstrap')
This is a printer-friendly version of Article 426370 and may be out of date. For the latest version click CS426370