SAP Knowledge Base Article - Preview

3539912 - [CamelJdbcAdapter] Syntax error thrown when querying StarRocks DB - SAP HANA Smart Data Integration

Symptom

  • Connecting to StarRocks DB via the Camel JDBC Adapter with MySQL JDBC driver.
    • StarRocks is compatible with MySQL protocols.
  • Metadata (list of tables) is visible through the remote source.
  • When running a SQL query on the StarRocks DB, a syntax error is thrown:
    • [ERROR] [] DefaultErrorHandler | CamelLogger.log  - Failed delivery for (MessageId: <ID> on ExchangeId: <ID>). Exhausted after delivery attempt: 1 caught: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL version for the right syntax to use [...]


Read more...

Environment

SAP HANA smart data integration 2.0

Product

SAP HANA smart data integration 2.0

Keywords

Camel JDBC adapter, StarRocks, syntax error , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.