Re: Given a dbh, is it possible to find out if there are uncommited transactions?

2003-02-15 Thread Tim Bunce
On Fri, Feb 14, 2003 at 06:10:11PM +0100, Roger Perttu wrote: > > I assume the functionality I'm looking for doesn't exist. You're right. The DBI can't effectively keep track of whether a driver's session with it's database server is in a transaction of not. And many database API's don't provide

Re: Given a dbh, is it possible to find out if there are uncommited transactions?

2003-02-14 Thread Michael Peppler
With Sybase (and, probably, MSSQL) you can query the @@trancount Transact SQL global variable. This will be 0 if there are no active transactions. Michael On Fri, 2003-02-14 at 08:44, [EMAIL PROTECTED] wrote: > In DBD::Informix, there is an attribute for $dbh for ix_InTransaction which does >thi

Re: Given a dbh, is it possible to find out if there are uncommited transactions?

2003-02-14 Thread Roger Perttu
Roger Perttu wrote: Hi! When I destroy my objects I would like to know if there are uncommitted transactions. There shouldn't be any but I would like to know. Given only a DBI database handle, is it possible to find out if there are uncommitted transactions? If not, is there anything inside

Re: Given a dbh, is it possible to find out if there are uncommited transactions?

2003-02-14 Thread jleffler
In DBD::Informix, there is an attribute for $dbh for ix_InTransaction which does this for you. It is not standardized. ---Original Message--- From: Roger Perttu <[EMAIL PROTECTED]> When I destroy my objects I would like to know if there are uncommitted transactions. There shouldn't be

Given a dbh, is it possible to find out if there are uncommited transactions?

2003-02-13 Thread Roger Perttu
Hi! When I destroy my objects I would like to know if there are uncommitted transactions. There shouldn't be any but I would like to know. Given only a DBI database handle, is it possible to find out if there are uncommitted transactions? If not, is there anything inside DBD-ODBC that I could