How can I interrupt the blocking call when API call timeout?

Rauf Sarwar · *nix forums Guru Joined: 03 May 2005 Posts: 353

Ricky wrote:

Ricky · *nix forums beginner Joined: 17 Mar 2005 Posts: 7

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?

Google