Remove restriction to only allow calls to getResultSet if the result set was not returned yet

[caxzan]

When I am linking with a third-party software, the third-party software calls the data link of Firebird and executes an SQL statement. At this time, it returns an error statement: Only one result set at a time/statement, May I ask how to avoid this problem, or if it can be directly solved in Firebird's JAR.

[mrotteveel]

Jaybird throws this exception because it already returned the result set, either as the return value of executeQuery or from a previous call to getResultSet for this execution of the statement. It does this because the JDBC API says " This method should be called only once per result.". However, looking at the API documentation, I'm not entirely sure that is the behaviour intended by the JDBC specification. I'll try to find out more.

Is this weaver.conn.RecordSet your own code?

[mrotteveel]

Looking at the JDBC spec, calling getResultSet multiple times or after the result set has been returned by executeQuery is not disallowed, it just recommends that it should not be done, as such no exception should be thrown. Also, I looked at the PostgreSQL and Microsoft SQL Server JDBC driver implementations, and they return the existing result set without a fuss.

I'll make the necessary changes in Jaybird 6.

[mrotteveel]

Decided to backport this to Jaybird 5.0.5 as well, see #809

[caxzan]

ok 

…

------------------ 原始邮件 ------------------ 发件人: "FirebirdSQL/jaybird" ***@***.***>; 发送时间: 2024年6月14日(星期五) 下午3:43 ***@***.***>; ***@***.******@***.***>; 主题: Re: [FirebirdSQL/jaybird] Remove restriction to only allow calls to getResultSet if the result set was not returned yet (Issue #762) Decided to backport this to Jaybird 5.0.5 as well, see #809 — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>