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 ] com.sap.hana.dp.adapter.framework.core.WorkerThread.processStreamingExecuteStatement[1417] - Start Streaming Thread
  [INFO ] com.sap.hana.dp.adapter.framework.core.WorkerThread.processStreamingExecuteStatement[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(IfxErrMsg.java:407)
  at com.informix.jdbc.IfxSqliConnect.rollback(IfxSqliConnect.java:2123)
  ...

• SAP HANA Smart Data Integration
• CamelInformixAdapter

han-dp-sdi, data provisioning, dpserver, eim, autocorrect, rollback, informix, camelinformixadapter , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem