Re: About prepared statements asnd transactions....

Michael Peppler <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase
Message-ID <[email protected]>
On Tue, 2005-10-11 at 19:01 -0400, Edward J. Sabol wrote:
> Yves Orton wrote:
> > The main issue for me is that currently prepared handles +
> > transasctions are dangerous.

>  DBD::Mysql and
> DBD::Pg (for older versions of PostgreSQL only) emulate the capability of
> having multiple active sth's per dbh by reading all the data from an
> unfinished sth into memory when a second sth is executed. I suggested adding
> similar emulation of this capability to DBD::Sybase to Michael in February
> 2004, but nothing came of it, AFAIK.

It's feasible, but it is potentially problematic if the original $sth
has a lot of pending data. I guess it could be an option.

Michael
-- 
Michael Peppler  -  [email protected]  -  http://www.peppler.org/
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com/
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
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.