Re: Passing a DBI handler the proper way

It sounds like your database handle $conn is going out of scope before you properly close it. You are explicitly disconnecting $conn when you're finished with it right?

Even if you are disconnecting, you will still get a warning about an outstanding, uncommitted transaction, if you haven't performed a commit before you disconnect. You may want to specify auto-commit when you open the database connection (or at least be aware of its setting):

$conn = DBI->connect('dbi...', $user, $password,
                      { RaiseError => 1, AutoCommit => 1 });
[download]

It is difficult to say anything more without more information to go on.

Updated: Changed AutoCommit value from 0 to 1

Comment on Re: Passing a DBI handler the proper way Download Code

Replies are listed 'Best First'.
Re^2: Passing a DBI handler the proper way by kwaping (Priest) on Jun 14, 2006 at 15:01 UTC
I think you meant `AutoCommit => 1`. :) --- It's all fine and dandy until someone has to look at the code.	[reply] [d/l]
Re^3: Passing a DBI handler the proper way by albert (Monk) on Jun 14, 2006 at 15:10 UTC
If you don't want to AutoCommmit, then you could do `$conn->commit` instead. -a	[reply] [d/l]