[jira] [Commented] (NIFI-15398) Replace Apache Derby with HSQLDB for Testing

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/NIFI-15398?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18048373#comment-18048373 ] 

ASF subversion and git services commented on NIFI-15398:
--------------------------------------------------------

Commit 09ace9607b17ef11dcb144490b048e69287ab0bf in nifi's branch refs/heads/main from David Handermann
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=09ace9607b ]

NIFI-15398 Replaced Apache Derby with HSQLDB

- Added Embedded Database Service module with shared implementation for testing
- Added Apache Derby to banned dependencies
- Removed Apache Derby dependencies

Signed-off-by: Pierre Villard <pi...@gmail.com>

This closes #10703.


> Replace Apache Derby with HSQLDB for Testing
> --------------------------------------------
>
>                 Key: NIFI-15398
>                 URL: https://issues.apache.org/jira/browse/NIFI-15398
>             Project: Apache NiFi
>          Issue Type: Improvement
>          Components: Extensions
>            Reporter: David Handermann
>            Assignee: David Handermann
>            Priority: Major
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> The [Apache Derby|https://db.apache.org/derby/] project was retired on 2025-10-10 and will not be receiving future updates. Usage in Apache NiFi is limited to unit tests, so there is no direct impact on operational components.
> There are several embedded relational databases available for Java, including [H2|https://www.h2database.com/], [SQLite|https://github.com/xerial/sqlite-jdbc], and [HSQLDB|https://hsqldb.org/].
> Apache NiFi had historical usage of H2 for both runtime and testing features, but has shifted away from H2 due to a combination of compatibility issues between minor versions and some implications of copyleft licensing. These issues do not necessarily impact usage for unit tests, but prompted an evaluation of alternatives.
> SQLite has a solid foundation in a native library implementation with a JNI wrapper. HSQLDB is implemented in Java without native libraries, and is licensed under a flavor of BSD-3, which is a Category A license according to the Apache Software Foundation. Other Apache projects such as Hop, Log4j, and Shiro also depend on HSQLDB for testing.
> For the purpose of testing JDBC-based components, HSQLDB provides a strong solution that implements an extensive set of capabilities, requiring minimal changes to existing test code in Apache NiFi.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)