Re: Checking Connection Status in a Pro*C program

Hi Steven,

I worked on the similar problem. If your daemon executes SQL statement and the remote Oracle server goes down without answer, then your program will wait forever. You can not make frozen thread alive in any way. I tried obreak
call and non-blocking SQL processing without any success. So, the only solution is to start second copy of application after some time-out and terminate previous copy. This can be done programmatically. But I have not any core dumps on NT.

                                        Andrew Protasov

>My server daemon listens for clients' call and insert appropriate
>stuff from the clients into a remote oracle database. The daemon only
>logs in once into the remote database. I will get CORE DUMPED when
>the daemon performs the insert action if the existing connection is
>not valid (ie the remote database is down) . If I know the connection
>status, I can perform other necessary action to safeguard smooth
>operation (to use a secondary remote database). This daemon can not
>down and must perform smoothly.
>
>Please help.....
>
>
>Regards
>
>Steven.
>
Received on Wed Apr 15 1998 - 18:57:31 CDT