Random exception SQL error code = -502 - Invalid cursor declaration using fb
embedded from a service - bad cursor GUID
----------------------------------------------------------------------------------------------------------------------
Key: CORE-4559
URL: http://tracker.firebirdsql.org/browse/CORE-4559
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.3
Environment: Windows, FB Embedded, used from a service
Reporter: Francesco Pucino
Using the enbedded engine inside a Windows service written in Delphi XE5 and
using IBTable, IBQuery, IBDataBase and IBTransaction components, some time,
randomly its raised this error:
Dynamic SQL Error
SQL error code = -502
Invalid cursor declaration
Statement already has a cursor XXXXXXX assigned.
The same identical code running from a standard Windows application and not
from a service, works correctly (at least until now), so I suppose that the
problem comes using the dbms from a service.
What I suppose is also a bug is that the cursor name XXXXXXX reported in the
exception is followed by some random strange characters. Here some examples:
Statement already has a cursor {8E1EFE75-E593-4272-955F-722ACF638970}ŸŸŸŸŸŸ EB°
assigned"
Statement already has a cursor {907E1505-AE34-4722-800A-6984B4EDD550}E="XPOG¬°
assigned"
Statement already has a cursor {71857BF2-C993-4759-8B85-A91209F54C56}IJIIIH@›°
assigned"
Statement already has a cursor {5B310F1A-4455-4170-9181-57D489FD61A4}»ÐÛ¬€¨?°
assigned"
I think that it should be a standard GUID without other appened chars.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
