You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "Jarrad Waterloo (Jira)" <ji...@apache.org> on 2025/03/26 11:57:00 UTC

[jira] [Updated] (DBUTILS-153) AutoPad PreparedStatement parameters

     [ https://issues.apache.org/jira/browse/DBUTILS-153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jarrad Waterloo updated DBUTILS-153:
------------------------------------
    Description: 
Revise the following method

void AbstractQueryRunner.fillStatement(final PreparedStatement stmt, final ParameterMetaData pmd, final Object... params)

 

to either auto pad 

 

if(pmd.getParameterType(ordinal) == java.sql.Types.CHAR || pmd.getParameterType(ordinal) == java.sql.Types.NCHAR)

{

          final String paddedValue = StringUtils.rightPad(value, pmd.getPrecision(ordinal), ' ');

          ps.setObject(1, paddedValue);

 

 

> AutoPad PreparedStatement parameters
> ------------------------------------
>
>                 Key: DBUTILS-153
>                 URL: https://issues.apache.org/jira/browse/DBUTILS-153
>             Project: Commons DbUtils
>          Issue Type: Bug
>            Reporter: Jarrad Waterloo
>            Priority: Major
>
> Revise the following method
> void AbstractQueryRunner.fillStatement(final PreparedStatement stmt, final ParameterMetaData pmd, final Object... params)
>  
> to either auto pad 
>  
> if(pmd.getParameterType(ordinal) == java.sql.Types.CHAR || pmd.getParameterType(ordinal) == java.sql.Types.NCHAR)
> {
>           final String paddedValue = StringUtils.rightPad(value, pmd.getPrecision(ordinal), ' ');
>           ps.setObject(1, paddedValue);
>  
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)