changelog.md

Change Log

This file contains all the notable changes done to the Ballerina SQL package through the releases.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

[Unreleased]

Added

Changed

• Fix strand hanging when strand count exceeds BALLERINA_SQL_MAX_POOL_SIZE
• Fix stored procedure call having output parameter failing with result set closed error
• Fix stored procedure call having output parameter failing in PostgreSQL
• Fix stored procedure call having output parameter failing in OracleDB

[1.14.1] - 2024-08-29

Changed

• Fix API doc links

[1.14.0] - 2024-08-20

Added

• Support for 2201.10.0 distribution
• Make maximum sql pool size configurable

[1.13.2] - 2024-06-19

Changed

• Run database queries inside transaction block as non blocking query

[1.13.1] - 2024-06-12

Changed

• Clean resources after procedure call failure

[1.13.0] - 2024-02-05

Added

• Support for 2201.9.0 distribution

[1.12.1] - 2024-06-12

Changed

• Clean resources after procedure call failure

[1.12.0] - 2024-02-05

Added

• Support for Cursor based result set retrieval in procedure calls

Changed

• Revert Accept escaped backtick as insertions in parameterised query

[1.11.2] - 2024-06-12

Changed

• Clean resources after procedure call failure

[1.11.1] - 2023-10-16

Changed

• Revert Accept escaped backtick as insertions in parameterised query

[1.11.0] - 2023-09-18

Added

• Support for Java17

[1.10.1] - 2023-10-16

Changed

• Revert Accept escaped backtick as insertions in parameterised query

[1.10.0] - 2023-06-30

Added

• Support retrieval of enum types
• Make some of the Java classes proper utility classes

Changed

• Fix failure for unsupported time type

[1.9.1] - 2023-10-16

Changed

• Revert Accept escaped backtick as insertions in parameterised query

[1.9.0] - 2023-06-01

Changed

• Add GraalVM support

[1.8.1] - 2023-10-16

Changed

• Revert Accept escaped backtick as insertions in parameterised query

[1.8.0] - 2023-04-10

Changed

• Improve documentation regard sql:Column annotation
• Handle null error messages from underlying drivers
• Make sql:Client isolated

[1.7.1] - 2023-03-09

Changed

• Optimise batchExecute with a batch size of 1000

[1.7.0] - 2023-02-20

Changed

• Remove SQL_901 diagnostic hint
• Enable non-Hikari logs

[1.6.2] - 2023-02-09

Changed

• Improve API docs based on Best practices
• Fix SQL compiler plugins failure when the diagnostic code is null

[1.6.1] - 2022-12-22

Changed

• Enable non-Hikari logs

[1.6.0] - 2022-11-29

Changed

• Updated API Docs
• Fix unable to set unlimited lifetime (0) to ballerina.sql.maxConnectionLifeTime
• Improve error message on client connection failure

[1.5.0] - 2022-09-08

Added

• Added support for metadata retrieval

Changed

• Fix sql:queryConcat not working for empty query
• Fix error not being thrown when mandatory fields are not fetched

[1.4.1] - 2022-06-21

Changed

• Fix NullPointerException when retrieving record with default value

[1.4.0] - 2022-05-30

Added

• Improve Database columns to Ballerina record Mapping through sql:Column Annotation

Changed

• Fixed compiler plugin validation for time module constructs

[1.3.1] - 2022-03-01

Changed

• Improve API documentation

[1.3.0] - 2022-01-29

Changed

• Fix Compiler plugin crash when variable is passed for sql:connectionPool

[1.2.1] - 2022-02-03

Changed

• Fix Compiler plugin crash when variable is passed for sql:connectionPool

[1.2.0] - 2021-12-13

Changed

• Fix queryRow method to use module's provided resultParameterProcessor

[1.1.0] - 2021-11-20

Added

• Tooling support for SQL client

Changed

• Accept escaped backtick as insertions in parameterised query
• Add support for handling union types in queryRow()
• Validate connection pool configurations
• Change queryRow return type to anydata
• Make OutParameter get function parameter optional

[1.0.0] - 2021-10-09

Added

• Add support for queryRow
• Add support for async operation
• Implement array types for call procedure
• Add support for passing time:Date and time:TimeOfDay types directly into parameterized queries
• Add support for passing time:UTC type directly into parameterized queries
• Add support for passing time:Civil type directly into parameterized queries
• Add support for retrieving time:Utc type
• Introduce util function to concatenate queries
• Introduce arrayFlattenQuery() function to add IN operator values by using concatenate queries function
• Add support for retrieving time:Civil, time:Date and Time:TimeOfDay types as values using queryRow
• Add functionality to map multiple fields in the return query result to a single typed record field

Changed

• Remove support for string parameter in SQL APIs
• Improve Errors
• Add completion type as nil in SQL query return stream type
• Fix type cast error for query api containing database error
• Fix null pointer exception being thrown when calling stored procedure without specifying return types

[0.6.0-beta.2] - 2021-06-22

Changed

• Change default rowType of the query remote method from nil to <>

[0.6.0-beta.1] - 2021-06-02

Changed

• Add DB connection active status check in native code level
• Remove sending lastInsertId in ExecutionResult for remote call function

Added

• Introduced ArrayValueType type and TypedValue object to configure the types of an SQL array
• Newly introduce TimeWithTimezoneOutParameter and TimestampWithTimezoneOutParameter for using TimeWithTimeZone Type OutParameter