[teiid-issues] [JBoss JIRA] (TEIID-4089) Teiid JDBC driver does not reset the update count when calling getMoreResults(int)

[Jesse Shaffer (JIRA)]

Jesse Shaffer created TEIID-4089:
------------------------------------

             Summary: Teiid JDBC driver does not reset the update count when calling getMoreResults(int)
                 Key: TEIID-4089
                 URL: https://issues.jboss.org/browse/TEIID-4089
             Project: Teiid
          Issue Type: Feature Request
          Components: JDBC Driver
    Affects Versions: 8.11.2
         Environment: Windows 7 Pro 64bit
Java 8u66 64bit
            Reporter: Jesse Shaffer
            Assignee: Steven Hawkins


I have run across a situation with the JDBC driver.  Looking at {{StatementImpl.getMoreResults(int)}}, it does not clear the update counts, whereas {{StatementImpl.getMoreResults()}} does.  Long story short, this is preventing me from integrating the JDBC driver properly into my application, due to the runtime's (3rd party) handling of statements.  It gets stuck in an infinite loop because to close the statement, they call {{StatementImpl.getMoreResults(Statement.CLOSE_CURRENT_RESULT);}}, but then they have a check for a -1 value to be returned from {{getUpdateCount()}} before exiting the loop.  In my case, that value is always 1, and thus the infinite loop.

It seems logical to me that {{getMoreResults(int)}} should behave the same as {{getMoreResults()}} seeing as they both always return false, only the latter is the only one that closes the resultset/clearing the update count.



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