commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "William R. Speirs (JIRA)" <>
Subject [jira] [Commented] (DBUTILS-101) QueryRunner fails to detect broken pmd
Date Mon, 01 Oct 2012 18:05:08 GMT


William R. Speirs commented on DBUTILS-101:

Not that I know of. However, you can start one here:

The param meta data stuff is weird as I've noticed issues with some calls via SQLServer and
not others, so tracking it down can sometimes be a pain. It is however almost always the first
thing I try when I get a weird/unexpected error.
> QueryRunner fails to detect broken pmd
> --------------------------------------
>                 Key: DBUTILS-101
>                 URL:
>             Project: Commons DbUtils
>          Issue Type: Improvement
>    Affects Versions: 1.5
>            Reporter: S├ębastien Le Ray
>            Priority: Minor
>   Original Estimate: 10m
>  Remaining Estimate: 10m
> I recently fall across a strange issue with SQLServer JDBC driver and DBUtils. PreparedStatement#getParameterMetadata
sometimes throw an SQLException which is not caught in fillParameter.
> The issue arises with pagination queries like
> SELECT * FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY field1 ASC) AS RowNum,  field1 as
id, field2 as reference FROM MY_TABLE WHERE 1 = 1  AND field1 LIKE ?) as toPaginate WHERE
RowNum >= 1 AND RowNum <= 50
> the query is fine but getParameterMetaData throw an exception complaining about a syntax
error near WHERE. Passing pmdKnownBroken to true solves this but stmt.getParameterMetaData();
should be wrapped to catch the exception to adjust pmdKnownBroken.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message