[teiid-issues] [JBoss JIRA] (TEIID-5140) Teiid 10 postgres driver version

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-5140.
-----------------------------------
    Fix Version/s: 10.0.3
                       (was: 10.0.1)
       Resolution: Done


This is partially resolved for 10.0.1.  The latest fix also adds TYPE and SEQUENCE table types to be omitted as tables.

> Teiid 10 postgres driver version
> --------------------------------
>
>                 Key: TEIID-5140
>                 URL: https://issues.jboss.org/browse/TEIID-5140
>             Project: Teiid
>          Issue Type: Bug
>          Components: Documentation, JDBC Connector, ODBC
>            Reporter: Lukáš Svačina
>            Assignee: Steven Hawkins
>             Fix For: 10.1, 10.0.3
>
>
> I tried several drivers from https://jdbc.postgresql.org/download.html and figured out that 9.4-1203 JDBC 42 is the newest working driver for my application.
>  
> Newer drivers cause Teiid to fail on datasource creation with error "Reason:TEIID60011 No column found on table xxxx.pg_toast.pg_toast_16446 with name chunk_id"
> Please update docs about what driver version is recommended (or tested) and if there is any reason to update to newer postgres drivers (what benefits it brings and how teiid uses it). 
> Might be good idea to ship driver within teiid package or at least keep updated _docs\teiid\datasources\postgresql\readme.txt_ to contain recommended driver name.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)