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

[Steven Hawkins (Jira)]

Steven Hawkins created TEIIDSB-144:
--------------------------------------

             Summary: Calling setTransactionIsolation on pg driver causes the connection to be closed
                 Key: TEIIDSB-144
                 URL: https://issues.jboss.org/browse/TEIIDSB-144
             Project: Teiid Spring Boot
          Issue Type: Bug
          Components: datasource
            Reporter: Steven Hawkins
             Fix For: 1.3.0


An attempt to set the isolation level 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)