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-automations opened this issue Dec 3, 2013 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

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-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

Version: 3.0 Alpha 2 [ 10560 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

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