Re: Proposed change to disconnect in DBD::ODBC
"H.Merijn Brand" <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase.devel |
|---|---|
| Message-ID | <[email protected]> |
On Wed, 16 Mar 2011 16:49:41 +0000, "Martin J. Evans" <[email protected]> wrote: > This area is already inconsistent. From DBI under disconnect: > > "The transaction behaviour of the disconnect method is, sadly, > undefined. Some database systems (such as Oracle and Ingres) will > automatically commit any outstanding changes, but others (such as > Informix) will rollback any outstanding changes." This is something I should mention in my DBD talk about database inconsistencies. Thanks for reminding me. FWIW I agree with Greg that COMMIT on disconnect is insane -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using 5.00307 through 5.12 and porting perl5.13.x on HP-UX 10.20, 11.00, 11.11, 11.23 and 11.31, OpenSuSE 10.1, 11.0 .. 11.3 and AIX 5.2 and 5.3. http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/ http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/