Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much

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
[Discipulus]: good night monks!
[shmem]: LanX: oh... now I have to figure out if this is good or bad news.
LanX bad day monks ?
[LanX]: hope you find sleep
[shmem]: LanX: which one?
[LanX]: the last
Discipulus yes a very bad day
[shmem]: grandola, vila morena
[shmem]: LanX: ah, that one. You'll get the bug reports also :P
[Discipulus]: upvote me! i'll make pm great again! ;=)

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (5)
As of 2017-04-29 22:47 GMT
Find Nodes?
    Voting Booth?
    I'm a fool:

    Results (534 votes). Check out past polls.