Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

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 browsing the Monastery: (9)
As of 2016-10-28 23:06 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (387 votes). Check out past polls.