admin管理员组

文章数量:1023282

I am experiencing an issue while using Apache NiFi 2.0.0-M4 with SqreamDB. Although the JDBC connection is successfully established and verified, executing a simple query (SELECT 1 AS test) results in the message:

contains 1 records; transferring to 'success'

without retrieving any actual data. Additionally, the ExecuteSQL processor remains active and does not complete, preventing the FlowFile from moving to the 'success' relationship.

Environment Details:

  • NiFi Version: 2.0.0-M4
  • JDBC Driver Version: sqream-jdbc-5.3.1.jar
  • Operating System: Oracle Linux 7.9
  • JDBC Connection String:
    jdbc:Sqream://[IP]:[Port]/nbdata;cluster=true;service=user_svc;fetchSize=1;

Steps Taken:

  1. Verified JDBC connection successfully.
  2. Executed SELECT 1 AS test query.
  3. Observed contains 1 records; transferring to 'success' without data retrieval.
  4. ExecuteSQL processor remains active and does not complete.
  5. Attempted changing fetchSize to 100 with no resolution.
  6. Checked NiFi logs for errors, but found none related to this issue.

I am experiencing an issue while using Apache NiFi 2.0.0-M4 with SqreamDB. Although the JDBC connection is successfully established and verified, executing a simple query (SELECT 1 AS test) results in the message:

contains 1 records; transferring to 'success'

without retrieving any actual data. Additionally, the ExecuteSQL processor remains active and does not complete, preventing the FlowFile from moving to the 'success' relationship.

Environment Details:

  • NiFi Version: 2.0.0-M4
  • JDBC Driver Version: sqream-jdbc-5.3.1.jar
  • Operating System: Oracle Linux 7.9
  • JDBC Connection String:
    jdbc:Sqream://[IP]:[Port]/nbdata;cluster=true;service=user_svc;fetchSize=1;

Steps Taken:

  1. Verified JDBC connection successfully.
  2. Executed SELECT 1 AS test query.
  3. Observed contains 1 records; transferring to 'success' without data retrieval.
  4. ExecuteSQL processor remains active and does not complete.
  5. Attempted changing fetchSize to 100 with no resolution.
  6. Checked NiFi logs for errors, but found none related to this issue.

本文标签： Issue with JDBC Data Retrieval in Apache NiFi 200M4 Using SqreamDBStack Overflow

版权声明：本文标题：Issue with JDBC Data Retrieval in Apache NiFi 2.0.0-M4 Using SqreamDB - Stack Overflow 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://it.en369.cn/questions/1745585402a2157561.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。