Front page | perl.dbi.users |
Postings from July 2006
----- Forwarded message from Gene Zhang <genzhang@cisco.com> ----- Date: Wed, 19 Jul 2006 14:47:53 -0700 From: Gene Zhang <genzhang@cisco.com> To: tim.bunce@pobox.com Subject: dbh handle in forked processes DKIM-Signature: a=rsa-sha1; q=dns; l=618; t=1153345674; x=1154209674; c=relaxed/simple; s=sjdkim7002; h=Content-Type:From:Subject:Content-Transfer-Encoding:MIME-Version; d=cisco.com; i=genzhang@cisco.com; z=From:Gene=20Zhang=20<genzhang@cisco.com> |Subject:dbh=20handle=20in=20forked=20processes; X=v=3Dcisco.com=3B=20h=3DsD7xL/pn9TnBNQkdD6zrgC2K+Go=3D; b=CU2g8mhzDcuD8ZtwRrKWRFLn3lqy8vcCE+x7mbeK2yFOKJJi520TdFyxw9/xo8zDN9IYDhyD b19OICV/RztAqyyEZlJcK2ggl8ph4rHv/p7O/mSPfQ4YPR/ZnNV3+jeD; Authentication-Results: sj-dkim-7.cisco.com; header.From=genzhang@cisco.com; dkim=pass ( sig from cisco.com verified; ); Hi mr. bunce, I've an issue with programming DBI and could not find a solution in either your DBI slideshow: http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/index.htm or your book <Programming the Perl DBI>; was hoping you could provide some guidance: I have a program that establishes a $dbh, but then forks multiple child processes, all of which use the same $dbh for queries and then terminate (the process). I'd like to use the same $dbh connection handle for each child process but as soon as one child exits, the handle is lost. Is the best solution to use connect_cached? -gene ----- End forwarded message -----Thread Next