hutiefang76 opened a new pull request, #419: URL: https://github.com/apache/commons-dbutils/pull/419
`BeanProcessor.processColumn` reads every value with `getObject` before invoking a matching `ColumnHandler`. On Derby, converting a CLOB to a String then fails with SQLState `XCL18` because the handler reads the same LOB column again. Select the handler before retrieving the value. Preserve SQL NULL for reference properties with `wasNull`, keep primitive getter defaults, and use one `getObject` for types without a handler. The new regression models Derby's single-access LOB restriction and fails on the original code with the second-getter SQLException. Six other cases cover SQL NULL for boxed and primitive values, genuine zero/false values, String NULL, fallback identity, and exception propagation. Validation: - Full default Maven build on Microsoft JDK 21.0.10: 533 tests passed, with no failures, errors, or skips. RAT, japicmp, Checkstyle, SpotBugs, PMD and Javadoc also passed. Effective source/target/release is 11. - An additional real embedded Derby 10.17.1.0 check fails with the original source and passes with the patch. It checks 13-character and 40,000-character CLOB contents through `populateBean`, direct getter controls, Blob contents, nullable and primitive SQL NULLs, and genuine zero/false values. Derby is not added as a project dependency. Fixes [DBUTILS-111](https://issues.apache.org/jira/browse/DBUTILS-111). - [x] Read the contribution guidelines for this project. - [x] Read the ASF Generative Tooling Guidance. - [x] I used AI to create part of this pull request. DeepSeek drafted the fix and regression tests. OpenAI Codex reviewed and refined the tests, checked the JDBC contracts, and ran the native validation. - [x] Run a successful build using the default Maven goal. - [x] Write regression tests for the behavioral change. - [x] Describe what the change does, how, and why. - [x] Use a meaningful commit subject and body. -- 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]
