Re^2: How to safely test if a database handle is capable of transactions?

by larryl (Monk)

on Nov 19, 2008 at 19:40 UTC ( [id://724699]=note: print w/replies, xml )

Need Help??

ikegami: I'm just wondering:

Why do you say:

eval {
  local $dbh->{AutoCommit} = 0;
};
$self->{_can_do_transactions} = $@ ? 0 : 1;
[download]

can be written more reliably as

$self->{_can_do_transactions} = eval {
  local $dbh->{AutoCommit} = 0;
  1
};
[download]

Comment on Re^2: How to safely test if a database handle is capable of transactions? Select or Download Code

Replies are listed 'Best First'.
Re^3: How to safely test if a database handle is capable of transactions? by ikegami (Patriarch) on Nov 19, 2008 at 21:50 UTC
If there's an `eval` without a `local $@;` in the code that handles `$dbh->{AutoCommit} = $previous_value;`, then `$@` will get clobbered. Keep in mind that `$dbh->{AutoCommit}` is a tied variable.	[reply] [d/l] [select]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://724699]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others admiring the Monastery: (3)

As of 2024-04-26 07:08 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found