Re: [Dbi-interbase-devel] 901 / expecting explicit transaction start

[Daniel R. <dan...@gm...>]

hello marco

i can't reproduce the error. i made a test database and a test script doing the same
thing as described. it works without any problem. it uses two database connections
and copies the content form one table to another. i tested it with two connections
to the same database and with connections to two different databases.

you can find the test database and the test script at:
http://ritz.dnsart.com/interbase/

(i tested it with interbase 6.0 / perl 5.6 / dbd-interbase 0.28
 on windows 2000 and on linux 2.2.19)

may be the script is an answer to you. if not, send me the part of your script that fails
and i try to find the error.


regards
-daniel

dbd-interbase porter


----- Original Message -----
From: "Marco Schlünß" <pri...@sc...>
To: <dbi...@li...>
Sent: Monday, July 16, 2001 12:12 PM
Subject: [Dbi-interbase-devel] 901 / expecting explicit transaction start


> Hi,
>
> i just upgraded my DBD::InterBase-driver from version 0.21 to 0.28 and i get this error:
>
> DBD::InterBase::st execute failed: Unsuccessful execution caused by system error that d
> oes not preclude successful execution of subsequent statements
> -Dynamic SQL Error
> -SQL error code = -901
> -invalid transaction handle (expecting explicit transaction start)
>
> the script, that produces this error, uses 2 db-handles, one for reading data and one for
> updating the database.
> AutoCommit is turned on for the reading one, and turned of for the writing one.
> SQL-statements are prepared upon script-start.
>
> but how do i explicit start a transaction? due to dbd does not support transaction, i
> think, i have to use a sideeffect of the existing methods? should i use a commit just
> before starting to bind and execute?
>
> --
> Marco Schluenss            pro...@sc...
> Spinnerstr. 35             Tel D-0531/576450
> 38114 Braunschweig
>
> _______________________________________________
> Dbi-interbase-devel mailing list
> Dbi...@li...
> http://lists.sourceforge.net/lists/listinfo/dbi-interbase-devel
>