Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Answer: Can process share a DBI connection?

by Zaxo (Archbishop)
on Jul 10, 2002 at 07:24 UTC ( #180696=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > Can process share a DBI connection? - Answer contributed by Zaxo

Each process should open its own DBI connection. Processes will readily share one if it's opened before fork, but that has bad side effects, and no good ones that I know of. Two processes talking over one connection may get a db server confused, and the first process to end will take the serverside connection down, with no notification to the surviving process. Further confusion may result when the survivor tries to close its copy.

Moral - Don't call &DBI::connect before a fork, even if one process never uses the connection.

  • Comment on Answer: Can process share a DBI connection?
Log In?

What's my password?
Create A New User
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (9)
As of 2016-10-26 09:22 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (338 votes). Check out past polls.