What is the format of the array of results returned from a database query using a Database connector configured for MySQL?

The results returned from a database query using a Database connector configured for MySQL are provided in Java format, specifically as a Java List. When you use the Database connector in MuleSoft, the integration framework interacts with the database using JDBC, converting the result set from the database into a collection of Java objects. This allows developers to easily manipulate and access the retrieved data within the Java-based Mule application.

Although other formats like XML, CSV, and JSON are often used for data interchange, they do not represent the raw output managed directly by the MuleSoft Database connector when interfacing with a MySQL database. Instead, those formats could be derived from the Java objects after further processing and transformation within the application. The Java objects serve as the initial step in handling the data obtained from the database query and enable seamless processing within the Mule application.