Article - CS228108

"Cannot get a connection, pool error Unable to validate object" or "SQL command not properly ended error" when saving a (JDBC) Database Thing in ThingWorx

Modified: 21-Aug-2025   


Applies To

  • ThingWorx Platform 6.0 N/A to 9.7
  • Oracle Database
  • MySQL
  • Microsoft SQL Server
  • PostgreSQL
  • Informix

Description

  • Cannot get a connection, pool error Unable to validate object error in ApplicationLog when saving a (JDBC) Database Thing or executing query.
  • SQL services on that Thing fails with null error 
  • Unable to Invoke Service on OracleDB : Execute Query failed: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
This is a printer-friendly version of Article 228108 and may be out of date. For the latest version click CS228108