SAP Knowledge Base Article - Preview

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

Symptom

  • 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)
      ...


Read more...

Environment

  • SAP HANA Smart Data Integration
  • CamelInformixAdapter

Product

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

Keywords

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.