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]

Reply via email to