SAP Knowledge Base Article - Preview

2496396 - Reading from Informix databases fail if transactions are not supported - SAP HANA Smart Data Integration


  • Select from Informix DB results in "Error executing the query".  
  • Create virtual table and select from this virtual table fails
  • In framework.trc you see the following:
    • [INFO ][1417] - Start Streaming Thread
      [INFO ][1428] - Streaming SQL : SELECT "Schema"."column",...
      [WARN ] org.apache.camel.component.jdbc.JdbcProducer.processingSqlBySettingAutoCommit[95] - Error occurred during jdbc rollback. This exception will be ignored.
      java.sql.SQLException: Transactions not supported
      at com.informix.util.IfxErrMsg.getSQLException(
      at com.informix.jdbc.IfxSqliConnect.rollback(



  • SAP HANA Smart Data Integration
  • CamelInformixAdapter


SAP HANA 1.0 smart data integration ; SAP HANA smart data integration 2.0


han-dp-sdi, data provisioning, dpserver, eim, autocorrect, rollback, informix, camelinformixadapter , 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.