muleintegrationmulesoftmule-connector

Unable to read DB using Mulesoft SELECT connector

I'm trying to read a Table data in MYSQL DB using Mulesoft SELECT connector, but it's failing with the following error below

java.lang.RuntimeException: Attempted to send invalid data through http response.

Here is my Simple SQL Query to read table data SELECT * FROM mydata;

My SQL connector configuration has JDBC Driver installed, the connection also has necessary configs added like db endpoint, username and password along with port, database name

what could be the issue? because the same query is working from my local terminal.

Solution

  • It may be due to incorrect transformation of result that comes from select connector. Add a transform message logic after select connector.

    Here is an example:

    %dw 2.0
output application/json
---
payload