[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 reopened TEIID-5140:
-----------------------------------


Retesting with an even newer version and postgis shows a few more table types that need excluded by default.

> 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.1
>
>
> 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)