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

Description

  • 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: com.microsoft.sqlserver.jdbc.SQLServerException

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 https://www.ptc.com/en/support/article/CS334683