Thomas,

It is potentially a long-running query since I have it just sitting there
doing whatever the schema cache needs as well as to be able to prepare
queries without having to cycle through transactions. It's just an
efficiency thing that I could allow him to turn off because of how he has
his triggers setup. I'm still thinking through how I can have him do that.
Alternatively, it might be a good thing to have him wrap that INSERT in a
WHEN clause, catch the error and then make it go silent. Thus, he would not
be logging read-only transactions, but that may be sufficient for his needs
too.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Monday, July 25, 2016 11:51 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Re: Database trigger and connect to database

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.
>
>
>
>

------------------------------------

------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgrade
------------------------------------

Yahoo Groups Links