Cool, thx, Dave On Tue, Jan 14, 2003 at 12:16:27PM -0800, [EMAIL PROTECTED] wrote: > Try killing the processes for an Oracle test database. > > The goal is to fool the listener into thinking the database is > still up, and creating a server, which should then hang. > > It's worked for me in the past, but not always 100%. May > take a few tries. > > Jared > > > > > > > David Turner <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 01/14/2003 10:46 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject: Re: perl timeout > > > Thx I left your book in Missouri:( Now I'm trying to simulate a database > with > hanging connections to test the script. Anyone know how best to simulate > that? > > Dave > On Mon, Jan 13, 2003 at 07:43:29PM -0800, Jared Still wrote: > > > > Gee Dave, I know of a book that has scripts that > > already do this. ;) > > > > Here's an untested bit of code to demonstrate. > > > > my $dbh; > > > > eval { > > > > local $SIG{ALRM} = sub { > > die "connection timeout\n"; > > }; > > > > alarm 60; > > > > $dbh = DBI->connect( > > 'dbi:Oracle:' . $db, > > $username, $password, > > { > > RaiseError => 1, > > AutoCommit => 0, > > } > > > > ); > > > > }; > > > > # the alarm reset must be outside the eval{} > > alarm 0; > > > > I say untested cuz I simplified it a bit after lifting > > it from a script. > > > > HTH, > > > > Jared > > > > On Monday 13 January 2003 15:49, David Turner wrote: > > > Does anyone have some perl code that will return an error if it take > longer > > > than a certain number of seconds to connect to or return the results > from a > > > database? I'd like to have some of my queries connect to an alternate > > > database if there is a problem connecting or returning results within > 10 > > > seconds. Any other suggestions are appreciated. > > > > > > Dave > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: David Turner > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Turner INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).