Front page | perl.dbi.users |
Postings from November 2011
On Nov 5, 2011, at 3:57 PM, Brandon Phelps wrote: > Can anyone point me in the right direction for keeping a connection to my database opened? > > The script I need to write will run 24/7 executing a postgresql stored procedure which inserts records into the database. The problem I think I might have is using a standard procedural syntax of: > > Open connection > Loop > Call stored procedure/function > > ...if my connection gets interrupted somewhere during the loop any subsequent iterations will obviously fail, so I need a way of reconnecting to the database should the need arise. Basically something like this (I'm just not sure how to actually code this): Why not just open a database connection, run the procedure and close it again? : Loop open db run proc close db End loop ? If the connection is staying open long enough to get stale and be disconnected, then you shouldn't be running into timing issues. -- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customsThread Previous | Thread Next