db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Riemer (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-217) Retrieve columns by name iso index
Date Thu, 17 Jul 2008 14:07:31 GMT

    [ https://issues.apache.org/jira/browse/DDLUTILS-217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12614346#action_12614346

Rick Riemer commented on DDLUTILS-217:

This patch was tested to work on SQL Server 2005, IBM DB2 v9.5 Express-C, PostgreSQL 8.2 and
HSQLDB 1.8.0.

> Retrieve columns by name iso index
> ----------------------------------
>                 Key: DDLUTILS-217
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-217
>             Project: DdlUtils
>          Issue Type: Improvement
>          Components: Core (No specific database)
>    Affects Versions: 1.0
>            Reporter: Rick Riemer
>            Assignee: Thomas Dudziak
>             Fix For: 1.1
>         Attachments: retrieve_column_by_name.patch
> MetaDataColumnDescriptor.readColumn() currently attempts to find the column index of
a column before retrieving it from the ResultSet in order for it to return the default value
if the column does not exist. Some JDBC implementations (e.g. IBM's DB2 JCC4 driver) have
broken ResultSetMetaData implementations however, which do not return the correct columns
> By attempting to retrieve the columns by name iso index before retrieving the ResultSetMetaData
we avoid hitting these broken paths in the general case. It has the added benefit of not having
to retrieve the result set meta data for each column read, which may be potentially harmful
to the performance.
> I'm attaching a patch which implements this behavior.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message