FAQ
I'd like to have multiple ithreads share a single db connection. The
DBD::mysql doc seems to indicate there wouldn't be an issue, but the DBI
doc still indicates that is a no go to use a shared connection.

"However, the internal pointer data within the handles will refer to the
DBI and drivers in the original interpreter. Using those handles in the
new interpreter thread is not safe, so the DBI detects this and croaks
on any method call using handles that don't belong to the current thread
(except for DESTROY).

Because of this (possibly temporary) restriction, newly created threads
must make their own connections to the database. Handles can't be shared
across threads. "

using
perl 5.8.8,
DBI 1.609,
DBD::mysql 4.011
mysql 5.0.45-log

Is this restriction still needed / enforced?

--
Tim Hester
Impeva Labs, Inc.
O: 850-872-7099
C: 850-832-4216

COMPANY CONFIDENTIAL NOTICE
This electronic mail transmission and any accompanying documents contain information belonging to the sender which may be company confidential and legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or action taken in reliance on the message is strictly prohibited. If you have received this message in error, please delete it.
Thank You.

Search Discussions

  • Tim Bunce at Aug 30, 2009 at 9:53 pm
    Yes.

    Tim.
    On Mon, Aug 17, 2009 at 06:03:44PM -0500, Tim Hester wrote:
    I'd like to have multiple ithreads share a single db connection. The
    DBD::mysql doc seems to indicate there wouldn't be an issue, but the DBI
    doc still indicates that is a no go to use a shared connection.

    "However, the internal pointer data within the handles will refer to the
    DBI and drivers in the original interpreter. Using those handles in the
    new interpreter thread is not safe, so the DBI detects this and croaks
    on any method call using handles that don't belong to the current thread
    (except for DESTROY).

    Because of this (possibly temporary) restriction, newly created threads
    must make their own connections to the database. Handles can't be shared
    across threads. "

    using
    perl 5.8.8,
    DBI 1.609,
    DBD::mysql 4.011
    mysql 5.0.45-log

    Is this restriction still needed / enforced?

    --
    Tim Hester
    Impeva Labs, Inc.
    O: 850-872-7099
    C: 850-832-4216

    COMPANY CONFIDENTIAL NOTICE
    This electronic mail transmission and any accompanying documents contain information belonging to the sender which may be company confidential and legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or action taken in reliance on the message is strictly prohibited. If you have received this message in error, please delete it.
    Thank You.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-users @
categoriesperl
postedAug 17, '09 at 11:04p
activeAug 30, '09 at 9:53p
posts2
users2
websitedbi.perl.org

2 users in discussion

Tim Bunce: 1 post Tim Hester: 1 post

People

Translate

site design / logo © 2022 Grokbase