Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re^2: fetchrow_array loop in perl 5.10

by bulrush (Scribe)
on Sep 18, 2014 at 19:33 UTC ( #1101106=note: print w/replies, xml ) Need Help??

in reply to Re: fetchrow_array loop in perl 5.10
in thread fetchrow_array loop in perl 5.10

Depending on (the version of) your database driver, it might be that your database driver does not like more than one statement handle being active at the same time.

Yep, that's what happened to me. I had to declare $dbh2 to make my stuff work. $dbh cannot handle both statements. I use DBD::Pg for Postgresql.

Perl 5.8.8 on Redhat Linux RHEL 5.5.56 (64-bit)

Replies are listed 'Best First'.
Re^3: fetchrow_array loop in perl 5.10
by erix (Parson) on Sep 18, 2014 at 19:54 UTC

    See perhaps, DBI, fork, and clone.

    I can't tell if applicable to those problems (yours and that of the OP), but it's interesting anyway :)

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1101106]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (3)
As of 2019-07-17 02:51 GMT
Find Nodes?
    Voting Booth?

    No recent polls found