SAP Knowledge Base Article - Preview

3754124 - [Cloud Integration] JDBCDriverException : invalid column name

Symptom

Message processing fails when performing an Upsert or Select operation via the JDBC adapter, with an error "com.sap.it.rt.adapter.jdbc.exceptions.JDBCException: Root Cause: - PreparedStatementCallback; bad SQL grammar []; nested exception is com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [xxx]: invalid column name: XXX__XXX__X: line X col X (at pos X) - SAP DBTech JDBC: [xxx]".


Read more...

Environment

  • SAP Cloud Integration
  • SAP Integration Suite

Product

Cloud Integration all versions

Keywords

jdbc adapter, upsert, update_insert, bad sql grammar, preparedstatementcallback, sql syntax error near ')', code 257, jdbcdriverexception, hana jdbc, cloud integration, update operation, select statement, sql syntax error, jdbc sql update, CPI, CI, IS, invalid column , KBA , LOD-HCI-PI-CON-JDBC , JDBC Adapter , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.