You can reproduce it the way I described above...

Quote: "You can add the record from SQL+ or with the button 'Add Record' that adds a record to the testtable. Then press the execute button, which inserts the same record in the same table with another session from a thread."

So first press the button 'Add Record' and then press the other button. Make sure the table is empty.

This does not immediately cause a problem. If I try to close the application I get an ORA-00001 error because the session is logged off and the transaction is committed.

My mistake. The timer is not enabled, when running the thread. Adjusted test-project:

Test Project

Just tried it with the newest evaluation version (4.0.4) and pressing the second button makes the application hang. Using our version (3.4.4) the application exits without an exception.

Can you please look at it?

Thanks.

Can you please look at it?
Our database server is 'randomly' crashing, which isn't very convenient for connected clients...

I will check it out tomorrow.

I ran the demo, and it does indeed hang. This is because your timer event attempts to disconnect the session that is currently executing in the background thread. Like I said, this will lead to unpredictable results if ThreadSafe = False, and to a hangup if ThreadSafe = True. The LogOff must wait until the thread is finished executing the query.

Putting the timer in the thread makes no difference... But maybe it's not really 'in' the thread. Aside from this: how can I check whether a session (a query or whatever) is still busy?

The timer event will always occur in the main thread, it does not matter where you create it.

To see if a session is busy, you would need to create your own administration. You could also simply check if your thread is suspended. Only then is it safe to access the session from the main thread.

Hi Marco,

this was the reason why i asked for such a property some time ago
Any chance to get it someone ?

Greetings
Jens

I realized that when I wrote my previous reply . It's still on the to-do list.