Connection error [Vertica][VJDBC](100102) when using Cognos 10.2.2 to query Vertica 7.1
Under certain circumstances, the Vertica JDBC Connection will not clear.
Is there a way for us to force the buffer to empty, upon the user exiting their session?
Here is the scenario:
A Cognos user runs a query against vertica and vertica returns a multi page result. For this user everything appears normal. Perhaps the user scrolls through the first few pages of the result, but never goes to the last page, instead after finding what they want, they exit (closing the browser window)
At this point there is still data in the JDBC connection buffer.
User #2 then attempts to run a query and recevies this error:
[Vertica][VJDBC](100102) Statement "select * from _______" cannot execute because the driver has not finished reading the current open ResultSet. The driver cannot finish reading the current ResultSet because its buffer (8192 bytes) is full. The current ResultSet must be fully iterated through or closed before another statement can execute. - when processing query: select * from _____
User #2 has to wait for the earlier connection to timeout. which is about 20 minutes.
Cognos does offer the ability to send various XML commands when a session is closed. I am trying to find out , if closing a browser session, might trigger one of these events.