Troubleshooting
Problem
These errors typically occur when the table does not exist in the specified database or the SQL query is incorrectly configured, such as an incorrect table name or offset column.
Symptom
When utilizing the JDBC Query Consumer, JDBC Multitable Consumer or Lookup processor to establish a connection to a source system, you might encounter the JDBC_34 error:
Error: [JDBC Query Consumer 1] Query failed to execute: 'SELECT * FROM USUARIOS WHERE ID > 0 ORDER BY ID' Error: SQLState: 42S02 Error Code: 2003 Message: SQL compilation error: Object 'USUARIOS' does not exist or not authorized. (JDBC_34)
or
Error: [JDBC Query Consumer 1] Query failed to execute: 'SELECT * FROM Persons WHERE ID > 0 ORDER BY ID' Error: SQLState: 42S22 Error Code: 1054 Message: Unknown column 'ID' in 'where clause' (JDBC_34)
Resolving The Problem
Verify that table is created in the source system under an appropriate DB and schema.
For few source like snowflake you have to mention fully qualified table name in your SQL query.
DB_NAME"."SCHEMA_NAME"."TABLE_NAME"
Example to connect to snowflake using JDBC query consumer:
Here Database = STREAMSETSSES_DB
Schema = ANTONIO_SCHEMA
Table = USU
Query:
| SELECT * FROM STREAMSETSSES_DB.ANTONIO_SCHEMA.USU WHERE ID > ${OFFSET} ORDER BY ID
Document Location
Worldwide
Was this topic helpful?
Document Information
More support for:
IBM StreamSets Data Collector
Software version:
All Version(s)
Document number:
7186116
Modified date:
15 March 2025
UID
ibm17186116