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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-4089.
---------------------------------


> 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: Bug
>          Components: JDBC Driver
>    Affects Versions: 8.11.2
>         Environment: Windows 7 Pro 64bit
> Java 8u66 64bit
>            Reporter: Jesse Shaffer
>            Assignee: Steven Hawkins
>             Fix For: 9.0, 8.12.5, 8.13.3
>
>
> 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
(v7.5.0#75005)