--- schema_version: "1" id: e79b546abff74d81858f35155fd6e71a611e068dcaa120ac52d7d9e2b4db31ab title: Database Connector Release Notes collection: mulesoft version: current locale: ja-jp portal_url: https://docs.salesforce.com/mulesoft/current/ja-jp/release-notes/connector/connector-db.md canonical_url: https://docs.mulesoft.com/jp/release-notes/connector/connector-db source_site: docs.mulesoft.com content_type: documentation content_hash: 7a1266ba9b4333874b0052ba7971198fede85600266562d2621ac05aa6e3cacb description: MuleSoft Documentation Site latest: true --- # Database Connector Release Notes Support Category: [Select](https://www.salesforce.com/en-us/wp-content/uploads/sites/4/documents/legal/Agreements/versioning-back-support-policy.pdf) Anypoint Connector for Database (Database Connector) enables you to connect to relational databases through the JDBC API. Guide: [Database Connector User Guide](https://docs.mulesoft.com/db-connector/latest/) ## [](#1-16-6)1.16.6 **October 23, 2026** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

The recommended PostgreSQL JDBC driver is upgraded to version 42.7.14 to address CVE-2026-107314 and CVE-2026-107315. Because the driver is an external library, update the driver supplied to your application to use this version.

W-24468095

The com.google.guava:guava library is upgraded to version 33.7.2-jre.

W-24471653
## [](#1-16-5)1.16.5 **October 2, 2026** ### What’s New - You can opt in to surfacing errors from later statements in Microsoft SQL Server **Execute script** operations by setting the JVM system property `mule.db.connector.sqlserver.surface.script.errors=true`. The property is disabled by default to preserve existing behavior and affects only SQL Server **Execute script** operations. Because this is a JVM-level setting, it applies to all applications in the Mule runtime. Configure it consistently on every worker or replica and restart the runtime after changing JVM arguments. This option improves the visibility of errors within a script; it does not automatically resolve all SQL Server errors. ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

The recommended PostgreSQL JDBC driver is upgraded from 42.7.11 to 42.7.13 to address CVE-2026-54291. Because the driver is an external library, update the driver supplied to your application to use this version.

W-24141242

The com.mchange:c3p0 component is upgraded from 0.14.1 to 0.14.2.

W-3300013

The org.apache.commons:commons-collections4 component is upgraded from 4.5.0 to 4.6.0.

W-3300013

The com.google.guava:guava component is upgraded from 33.6.0-jre to 33.7.1-jre.

W-3300013
## [](#1-16-4)1.16.4 **September 3, 2026** ### What’s New - This release includes general security fixes. ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
## [](#1-16-3)1.16.3 **August 25, 2026** ### What’s New - This connector version requires Mule runtime 4.6.22 or later if you’re using Mule 4.6.x, or Mule runtime 4.9.9 or later if you’re using Mule 4.9.x. If you prefer not to upgrade your Mule runtime, use the connector version released immediately after this one. ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

On the Database On Table Row listener source, the useColumnNumbers setting is now honored both at runtime and at design time (DataSense). Previously the source ignored the flag: emitted rows were always keyed by column name and metadata always showed column names, even when useColumnNumbers was set to true. Rows and metadata are now keyed by column number when the option is enabled, matching the Select and Query Single operations.

W-21982686

The com.mchange:c3p0 component is upgraded to 0.14.1.

W-23664719

The com.mchange:mchange-commons-java component is upgraded to 0.6.1.

W-23664719
## [](#1-16-2)1.16.2 **July 23, 2026** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

On Oracle, metadata resolution no longer stalls or fails for a packaged stored procedure whose owning schema differs from the connection user. A two-part PACKAGE.PROCEDURE call to a foreign-owned package (for example, an Oracle E-Business Suite public-synonym topology) now returns its parameter metadata correctly.

W-22852899

On Oracle, inserting a value into an XMLTYPE column no longer fails with a ClassCastException error (surfaced as DB:QUERY_EXECUTION) when connection pooling is enabled. Pooled XMLTYPE inserts now succeed, as they already do without pooling.

W-22895195
## [](#1-16-1)1.16.1 **June 24, 2026** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

On Microsoft SQL Server, the connector no longer fails with a The statement is closed error when prepared-statement caching is enabled with connection pooling. The connector now defaults the markSessionBoundaries pool property to if-no-statement-cache for SQL Server when a statement cache is active, and an explicit user-provided value continues to take precedence.

W-22560183

The sql parameter now renders as a text input field in Anypoint Code Builder. Previously, the field was advertised with a metadata key resolver and appeared as an empty dynamic dropdown.

W-22901825

Stored-procedure calls that mix hardcoded literal arguments with named placeholders now bind each placeholder to its correct parameter position. Previously, a placeholder following a literal could be bound against the wrong column type, causing a NumberFormatException at runtime.

W-16842191

Stored-procedure connections are now released on the error path, preventing a connection leak when a stored-procedure call fails.

W-22940258

Backtick-quoted identifiers now correctly escape special characters.

W-17922848

The Oracle NLS timestamp String binding is restored, so Oracle timestamp values bind correctly.

W-21816663

ORA-17008 Closed Connection errors that could occur on Oracle in batch and streaming LOB workloads are resolved.

W-22311048

The com.google.guava:guava component is upgraded to 33.6.0-jre.

W-3300013

The commons-io:commons-io component is upgraded to 2.22.0.

W-3300013

The org.apache.commons:commons-lang3 component is upgraded to 3.20.0.

W-3300013
## [](#1-16-0)1.16.0 **May 20, 2026** ### What’s New - Database Connector now provides a configurable LOB (CLOB/BLOB) resource release strategy via the `mule.db.connector.lob.free.strategy` system property. Available strategies are `EAGER` (default), `DEFERRED`, and `NONE`, enabling users to tune performance for queries returning many LOB columns, particularly with Oracle databases. Refer to [Troubleshoot LOB Resource Release Performance](https://docs.mulesoft.com/db-connector/latest/database-connector-troubleshooting#troubleshoot-lob-resource-release-performance). (W-22181640) - The default value of the **Cache Query Template Size** configuration parameter is changed from `50` to `1000`, improving performance for applications that use a large number of distinct SQL queries. (W-21868167) ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

The useColumnNumbers parameter now correctly influences metadata resolution (DataSense). Previously, setting this parameter to true did not affect the metadata keys returned by the connector.

W-21218595

The org.postgresql:postgresql driver is upgraded from 42.7.2 to 42.7.11.

W-3300013

High memory consumption and memory management degradation over time under load due to unclosed connections is resolved.

W-22311048
## [](#1-15-1)1.15.1 **April 15, 2026** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

The com.mchange:c3p0 component is upgraded to 0.12.0.

W-21701822

The com.mchange:mchange-commons-java component is upgraded to 0.4.0.

W-21701822

The org.springframework.security:spring-security-core component is upgraded to 5.8.16.

W-21701822

The org.springframework.security:spring-security-config component is upgraded to 5.8.16.

W-21701822

The com.sun.xml.bind:jaxb-impl component is upgraded to 2.3.9.

W-21701822
## [](#1-15-0)1.15.0 **December 9, 2025** ### What’s New - Database Connector introduced the `useColumnNumbers` flag to allow operations to use column indices (1, 2, 3…​) as map keys instead of column labels, eliminating duplicate key issues when multiple columns share the same name. ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

The connector now correctly handles AbstractMethodError exceptions when calling stored procedures with CLOB type parameters using the jtds-1.3.1 driver for SQL Server. Previously, the connector would fail when the driver’s createClob method threw this error. The connector now catches this exception and falls back to the legacy CLOB handling approach.

W-13179282
## [](#1-14-17)1.14.17 **August 28, 2025** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

The connector now correctly converts string values to data parameters for the Oracle provider.

W-19024421
## [](#1-14-16)1.14.16 **May 29, 2025** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

The connector now properly handles special characters in stored procedure names through the mule.db.commons.defaultParamTypeResolver.enable.fallback system property, providing an alternative configuration method when these characters are present. Refer to System Properties.

W-17967831
## [](#1-14-15)1.14.15 **April 30, 2025** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

The connector correctly resolves the type field for output parameters.

W-17934321

The library commons-collections is upgraded to commons-collections4 version 4.5.0 to address reported security vulnerabilities.

W-18366767
## [](#1-14-14)1.14.14 **March 26, 2025** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

The connector correctly resolves Datetime type parameters for the Oracle provider.

W-16623843

The connector correctly resolves Date type parameters for the Insert operation.

W-17099669
## [](#1-14-13)1.14.13 **October 29, 2024** ### Compatibility
Software Version

Mule

4.1.1 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)1.14.12 **August 26, 2024** ### Compatibility
Software Version

Mule

4.1.1 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)1.14.11 **July 18, 2024** ### Compatibility
Software Version

Mule

4.1.1 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)1.14.10 **May 22, 2024** ### Compatibility
Software Version

Mule

4.1.1 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)1.14.9 **March 4, 2024** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8, 11, and 17
### Fixed Issues
Issue Resolution ID

Cache is now used for the prepareArray and prepareStruct functions.

W-14379190

Database Connector now returns results in CaseInsensitiveLinkedMap, keeping items in order through multiple iterations.

W-14376795
## [](#1-14-8)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

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)1.14.7 **December 7, 2023** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8 and 11
### Fixed Issues
Issue Resolution ID

Database Connector no longer fails when a stored procedure has a $ in the name.

W-13210313
## [](#1-14-6)1.14.6 **October 30, 2023** ### Compatibility
Software Version

Mule

4.1.1 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)1.14.5 **October 24, 2023** ### Compatibility
Software Version

Mule

4.1.1 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)1.14.4 **October 4, 2023** ### Compatibility
Software Version

Mule

4.1.1 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)1.14.3 **August 9, 2023** ### Compatibility
Software Version

Mule

4.1.1 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)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

OpenJDK

8 and 11
### Fixed Issues
Issue Resolution ID

The Max Rows field is now properly handled if the value is set to 0.

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)1.14.1 **March 30, 2023** ### Compatibility
Software Version

Mule

4.1.1 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)1.14.0 **January 10, 2023** ### Compatibility
Software Version

Mule

4.1.1 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)1.13.8 **October 4, 2022** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8 and 11
### Fixed Issues
Issue ID

The XA Bitronix configuration pool no longer throws DB:QUERY_EXECUTION when the Store procedure operation has an output parameter.

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)1.13.7 **September 12, 2022** ### Compatibility
Software Version

Mule

4.1.1 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 createArray or createStruct unsupported exceptions when the Store procedure operation has an array as a parameter.

W-11425936
## [](#1-13-6)1.13.6 **August 3, 2022** ### Compatibility
Software Version

Mule

4.1.1 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)1.13.5 **July 11, 2022** ### Compatibility
Software Version

Mule

4.1.1 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)1.13.4 **June 6, 2022** ### Compatibility
Software Version

Mule

4.1.1 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)1.13.3 **May 26, 2022** ### Compatibility
Software Version

Mule

4.1.1 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)1.13.2 **May 12, 2022** ### Compatibility
Software Version

Mule

4.1.1 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 java.lang.OutOfMemoryError: Java heap space error when using the Insert operation to work with large CLOB files.

W-10911002
## [](#1-13-1)1.13.1 **April 25, 2022** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8 and 11
### Fixed Issues
Issue ID

The output of prepareArray and prepareStruct functions are now properly converted into the actual JDBC objects. Also, when calling store procedures, the correct parameter type is inferred, which avoids breaking the creation of structs and arrays.

W-10673234
## [](#1-13-0)1.13.0 **April 11, 2022** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8 and 11
### Fixed Issues
Issue ID

To fix concurrency issues that occur when using the createArray and createStruct functions, Mule introduces the prepareStruct and prepareArray functions to use instead. These new functions enable Database Connector to defer JDBC values creation until the correct SQL connection is available. The createArray and createStruct functions continue to work as previously. Replace them manually in your code with the new functions.

W-10673234
## [](#1-12-1)1.12.1 **February 21, 2022** ### Compatibility
Software Version

Mule

4.1.1 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)1.12.0 **February 4, 2022** ### Compatibility
Software Version

Mule

4.1.1 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 createARRAY() function using a JDBC standard method to increase compatibility with custom connection pool managers.

DBCON-352

Added synchronization while invoking createArray functions to prevent deadlocks that occurred under high concurrency.

DBCLI-15
## [](#1-11-3)1.11.3 **January 31, 2022** ### Compatibility
Software Version

Mule

4.1.1 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)1.11.2 **January 07, 2022** ### Compatibility
Software Version

Mule

4.1.1 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)1.11.1 **January 05, 2022** ### Compatibility
Software Version

Mule

4.1.1 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)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

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 out parameter, the error unsupported network datatype or representation was thrown. Now the type is handled correctly.

DBCON-319
## [](#1-10-6)1.10.6 **November 10, 2021** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8 and 11
### Fixed Issues
Issue ID

Inserting data into an Oracle database returned an Invalid Column Type error. The variable used as input parameter should be of MIME type text/plain.

DBCON-311
## [](#1-10-5)1.10.5 **October 27, 2021** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8 and 11
### Fixed Issues
Issue ID

Large NVarchar payloads failed with jTDS driver (MSSQL).

DBCLI-10
## [](#1-10-4)1.10.4 **August 20, 2021** ### Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8 and 11
### Fixed Issues
Issue ID

ResultSets with active LobStreams are forcibly closed at the end of a flow.

DBCLI-12

Changed the record level to WARN when unable to determine if there are more records in the ResultSets.

DBCLI-14
## [](#1-10-3)1.10.3 **July 28, 2021** ### [](#compatibility-46)Compatibility
Software Version

Mule

4.1.1 and later

OpenJDK

8 and 11
### [](#fixed-issues-45)Fixed Issues - Database Connector threw an incorrect `QueryExecutionException` exception when the `SQLException` 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 is `DB:CONNECTIVITY`. (DBCLI-11) ## [](#1-10-2)1.10.2 **July 19, 2021** ### [](#fixed-issues-46)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 is `DB: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-1)1.10.1 **July 05, 2021** ### [](#fixed-issues-47)Fixed Issues - Database Connector exported incorrect packages, now the connector exports the correct packages. (DBCON-283, DBCON-286) ## [](#1-10-0)1.10.0 **June 04, 2021** ### [](#features)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-4)1.9.4 **June 01, 2021** ### [](#fixed-issues-48)Fixed Issues - Database Connector logged an exception at **ERROR** level causing a large amount of content to be saved in the log registry. Now the connector uses the correct log level, **DEBUG**. (DBCLI-5) ## [](#1-9-3)1.9.3 **April 05, 2021** ### [](#fixed-issues-49)Fixed Issues - When using the **Insert** operation, Database Connector didn’t correctly resolve the NCLOB types, which resulted in a `DB:QUERY_EXECUTION` error with an `Invalid column type` message. (DBCON-265) ## [](#1-9-2)1.9.2 **March 22, 2021** ### [](#fixed-issues-50)Fixed Issues - Database Connector threw an incorrect `NoSuchElementException` Java exception for a connection reset while iterating a result, and produced a `noncatch` by the `try catch` block. The correct throw message is `DB:CONNECTIVITY`. (DBCON-253) - The **Stored Procedure** operation threw a `MULE:UNKONWN` error (with a `NullPointerException` 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-9-1)1.9.1 **November 30, 2020** ### [](#fixed-issues-51)Fixed Issues - Fixed an issue in which the **On Table Row** operation closed connections once rows were dispatched to the next processor, thus preventing the consumption of streams. (DBCON-234) ## [](#1-9-0)1.9.0 **November 17, 2020** ### [](#minimum-mule-version)Minimum Mule Version Mule 4.1.1 ### [](#features-2)Features - Introduced the **Query single** operation that enables you to select a single record from a database and access the result without any additional transformations to the payload. This operation doesn’t use streaming. ## [](#1-8-3)1.8.3 **September 30, 2020** ### [](#fixed-issues-52)Fixed Issues - Fixed an issue in which stored procedures were not closing connections when no stream was returned, nor any transaction performed. (DBCON-225) - When the `Bulk insert` operation used debug output, it logged a placeholder instead of the record number. (DBCON-228) ## [](#1-8-2)1.8.2 **August 12, 2020** ### [](#fixed-issues-53)Fixed Issues - Fixed "Struct cannot be cast to \[Ljava.lang.Object" issue that prevented the connector to create SQL Arrays or Structs containing BLOBs or CLOBs types. (DBCON-190) ## [](#1-8-1)1.8.1 **June 1, 2020** ### [](#minimum-mule-version-2)Minimum Mule Version Mule 4.1.1 ### [](#features-3)Features None ### [](#fixed-issues-54)Fixed Issues - Fixed issue where connections were not closed if a stored procedure returned multiple result sets. (DBCON-182) - Fixed issue where dbCreateStruct performance introduced a regression since Mule 3.9.4. (DBCON-178) ## [](#1-8-0)1.8.0 **April 24, 2020** ### [](#minimum-mule-version-3)Minimum Mule Version Mule 4.1.1 ### [](#features-4)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-55)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)1.7.0 **March 13, 2020** ### [](#minimum-mule-version-4)Minimum Mule Version Mule 4.1.1 ### [](#features-5)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-56)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-6-2)1.6.2 **January 9, 2020** ### [](#minimum-mule-version-5)Minimum Mule Version Mule 4.1.1 ### [](#features-6)Features None ### [](#fixed-issues-57)Fixed Issues The infinite loop when using stored procedure with H2 Database issue is fixed. (MULE-17793) ## [](#1-6-1)1.6.1 **January 7, 2020** ### [](#minimum-mule-version-6)Minimum Mule Version Mule 4.1.1 ### [](#features-7)Features None ### [](#fixed-issues-58)Fixed Issues - The issue where connection leaks occurred when using dynamic configurations is fixed. (MULE-17792) - The issue where using stored procedures with a CLOB `In Out` parameter failed to execute on Oracle is fixed. (MULE-17846) ## [](#1-6-0)1.6.0 **October 11, 2019** ### [](#minimum-mule-version-7)Minimum Mule Version Mule 4.1.1 ### [](#features-8)Features You can now reference the name of a package of stored procedures on Oracle. (MULE-17418) ### [](#fixed-issues-59)Fixed Issues Pooled DB connections maxIdleTime default 0 causes connections to remain open. (MULE-17601) ## [](#1-5-5)1.5.5 **September 24, 2019** ### [](#minimum-mule-version-8)Minimum Mule Version Mule 4.1.1 ### [](#features-9)Features None ### [](#fixed-issues-60)Fixed Issues - Stored procedures took too long to execute with the Oracle Database. (MULE-17394) - Unable to retrieve responses with custom data types. (MULE-17470) - Unable to execute stored procedures defined within packages on an Oracle Database. (MULE-17418) ## [](#1-5-4)1.5.4 **June 6, 2019** ### [](#minimum-mule-version-9)Minimum Mule Version Mule 4.1.1 ### [](#features-10)Features None ### [](#fixed-issues-61)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)1.5.3 **May 7, 2019** ### [](#minimum-mule-version-10)Minimum Mule Version Mule 4.1.1 ### [](#features-11)Features None ### [](#fixed-issues-62)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)1.5.2 **April 16, 2019** ### [](#minimum-mule-version-11)Minimum Mule Version Mule 4.1.1 ### [](#features-12)Features Add connector icon. ### [](#fixed-issues-63)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)1.5.0 **December 28, 2018** ### [](#minimum-mule-version-12)Minimum Mule Version Mule 4.1.1 ### [](#features-13)Features The connector now supports the usage of Struct and Array types out of the box. ### [](#fixed-issues-64)Fixed Issues DB Connector doesn’t work OOTB with Struct and Array types. (MULE-16074) ## [](#1-4-3)1.4.3 **December 11, 2018** ### [](#minimum-mule-version-13)Minimum Mule Version Mule 4.1.1 ### [](#features-14)Features None ### [](#fixed-issues-65)Fixed Issues Database connector not releasing connections. (MULE-16072) ## [](#1-4-2)1.4.2 **October 18, 2018** ### [](#minimum-mule-version-14)Minimum Mule Version Mule 4.1.1 ### [](#features-15)Features None ### [](#fixed-issues-66)Fixed Issues Queries get cached without any TTL or limit, which causes memory to grow. (MULE-15869) ## [](#1-4-1)1.4.1 **October 16, 2018** ### [](#minimum-mule-version-15)Minimum Mule Version Mule 4.1.1 ### [](#features-16)Features None ### [](#fixed-issues-67)Fixed Issues - Can’t get stored procedure name from SQL query when there is whitespace before parentheses. (MULE-15793) - MySQL default driver causes a memory leak. (MULE-15748) - Database On Table Row should hint available columns for ID and Watermark using Value Providers. (MULE-15644) ## [](#1-4-0)1.4.0 **August 7, 2018** ### [](#minimum-mule-version-16)Minimum Mule Version Mule 4.1.0 ### [](#features-17)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-68)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)1.3.4 **June 29, 2018** ### [](#minimum-mule-version-17)Minimum Mule Version Mule 4.1.0 ### [](#features-18)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-69)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)1.3.3 **May 21, 2018** ### [](#minimum-mule-version-18)Minimum Mule Version Mule 4.1.0 ### [](#features-19)Features Fixed issue that makes the connector log the JDBC URL. ### [](#fixed-issues-70)Fixed Issues Database connector logs passwords. (MULE-15047) ## [](#1-3-2)1.3.2 **May 7, 2018** ### [](#minimum-mule-version-19)Minimum Mule Version Mule 4.1.0 ### [](#features-20)Features Minor internal changes. ### [](#fixed-issues-71)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)1.3.1 **March 16, 2018** ### [](#minimum-mule-version-20)Minimum Mule Version Mule 4.1.0 ### [](#features-21)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. ### [](#fixed-issues-72)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)1.3.0 **March 2, 2018** ### [](#minimum-mule-version-21)Minimum Mule Version Mule 4.1.0 ### [](#features-22)Features 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)Upgrade Requirements Mule 4.1 ### [](#fixed-issues-73)Fixed Issues - Create Trigger for Database. (MULE-14657) - DB Connector returns ClLOB objects instead of InputStreams. (MULE-14615) ## [](#1-2-0)1.2.0 **January 19, 2018** ### [](#minimum-mule-version-22)Minimum Mule Version Mule 4.0.0 ### [](#features-23)Features 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-74)Fixed Issues - ColumnTypes parameter should be placed on Advanced Tab. (MULE-14515) - Add Value Providers for SubSubProtocols in Derby Connection Provider. (MULE-13921) ## [](#see-also)See Also - [Salesforce Help](https://help.salesforce.com) - [MuleSoft Services](https://www.mulesoft.com/support-and-services) - [Known Issues](https://help.salesforce.com/s/issues)