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
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:
This is a printer-friendly version of Article 334683 and may be out of date. For the latest version click CS334683