db connection trouble
- From: ekrivdyuk@xxxxxxxxx (Eugene Krivdyuk)
- Date: Wed, 5 Dec 2007 10:16:04 +0200
Hello DBI folks.
I have a problem with DBD::Oracle connection, description follows:
Perl script creates connection to an Oracle server and works with db
like db proxy (daemon). Sometimes script reconnects. Everything is
fine, but if script do nothing about 2 hours it stucks.
---------------------------------------------------------------------
parts of script:
use strict;
use DBI;
use DBD::Oracle;
use Socket;
....
sub db_connect{
$DBH = DBI->connect('dbi:Oracle:'.$DBSID, $DBUSER,
$DBPASS,{AutoCommit=>1,RaiseError=>0})
}
.....
sub db_reconnect{
undef $DBH;
if(&db_connect()){
return 1;
}
else{
return 0;
}
}
---------------------------------------------------------------------
Trace of normal reconnect and unnormal reconnects are in attachments.
Thanks in advance.
--
WBR, Eugene Krivdyuk
Attachment:
normal_reconnect.log
Description: Binary data
Attachment:
unnormal_reconnect.log
Description: Binary data
- Prev by Date: Re: Cursors (foiled again)
- Next by Date: Re: Fun with UTF-8 and Oracle [PATCH]
- Previous by thread: Pedant at the London Perl Workshop
- Next by thread: Re: Fun with UTF-8 and Oracle [PATCH]
- Index(es):
Relevant Pages
|
|
