Devart Forums

Hi,

in a multithreaded environment, is there a way to detect, that on any other thread a sql statement is executed for the current session.

For example session.IsInUse

I want to check the application state against the database any time the application is activated. But when in a detail thread something is running, the main thread waits until the detail thread is finished.

Greetings
Jens

There is no way to detect that a statement is executing on a session. If you use one TOraQuery component in your thread, you can check result of the Executing and Fetching methods of TOraQuery.
You also can add a counter variable to your thread, increment this variable before openning a query, and decrement after openning.

My Idea was to add this as a new feature to the session.

The point is to add the following functions

• BeginSessionUsage
  EndSessionUsage
  IsInUse

Begin and End increments /decrements a counter, they should be thread-save.
InUse returns true if the counter is greater 0.

The Begin/EndeSessionUsage must be included before/after the call's to the oci call's of each component.
This should be included inside the component. It's the only way to be shure to have it in every time.

Greetings
Jens

Hi Oleg,

any further comment on this?

Please see it as an feature request.

Greetings
Jens

We'll consider possibility to add this feature.

Any news on this??

There is a lot of work required to implement this feature. Currently we have some more priority tasks. We'll consider possibility to add this feature in one of the future ODAC versions.

I agree and i understand.

That's realy sad for multi threaded environments.

Does future odac version meant release 7

Greetings
Jens

It is possible that we'll add this feature in ODAC 7.