[jira] Commented: (DDLUTILS-246) JdbcModelReader merges metadata between tables

["Tony Rippy (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DDLUTILS-246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12911021#action_12911021 ] 

Tony Rippy commented on DDLUTILS-246:
-------------------------------------

I've reproduced this issue using PostgreSQL 8.2. I'll try and put together a fix.

> JdbcModelReader merges metadata between tables
> ----------------------------------------------
>
>                 Key: DDLUTILS-246
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-246
>             Project: DdlUtils
>          Issue Type: Bug
>          Components: Core (No specific database)
>    Affects Versions: 1.0
>         Environment: Java 1.5, Oracle 8/9/10/11, DB2 8/9, MSSQL 2000/2005, possibly others
>            Reporter: Frank Jakop
>            Assignee: Thomas Dudziak
>            Priority: Critical
>
> When reading the columns for a table, JdbcModelReader relies on metadata given by DatabaseMetaDataWrapper.
> Given two tables 
> TABLE FOO_MATIC (COL1 INTEGER)
> TABLE FOOTMATIC (COL2 INTEGER, COL3 INTEGER)
> the returned columns for table FOO_MATIC is (COL1, COL2, COL3). No need to say, that subsequent queries on FOO_MATIC fail due to nonexistent columns COL2 and COL3.
> The reason for this behavior is that the underscore is interpreted as a wildcard character in DatabaseMetaData.getColumns(String,String), so both tables match the pattern FOO_MATIC.
> The workaround I use is to re-check the table name in JdbcModelReader.readColumns(DatabaseMetaDataWrapper,String)
>  while (columnData.next())
> {
>     if (columnData.getString("TABLE_NAME").equals(tableName)) 
>     {
>         Map values = readColumns(columnData, getColumnsForColumn());
>         columns.add(readColumn(metaData, values));
>     }
> }

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