[
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 names.
> 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.
