Article - CS334683

Line breaks in SQL Service (Database Thing) are not properly handled in ThingWorx 9.1.0

Modified: 26-Feb-2021   

Applies To

  • ThingWorx Platform 9.1 F000


  • ThingWorx Database Thing used to connect to external database via JDBC does not properly handle line breaks in SQL queries
  • Executing service containing SQL queries fails with either of the following errors:
Unable to Invoke Service <service_name> on <database_thing_name> : Execute Query failed:

Execute Query failed: java.sql.SQLSyntaxErrorException
  • Previously worked on ThingWorx 8.5 and 9.0
  • Service worked in 8.3 does not work in 9.1, error message: 
             Invalid column name '<columnName>'
This is a PDF version of Article CS334683 and may be out of date. For the latest version click