Problem with alerter when session disconnect unexpeced

[ah2007]

Hi,

I am working with TOrAlerter with EventType := etAlert and it works fine. But if I stop the database or disconnect the LAN connection the application hangs between the events ORASession.BeforeDisconnect and ORASession.AfterDisconnect.

Without activating the alerter it works well.

I am using
Delphi2006/ODAC 8.1.4

Thanks for your help.

[AlexP]

Hello,

We have checked the behaviour you have described and found no problem, at connection break or server stop, the application doesn't hang but displays a correct error message. Perhaps, your problem is due to a large value of the Timeout parameter set for OraAlerter

[ah2007]

Hello,

Thank you for the quick response! I made some tests with a simple program and figured out that the session option LocalFailover was the problem. For testing purposes I set this flag. I set this value to false and now the components work as I expect.

[ah2007]

Sorry, I was too optimistic. If I do not reconnect and close my application an exception is thrown while destroying the form. Here is the stack output

:0051ce18 TOCICommand.RaiseError + $20
:0051d00c TOCICommand.CheckSession + $68
:0051e2f2 TOCICommand.Prepare + $12
:0052769a TOCICommand.DoExecute + $22
:00527809 TOCICommand.Execute + $F1
:0053b582 TOCIAlerter.SendAlertMessage + $17E
:0053a261 TOCIAlerter.SendEvent + $45
:0053bb1b TOCIAlerterListenThread.Terminate + $67
:0053a8ae TOCIAlerter.Stop + $1E
:00554d0f TDAAlerter.Stop + $17
:00428aba TComponent.DestroyComponents + $4A

I'm thankful for every idea.

[AlexP]

Hello,

Thank you for the information.
We have reproduced the problem.
We will try to fix it in the nearest product version.

[ah2007]

Hello,

can you tell me, when I can expect the fix of this issue? For us this is an urgent problem.

Thanks.

[AlexP]

Helo,

We are still working on this problem.
We will notify you as soon as we have any results.