exceptionfactory opened a new pull request, #10703: URL: https://github.com/apache/nifi/pull/10703
# Summary [NIFI-15398](https://issues.apache.org/jira/browse/NIFI-15398) Replaces references to [Apache Derby](https://db.apache.org/derby/) with [HSQLDB](https://hsqldb.org/) for testing. The Apache DB project retired Derby on 2025-10-10 and is no longer providing updates. HSQLDB implements an extensive set of JDBC features, making it an ideal option for testing relational database features. HSQLDB is licensed under a flavor of BSD-3, which is less of a concern as a test-scoped dependency, but provides optimal compatibility with Apache Software License Version 2. Several other Apache projects including Hop, Log4j, and Shiro use HSQLDB for testing. Changes include adding Apache Derby to the list of banned dependencies, removing all references to Derby libraries, and adjusting some test SQL statements to work with HSQLDB. The majority of test SQL statements remain unchanged. Part of the changes include consolidating similar usage of Database Connection Pool implementations in a shared `nifi-embedded-database-service` module. Some modules do not use the DBCP Service interface and still require direct references to the HSQLDB JDBC Driver. Runtime code changes are minimal, and include adjusting a check for the `errorCode` field on `SQLException` in `PutSQL`, allowing negative values as returned from some HSQLDB exceptions. # Tracking Please complete the following tracking steps prior to pull request creation. ### Issue Tracking - [X] [Apache NiFi Jira](https://issues.apache.org/jira/browse/NIFI) issue created ### Pull Request Tracking - [X] Pull Request title starts with Apache NiFi Jira issue number, such as `NIFI-00000` - [X] Pull Request commit message starts with Apache NiFi Jira issue number, as such `NIFI-00000` ### Pull Request Formatting - [X] Pull Request based on current revision of the `main` branch - [X] Pull Request refers to a feature branch with one commit containing changes # Verification Please indicate the verification steps performed prior to pull request creation. ### Build - [X] Build completed using `./mvnw clean install -P contrib-check` - [X] JDK 21 - [X] JDK 25 ### Licensing - [X] New dependencies are compatible with the [Apache License 2.0](https://apache.org/licenses/LICENSE-2.0) according to the [License Policy](https://www.apache.org/legal/resolved.html) - [ ] New dependencies are documented in applicable `LICENSE` and `NOTICE` files ### Documentation - [ ] Documentation formatting appears as expected in rendered files -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
