[
https://issues.apache.org/jira/browse/NIFI-15398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Handermann updated NIFI-15398:
------------------------------------
Status: Patch Available (was: Open)
> Replace Apache Debry 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: 10m
> 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)
