Re: Proposed change to disconnect in DBD::ODBC

"Greg Sabino Mullane" <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general,gmane.comp.lang.perl.modules.dbi.sybase.devel,gmane.comp.lang.perl.modules.dbi.sybase.devel
Message-ID <[email protected]>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> but in the second case DBD::ODBC will rollback the transaction before 
> disconnecting and there is no error or warning.
> I don't really like this behaviour and would like to change it so in the second 
> case above, DBD::ODBC issues a warning before rolling the txn back so you'd get 
> something like:
>
> DBD::ODBC::db disconnect warning: Disconnect with transaction in progress - rolling back

I don't know - it seems that someone issuing an explicit $dbh->disconnect() is far 
different from a script just randomly exiting for one reason or another. I'd 
also like to keep DBI consistent as much as possible, and I don't know of any 
other DBDs that issue a warning on disconnect. So a -1 on this proposal, or at 
least maybe a very weak +1 to putting such a thing inside DBI rather than 
DBD::ODBC if others agree on this new behavior.

- -- 
Greg Sabino Mullane [email protected]
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201103161205
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk2A4C8ACgkQvJuQZxSWSshIhACg2mIiZs8MX1WePcoSMDIXzPzm
tuYAnRYqOUODvDqmFdTlNdew3zMkXiq2
=zpIb
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.