mORMot Open Source

willo

Member

From: Cape Town, South Africa

Registered: 2014-11-15

Posts: 67

Website

TSQLDBConnection on xxx should be connected

When fiddling around with transaction handling in Firebird 1.5, using ZEOS, we ran in to an issue where the transaction was not committed and we had to force a commit.

Digging around I found:
fDbConnection.MainConnection.StartTransaction;

Which worked pretty well in the unit tests, but testing it in a service produced an exception:
TSQLDBConnection on xxx should be connected

Forcing the connection before calling StartTransaction resolves the issue, but I'm wondering why TSQLDBConnection behaves this way.

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: TSQLDBConnection on xxx should be connected

@willo,

Do you use Zeos7.2 branches_ testing svn3638 ?:
http://svn.code.sf.net/p/zeoslib/code-0 … sting-7.2/
http://zeoslib.sourceforge.net/viewtopi … 345#p46750

Michal

willo

Member

From: Cape Town, South Africa

Registered: 2014-11-15

Posts: 67

Website

Re: TSQLDBConnection on xxx should be connected

Hi Michal,

We're using ZEOSDBO-7.1.4-stable, is 7.2 stable enough to upgrade to?

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: TSQLDBConnection on xxx should be connected

We're using ZEOSDBO-7.1.4-stable, is 7.2 stable enough to upgrade to?

Yes.
Install and write if something changed.
Some time ago there was a big change in transactions for Firebird in ZEOS 7.2.
In addition, the ZEOS 7.2 should be faster and have fewer errors.

Michal

Last edited by miab3 (2015-08-11 10:21:49)