SAP Knowledge Base Article - Preview

3201063 - Error: "java.sql.SQLException: Zero date value prohibited" when querying through virtual table created from CamelJDBCAdapter remote source

Symptom

  • Query from virtual table created from MySQL database connection through CamelJDBCAdapter failed with error
  • Error: "Caused by: java.sql.SQLException: Zero date value prohibited
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)"
    "Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date"
  • In some case, there is no detail error, but a general error below, from the dpagent trace log, there will be error reported after processing same volume of records.
    "org.apache.camel.RuntimeCamelException: Cannot process result "


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

Mysql, CamelJDBCAdapter, zero, date , 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.