Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"Statement already has a cursor assigned" error when trying to execute another SQL statement using different cursor name [CORE4286] #4609

Closed
firebird-issue-importer opened this issue Dec 3, 2013 · 6 comments

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented Dec 3, 2013

Submitted by: Paulius Pazera (ppazera)

our application uses IBObjects, and it did not work with fb3. It was giving "Statement already has a cursor
<cursorName> assigned". We are using the same TIB_Cursor object to execute different SQL statements. First statement is executed ok,
second gives the error (showing cursor name from first execution). I checked IBObjects code and found that during unprepare they
clear cursor name, and during prepare, if cursor name is empty then it generates random value. After I modified IBObjects unprepare
code not to clear previous cursor name (as a work around) then it started to work with fb3

Commits: 411c371 FirebirdSQL/fbt-repository@08d0cd2

====== Test Details ======

Could not reproduce with python driver.

BTW, there is _no_ method 'clear_cache()' for Cursor object, despite on document reference that can be found here:

http://www.firebirdsql.org/file/documentation/drivers_documentation/python/fdb/reference.html#cursor

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 3, 2013

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 10, 2013

Commented by: @AlexPeshkoff

Paulius, I want to know what client version did you use.
Ideally I also need an exact sequence of API calls cause I can't experiment with Delphi IBO.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 17, 2014

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 17, 2014

Modified by: @AlexPeshkoff

Version: 3.0 Alpha 2 [ 10560 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 22, 2015

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 26, 2015

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Cannot be tested

Test Details: Could not reproduce with python driver.

BTW, there is _no_ method 'clear_cache()' for Cursor object, despite on document reference that can be found here:

http://www.firebirdsql.org/file/documentation/drivers_documentation/python/fdb/reference.html#cursor

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants