Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Login/Connection timeout for DBD::Oracle?

by jfroebe (Parson)
on Jan 16, 2009 at 20:30 UTC ( #736930=perlquestion: print w/ replies, xml ) Need Help??
jfroebe has asked for the wisdom of the Perl Monks concerning the following question:

Hopefully, a simple question:

Does anyone know how to specify a login timeout in DBD::Oracle? The man page doesn't show any method for it. I ask because many of our Oracle servers are behind firewalls.. if the firewall is misconfigured or down, the connection attempt will simply hang.

Jason L. Froebe

Blog, Tech Blog

Comment on Login/Connection timeout for DBD::Oracle?
Replies are listed 'Best First'.
Re: Login/Connection timeout for DBD::Oracle?
by kennethk (Abbot) on Jan 16, 2009 at 20:36 UTC
    They discuss this issue, specifically for Oracle, in the DBI documentation. They suggest using signal handling - here's the discussion.

      Thanks! It'll work but I was hoping to avoid such an ugly thing as it may not be caught by Perl. But if I must...

      Jason L. Froebe

      Blog, Tech Blog

Re: Login/Connection timeout for DBD::Oracle?
by frieduck (Hermit) on Jan 17, 2009 at 18:01 UTC
    Maybe what you want is:


    Time in seconds after which a connection attempt will be timed out. ... This parameter should typically be set to +- 3 seconds. If not set, the client connection will block for the default TCP connect timeout duration.

    from, or the official documentation is here.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://736930]
Approved by Corion
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (11)
As of 2016-05-25 15:47 GMT
Find Nodes?
    Voting Booth?