[teiid-issues] [JBoss JIRA] (TEIIDSB-144) Calling setTransactionIsolation on pg driver causes the connection to be closed

[Steven Hawkins (Jira)]

    [ https://issues.redhat.com/browse/TEIIDSB-144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13950433#comment-13950433 ] 

Steven Hawkins commented on TEIIDSB-144:
----------------------------------------

His hack does not need to obtain a connection as the field is static.  I've put in a pr to add something similar.  However if there are additional error codes we'll need to expand this.  Also it affects all datasources, not just pg.  It will be good to eventually have the a better solution.

> Calling setTransactionIsolation on pg driver causes the connection to be closed
> -------------------------------------------------------------------------------
>
>                 Key: TEIIDSB-144
>                 URL: https://issues.redhat.com/browse/TEIIDSB-144
>             Project: Teiid Spring Boot
>          Issue Type: Bug
>          Components: datasource
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Critical
>             Fix For: 1.4.0, 1.3.1
>
>   Original Estimate: 4 hours
>          Time Spent: 2 hours
>  Remaining Estimate: 2 hours
>
> An attempt to set the isolation level on pg 42.2.8 resulted in an exception SQLSTATE 0a000 - unsupported - which causes the connection pool to mark the connection as broken:
> {code}
> 2019-11-25 23:07:50.125  WARN 43993 --- [ProcessorQueue6] com.zaxxer.hikari.pool.ProxyConnection   : HikariPool-1 - Connection org.postgresql.jdbc.PgConnection at 2ffebc7e marked as broken because of SQLSTATE(0A000), ErrorCode(0)
> org.postgresql.util.PSQLException:
>         at org.postgresql.jdbc.PgConnection.setTransactionIsolation(PgConnection.java:851) ~[postgresql-42.2.8.jar:42.2.8]
>         at com.zaxxer.hikari.pool.ProxyConnection.setTransactionIsolation(ProxyConnection.java:407) ~[HikariCP-3.2.0.jar:na]
>         at com.zaxxer.hikari.pool.HikariProxyConnection.setTransactionIsolation(HikariProxyConnection.java) ~[HikariCP-3.2.0.jar:na]
>         at org.teiid.translator.jdbc.JDBCBaseExecution.<init>(JDBCBaseExecution.java:72) ~[translator-jdbc-12.3.0.jar:12.3.0]
> {code}



--
This message was sent by Atlassian Jira
(v7.13.8#713008)