UniDac Firebird database error on app close

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
stevel
Posts: 125
Joined: Tue 02 Nov 2010 19:01

UniDac Firebird database error on app close

Post by stevel » Sat 24 Jun 2017 17:35

Running on:
UniDAC: 7.0.2
Delphi: 10.2 Tokyo, Win32 VCL app
Database: Firebird 3.0.2 server accessed via TCP/IP connection (fbclient.dll)

When closing my app (running in Debug mode in the IDE), I get the following error:
---------------------------
Debugger Exception Notification
---------------------------
Project xxxxxxxxx.exe raised exception class EIBCError with message 'cannot disconnect database with open transactions (1 active)'.
---------------------------
Break Continue Help
---------------------------
followed by this dialog box:
---------------------------
Error
---------------------------
Runtime error 217 at 007CA25C
---------------------------
OK
---------------------------
If there is anything that can be done (in code) to avoid this error please write here.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: UniDac Firebird database error on app close

Post by ViktorV » Mon 26 Jun 2017 15:51

Unfortunately, we could not reproduce the problem.
In order to get a detailed answer, please compose a small sample demonstrating the issue and send it to us using the contact form https://www.devart.com/company/contactform.html including scripts for creating and filling database objects.

FredS
Posts: 272
Joined: Mon 10 Nov 2014 17:52

Re: UniDac Firebird database error on app close

Post by FredS » Mon 26 Jun 2017 23:38

stevel wrote: Debugger Exception Notification
---------------------------
Project xxxxxxxxx.exe raised exception class EIBCError with message 'cannot disconnect database with open transactions (1 active)'.
---------------------------
Break Continue Help
If there is anything that can be done (in code) to avoid this error please write here.
Check the TUniConnection.DefaultTransaction.DefaultCloseAction, its default is taRollback.
Also TUniConnection.Autocommit, default for FB is True.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: UniDac Firebird database error on app close

Post by ViktorV » Fri 30 Jun 2017 13:59

Thank you for the information. We have reproduced the issue and investigation is in progress. We will inform you when we have any results.

Post Reply