Jason,

> Michael,
>
>
>
> This is likely the transaction from the Connection’s Schema Cache being
> used to prepare a query.
>
> This poses a bit of a challenge because there are definite benefits to
> having a readonly transaction.

Is this a long-running transaction?

If not, personally I probably wouldn't care about that too much as a
result of being able to run data manipulation operations in an ON
CONNECT trigger.

Just a thought.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

>
> It has a much lighter impact on garbage collection and transaction
> efficiency.
>
> I’ll probably need to make a setting for you to control this.
>
> Please contact me privately and we can work out your needs.
>
>
>
> Thanks,
>
> Jason Wharton
>
>
>
>
>
> ------------------------------------------------------------------------
>
> *From:*IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
> *Sent:* Wednesday, July 20, 2016 6:21 AM
> *To:* IBObjects@yahoogroups.com
> *Subject:* [IBO] Re: Database trigger and connect to database
>
>
>
>
>
> I use the TIBODatabase.
> Here I have an DefaultTransaction. Called trDatabase1. This cannot be
> changed. It tells me, I cannot change default internal transation.
> But I can set READONLY. Which is FALSE.
> I can set isolation. Which is isCommitted.
>
>
>
>