JDBC_34 - Query failed to execute

  • 8 October 2021
  • 1 reply
  • 228 views

Userlevel 1
  • StreamSets Employee
  • 3 replies

Troubleshooting and Resolution for JDBC_34 - Query failed to execute


1 reply

Userlevel 6
Badge +3

This error can occur when there is:

  • An issue with the structure of the query eg. WHERE clause or ORDER BY clause is required but is missing
  • Database object permissions are not correct

Verify that the query is correctly structured, and verify the permissions on the database objects that are being accessed.  Also, JDBC Query Consumer has an option to disable the validation query.  This will prevent validation, but may lead to other errors later in the Origin’s processing. 

Reply