SAP Knowledge Base Article - Preview

3076151 - Preview on Mysql or MariaBD data not working in Datasphere through CamelJDBCAdapter

Symptom

  • Preview on Mysql or MariaBD data not working in Datasphere through CamelJDBCAdapter
  • Error in framework.trc file.
    • Error: "com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax"
    • Error: "java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near"
    • DPFramework | AsyncHandler.processStreamingExecuteStatement: Exception while processing request "SDA Response for CamelJdbcAdapter of type SUCCESS_MSG responding to FEDERATION_GET_NEXT"
    • DPFramework | AsyncHandler.processStreamingExecuteStatement: com.sap.hana.dp.adapter.sdk.AdapterException: Camel execution failed. Context: org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[ID-***]"


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

jdbc, SDI, connection, preview , 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.