[teiid-issues] [JBoss JIRA] (TEIID-2961) TEIID60016 Duplicate Column with h2 database

[Kenichi Takemura (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kenichi Takemura closed TEIID-2961.
-----------------------------------

    Resolution: Done


> TEIID60016 Duplicate Column with h2 database
> --------------------------------------------
>
>                 Key: TEIID-2961
>                 URL: https://issues.jboss.org/browse/TEIID-2961
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7
>            Reporter: Kenichi Takemura
>            Assignee: Steven Hawkins
>
> I am trying to deploy a vdb.xml that has a physical datasouce with h2 translator. Teiid fails to deploy it with error 'TEIID60016 Duplicate Column'.
> Source database has a table that is 'sessions'. It seems getMetadata() from h2 database returns more columns for sessions table(user database + metadata for h2 itself?).
> It getting Duplicated 'ID' columns.
> On production we use mysql but on our test we want to use h2.
> Is this a bug in Teiid?
> Is there any workaround?



--
This message was sent by Atlassian JIRA
(v6.2.3#6260)