Database Connector Release Notes - Mule 4
Support Category: Select
Anypoint Connector for Database (Database Connector) enables you to connect to relational databases through the JDBC API.
1.14.13
October 29, 2024
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8, 11, and 17 |
Fixed Issues
Issue Resolution | ID |
---|---|
The DB client dependency is upgraded to version 1.6.16 to fix a performance bottleneck caused by a static modifier. |
W-17013834 |
Database Connector no longer fails if it includes a UDT with a clob field as a stored procedure parameter. |
W-16615688 |
Commons-IO is upgraded to version 2.17.0 to address reported security vulnerabilities. |
W-17091979 |
1.14.12
August 26, 2024
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8, 11, and 17 |
Fixed Issues
Issue Resolution | ID |
---|---|
The DB client dependency is upgraded to version 1.6.14 to remove the warn log of the ResolvedDbType class. |
W-16425563 |
1.14.11
July 18, 2024
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8, 11, and 17 |
Fixed Issues
Issue Resolution | ID |
---|---|
The timestamp input parameters are correctly converted to timestamp with local time zone, in OJDBC8 versions 22.x and later. |
W-14492132 |
1.14.10
May 22, 2024
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8, 11, and 17 |
Fixed Issues
Issue Resolution | ID |
---|---|
Numeric input parameters are converted correctly when the input is a string. |
W-15660005 |
1.14.9
March 4, 2024
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8, 11, and 17 |
Fixed Issues
Issue Resolution | ID |
---|---|
Cache is now used for the |
W-14379190 |
Database Connector now returns results in |
W-14376795 |
1.14.8
January 18, 2024
What’s New
-
This connector is now compatible with Java 17.
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8, 11, and 17 |
Fixed Issues
Issue Resolution | ID |
---|---|
Spring core is upgraded to version 5.3.29 to address reported security vulnerabilities. |
W-11854682 |
Spring beans is upgraded to version 5.3.29 to address reported security vulnerabilities. |
W-11854684 |
Spring security is upgraded to version 5.8.6 to address reported security vulnerabilities. |
W-11854690 |
1.14.7
December 7, 2023
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue Resolution | ID |
---|---|
Database Connector no longer fails when a stored procedure has a |
W-13210313 |
1.14.6
October 30, 2023
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue Resolution | ID |
---|---|
Database Connector no longer has a memory leak with Oracle getClobVal. |
W-14200482 |
1.14.5
October 24, 2023
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue Resolution | ID |
---|---|
The Stored Procedure operation now correctly recognizes custom types as IN/OUT parameters when the stored procedure is located within a package. |
W-12516787 |
1.14.4
October 4, 2023
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue Resolution | ID |
---|---|
The On Table Row source now applies the Max rows field to its polling query. |
W-13829389 |
1.14.3
August 9, 2023
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue Resolution | ID |
---|---|
The connector now manages an unspecified input parameter for OJDBC8 version 23.2. |
W-13577226 |
1.14.2
July 12, 2023
What’s New
-
The commons-io library is upgraded to version 2.13.0.
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue Resolution | ID |
---|---|
The Max Rows field is now properly handled if the value is set to |
W-12484975 |
The stored procedure metadata cache now works as intended. |
W-13131343 |
The commons-io library is upgraded to version 2.13.0 to address reported security vulnerabilities. |
W-13720405 |
1.14.1
March 30, 2023
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue Resolution | ID |
---|---|
Database Connector now reads BLOBs from Oracle stored procedures. |
W-12545854 |
1.14.0
January 10, 2023
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue Resolution | ID |
---|---|
Database Connector now supports adding the template cache size in the Cache Query Template Size field of the connector configuration. |
W-12167736 |
1.13.8
October 4, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
The XA Bitronix configuration pool no longer throws |
W-11743085 |
The Store procedure operation no longer returns an issue with a CLOB output while using a local transaction. |
W-11721963 |
The warn message at attempting to override property no longer have the braces with number ({0}.{1}..) displayed. |
W-11755478 |
The MuleRuntimeException shown during resolving query will show the stack trace now. |
W-11762357 |
1.13.7
September 12, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
Memory leaks no longer occur in transaction operations when using LOBs fields. |
W-11582039 |
The XA Bitronix configuration pool no longer throws the |
W-11425936 |
1.13.6
August 3, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
The DataWeave mapping input issue to a CLOB in the Insert operation no longer occurs. |
W-11524839 |
1.13.5
July 11, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
Using the Select operation with CLOB output no longer causes a connection leak. |
W-11259976 |
1.13.4
June 6, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
When using stored procedures, connections no longer leak. Connections are now released at the end of the flow and when consuming CLOBs as an output parameter. |
W-11098541 |
1.13.3
May 26, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
Database Connector no longer needs Oracle’s UDT scheme appended on the type name when you define the scheme on the connector’s global configuration Column types field or in the Parameter types section of the Stored procedure operation. Now, the connector searches the type name correctly. |
W-11002486 |
1.13.2
May 12, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
Database Connector did not log enough information when the Connection Factory caught an exception during the connection creation. Now, the connector logs the proper stack trace with the error level. |
W-10718271 |
Database Connector no longer throws a |
W-10911002 |
1.13.1
April 25, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
The output of |
W-10673234 |
1.13.0
April 11, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
To fix concurrency issues that occur when using the |
W-10673234 |
1.12.1
February 21, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
Database Connector now supports the consumption of LOBs for the IBM’s DB2. |
W-10673315 |
1.12.0
February 4, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
Support Oracle features even if the database connection is provided as a Spring bean reference to a DataSource or as a Generic Connection. |
DBCON-329 |
Access Oracle’s proprietary |
DBCON-352 |
Added synchronization while invoking createArray functions to prevent deadlocks that occurred under high concurrency. |
DBCLI-15 |
1.11.3
January 31, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
Database Connector now allows brackets in the Stored procedure operation query to support the MSSQL Server. |
DBCON-360 |
Added a warning message when a timeout’s value is rounded up. |
DBCON-318 |
1.11.2
January 07, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
Reversed a dependency in Database Connector versions 1.11.0 and 1.11.1 that prevented the deployment of apps. |
DBCON-350 |
1.11.1
January 05, 2022
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
Reversed a change in the Database Connector version 1.11.0 API that prevented the deployment of apps. |
DBCLI-25 |
1.11.0
December 22, 2021
What’s New
TLS support feature for Oracle’s connection provider.
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
The Database Connector Select operation closed the connection at the end of the flow when its result contained a LOB stream. Now the consumption of the LOB streams is tracked, and the connection is closed when there are no more LOB streams to consume or at the end of the flow. |
DBCON-304 |
Timeouts are now rounded up to whole seconds. Because timeouts are set in seconds (JDBC API), the connector rounds up values smaller than a second to avoid waiting indefinitely. |
DBCON-318 |
When using JDBC’s REF_CURSOR type as a stored procedure |
DBCON-319 |
1.10.6
November 10, 2021
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
Inserting data into an Oracle database returned an |
DBCON-311 |
1.10.5
October 27, 2021
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
Large |
DBCLI-10 |
1.10.4
August 20, 2021
Compatibility
Software | Version |
---|---|
Mule |
4.1.1 and later |
Anypoint Studio |
7.3 and later |
OpenJDK |
8 and 11 |
Fixed Issues
Issue | ID |
---|---|
|
DBCLI-12 |
Changed the record level to |
DBCLI-14 |
1.10.3
July 28, 2021
Fixed Issues
-
Database Connector threw an incorrect
QueryExecutionException
exception when theSQLException
thrown by the driver didn’t have an SQLState nor a message related to the connection. Therefore, the reconnection strategy was not triggered. The correct throw message isDB:CONNECTIVITY
. (DBCLI-11)
1.10.2
July 19, 2021
Fixed Issues
-
Database Connector threw an
Invalid column type
message when using Oracle’s XMLTYPE as input for the Stored Procedure operation. The connector now manages the correct type. (DBCON-278) -
Database Connector threw an incorrect
TransactionException
exception when the connection was lost during an XA transaction. Therefore, the reconnection strategy was not triggered. The correct throw message isDB:CONNECTIVITY
. (DBCLI-7) -
The Database Connector Stored Procedure operation incorrectly executed database functions with an IN OUT parameter. Now, the operation performs correctly. (DBCLI-8)
-
Database Connector did not log enough information when the Connection Factory caught an exception during the connection creation. Now, the connector logs the proper information. (DBCLI-9)
1.10.0
June 04, 2021
Features
Added new options for Pooling profile configuration:
-
The Test connection on checkout field enables you to disable connection testing on checkout in order to improve the connector’s performance.
-
The Max statement field enables you to define the total number of
PreparedStatements
a DataSource will cache.
1.9.2
March 22, 2021
Fixed Issues
-
Database Connector threw an incorrect
NoSuchElementException
Java exception for a connection reset while iterating a result, and produced anoncatch
by thetry catch
block. The correct throw message isDB:CONNECTIVITY
. (DBCON-253) -
The Stored Procedure operation threw a
MULE:UNKONWN
error (with aNullPointerException
message) when returning an empty array. (DBCON-255) -
Database Connector closed the connection after reading the entire ResultSet of a Select operation despite having the LOB stream still open. This behavior prevented the LOB values from being read after the connection closure. (DBCON-256)
1.8.0
April 24, 2020
Features
Database Connector now accepts SQL Casting PostgreSQL and Snowflake syntax’s, through the double colon (::) expression. For example, SELECT MAX(modified_date)::DATE FROM sales
, where modified_date
is of type string. This feature does not change the existing behavior for the connector (MULE-18150).
Fixed Issues
-
MySQL driver now logs to the Mule Log when using MySQL Driver 8.x and higher (MULE-18287).
-
Fixed issue that prevented the usage of the BulkInsert Operation within a ForEach scope (MULE-18260).
-
Fixed issue that prevented the logging of information about a BulkUpdate Operation when an Exception was thrown by it (MULE-18290).
1.7.0
March 13, 2020
Features
You can now specify additional pooling profile properties using the additional-properties tab for any Database provider. This feature allows you to specify only additional properties and not to override the main ones (like maxPoolSize) if they were already specified.
Fixed Issues
Fixed issue where oracle DB connector was unable to use specific pooling profile configurations (such as checkoutTimeout
or idleConnectionTestPeriod
). (MULE-17949)
Fixed issue where first stored procedure calls to database took a long time. (MULE-17808)
Fixed issue where operation stored-procedure did not offer the parameter to configure repeatable streaming. (MULE-17898)
1.5.2
April 16, 2019
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.4.0
August 7, 2018
Features
-
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
Features
-
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.1
March 16, 2018
Features
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.