Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I interrupt the blocking call when API call timeout?
Ricky wrote:
> Hi,Guys
>
> I wrote an application server(daemon process) to talk with oracle
server
> continuous which used oracle9 OCCI lib, each 5 min it executes the
procedure
> on the DB server.
>
> Now I have come cross a problem:
>
> If the network is blocked, app server will blocked at occi call and
would
> never pass, and no exception was catched :-(
>
>
> for e.g.
> 1. Oracle server reboot without shutdown oracle process
> 2. udp broadcast message storm blocked the connection between app
server and
> oracle DB.
>
> I consider maybe it's because OCCI using the blocking mode of
connection
> that caused this problem.
>
> How can I interrupt the blocking call when call timeout?
Have you tried using non blocking option?
Regards
/Rauf
Received on Mon Feb 07 2005 - 18:35:37 CST