Contact Free trial Login

Database Connector Release Notes for Mule 4

Support Category: Select

1.5.4

June 6, 2019

Minimum Mule Version

Mule 4.1.1

New Features and Enhancements

  • No new features were added in this version.

Fixed Issues

  • On stored procedures where the output return variable is set to null, the output should not be processed further. (MULE-16961)

  • db:select operation fails to throw a connectivity error (MULE-16950)

1.5.3

May 7, 2019

Minimum Mule Version

Mule 4.1.1

New Features and Enhancements

  • No new features were added in this version.

Fixed Issues

  • Connector doesn’t ensure data is consumable by DataWeave if it has an encoding different from the one used by the runtime. (MULE-16460)

  • Clob in out parameters are not made consumable with Oracle DB. (MULE-16770)

1.5.2

April 16, 2019

Minimum Mule Version

Mule 4.1.1

New Features and Enhancements

  • Add connector icon.

Fixed Issues

  • Errors while transforming to JSON the output of Oracle SP call with custom types. (MULE-16589)

  • Can’t get parameter data types when store procedure name includes schema. (MULE-16685)

  • FlowListener callback retains too much state. (MULE-16366)

  • Errors when using Oracle’s UDT Table type. (MULE-16401)

  • Database connector not sending value of the IN-OUT parameter. (MULE-16484)

  • "Unable to convert between" error when using SP in MsSql. (MULE-16339)

1.5.0

December 28, 2018

Minimum Mule Version

Mule 4.1.1

New Features and Enhancements

  • The connector now supports the usage of Struct and Array types out of the box.

Fixed Issues

Issue Description

DB Connector doesn’t work OOTB with Struct and Array types

1.4.3

December 11, 2018

Minimum Mule Version

Mule 4.1.1

New Features and Enhancements

  • No new features were added in this version.

Fixed Issues

Issue Description

Database connector not releasing connections

1.4.2

October 18, 2018

Minimum Mule Version

Mule 4.1.1

New Features and Enhancements

  • No new features were added in this version.

Fixed Issues

Issue Description

Queries get cached without any TTL or limit, which causes memory to grow.

1.4.1

October 16, 2018

Minimum Mule Version

Mule 4.1.1

New Features and Enhancements

  • No new features were added in this version.

Fixed Issues

Issue Description

Can’t get stored procedure name from SQL query when there is whitespace before parentheses

MySQL default driver causes a memory leak

Database On Table Row should hint available columns for ID and Watermark using Value Providers

1.4.0

August 7, 2018

Minimum Mule Version

Mule 4.1.0

New Features and Enhancements

  • Now in Generic Connections, the username and password can be configured outside the JDBC URL for improved security and support for multitenancy.

  • Improved New Row trigger, now hints with the available tables to retrieve rows.

  • Support for PostgreSQL type casting.

Fixed Issues

  • Database On New Row listener should provide a hint to available tables. (MULE-15310)

  • Database Connector uses deprecated DriverClass when using new MySQL Drivers. (MULE-15218)

  • Database Connector doesn’t support PostgreSQL type casting. (MULE-15101)

1.3.4

June 29, 2018

Minimum Mule Version

Mule 4.1.0

New Features and Enhancements

  • Fixed issue that prevented inserting and updating CLOB types in Oracle Databases.

  • When using the newest MySQL Driver, the connector uses the new preferred Driver Class instead of the old deprecated one.

  • Fixed issue when consuming CLOB and BLOB types when using Derby databases.

Fixed Issues

  • Database Connector should automatically transform CLOB types on Oracle Databases. (MULE-15240)

  • Database Connector uses deprecated DriverClass when using new MySQL Drivers. (MULE-15218)

1.3.3

May 21, 2018

Minimum Mule Version

Mule 4.1.0

New Features and Enhancements

Fixed issue that makes the connector log the JDBC URL.

Fixed Issues

1.3.2

May 7, 2018

Minimum Mule Version

Mule 4.1.0

New Features and Enhancements

Minor internal changes.

Fixed Issues

  • SQL Server Connection provider doesn’t communicate the library RegEx. (MULE-14876)

  • Upgrade c3p0 to Mule fork version. (MULE-14859)

1.3.1

March 16, 2018

Minimum Mule Version

Mule 4.1.0

New Features and Enhancements

This release includes the following enhancements, changes, and fixes:

  • Now the Oracle Connection can be configured with a Service Name.

  • When doing a Select now the output metadata communicates correctly if the columns values can be have a null value or not.

  • In some scenarios when an error occurs the connection string with embedded credentials could be logged.

Fixed Issues

  • Connectors doesn’t communicate correctly if their POJOs properties are nullable or not. (MULE-14701)

  • Credentials leak in error messages. (MULE-14740)

  • Add the capability of configuring the Service Name for an Oracle Connection. (MULE-14750)

1.3.0

March 2, 2018

Minimum Mule Version

Mule 4.1.0

New Features and Enhancements

This release includes the following enhancements, changes, and fixes:

  • Added a new message source which triggers a flow per each row in a table.

  • When doing a SELECT over a CLOB column the value is retrieved as a InputStream.

Upgrade Requirements

Mule 4.1

Fixed Issues

  • Create Trigger for Database. (MULE-14657)

  • DB Connector returns ClLOB objects instead of InputStreams. (MULE-14615)

1.2.0

January 19, 2018

Minimum Mule Version

Mule 4.0.0

New Features and Enhancements

This release includes the following enhancements, changes, and fixes:

  • Added out-of-the-box support for connecting to Microsoft SQL Server Databases.

  • Improved support for Derby sub-protocols.

  • Improved UX.

Fixed Issues

  • ColumnTypes parameter should be placed on Advanced Tab. (MULE-14515)

  • Add Value Providers for SubSubProtocols in Derby Connection Provider. (MULE-13921)