[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-dev
Subject:    Re: DBD::Sybase Panic:
From:       Michael Peppler <mpeppler () peppler ! org>
Date:       1999-09-30 20:11:31
[Download RAW message or body]

    *** From dbi-users -- To unsubscribe, see the end of this message. ***

Slav Brkic writes:
 >     *** From dbi-users -- To unsubscribe, see the end of this message. ***
 > 
 > I first connected to Sybase with AutoCommit on, then I
 > created 2 tables and turned off AutoCommit ($dbh->{AutoCommit} = 0).
 > Next, I prepared 2 insert cursors with placeholders (for
 > insertion to those 2 tables using transactions). Then my program crashed.
 > This is from trace log:

Please read the DBD::Sybase manual. This issue is documented.

Because I have to open a second connection to allow you to have 2
active prepared statements I can't guarantee rollback operations
correctly (and you could very easily deadlock yourself this way too).

So AutoCommit off is not supported if you try to open more than one
$sth on a $dbh with DBD::Sybase.

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com

------------------------------------------------------------------------------
To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web page,
please send mail to dbi-users-request@isc.org with the subject line of
'unsubscribe'.
------------------------------------------------------------------------------

[prev in list] [next in list] [prev in thread] [next in thread]