[
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 <[email protected]>
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)
