develooper Front page | perl.dbi.users | Postings from November 2011

Re: Design Pattern to keep a connection opened?

Thread Previous
From:
John R Pierce
Date:
November 5, 2011 16:01
Subject:
Re: Design Pattern to keep a connection opened?
Message ID:
4EB5C039.2070202@hogranch.com
On 11/05/11 3:57 PM, Brandon Phelps wrote:
> The main question is, how can I efficiently determine if a db object 
> is usable? 

put the actual execute SQL command calls in a procedure which checks for 
an error code, and if the error is of the connection variety, reopens 
the connection and retries the query a reasonable number of times.



-- 
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


Thread Previous


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About