[teiid-issues] [JBoss JIRA] (TEIID-4139) Session/Connection to VDB gets closed after 2 minutes of innactivity

[Jorge Herrera (JIRA)]

Jorge Herrera created TEIID-4139:
------------------------------------

             Summary: Session/Connection to VDB gets closed after 2 minutes of innactivity
                 Key: TEIID-4139
                 URL: https://issues.jboss.org/browse/TEIID-4139
             Project: Teiid
          Issue Type: Bug
          Components: Server
    Affects Versions: 8.7.1
         Environment: RHEL 6, AWS VM, JBoss EAP (standalone)	6.3.2.GA	
JBoss Data Virtualization	6.1.0.ER4
            Reporter: Jorge Herrera
            Assignee: Steven Hawkins
            Priority: Blocker
         Attachments: jdv-jdbc-config.txt, server.log

When setting up a VDB connecting (using jdbc over ssl) to either another VDB in the same server or directly to a RDBMS (Amazon Redshift in this case), if you execute queries one after the other the server works as expected. But if you let the session idle, or just looking at the result set for more than 2 minutes, session gets disconnected with the following message:

_______________________________________________
DBCException: SQL Error [08S01]: org.teiid.net.socket.SingleInstanceCommunicationException
SQL Error [08S01]: org.teiid.net.socket.SingleInstanceCommunicationException
  TeiidSQLException: org.teiid.net.socket.SingleInstanceCommunicationException
  org.teiid.net.socket.SingleInstanceCommunicationException
    SingleInstanceCommunicationException
    org.teiid.net.socket.SingleInstanceCommunicationException
      EOFException
      java.io.EOFException
_______________________________________________



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)