Transactions?

[Mark Ingram]

> BTW, SendSQL is deprecated.

Oooh right, whats the format for executing database calls now then? Does
this mean MoreSQLData() and FetchSQLData() are depreciated too?

Best Regards,

Mark Ingram
Software Engineer
Nexsan Technologies
33 - 35 Parker Centre
Mansfield Road
Derby
DE21 4SZ



-----Original Message-----
From: developers-owner at bugzilla.org
[mailto:developers-owner at bugzilla.org]On Behalf Of J. Paul Reed
Sent: 29 July 2003 01:51
To: developers at bugzilla.org
Subject: Re: Transactions?


On 28 Jul 2003 at 09:57:47, Mark Ingram arranged the bits on my disk to say:

> is it possible todo transactions with the bugzilla code?
>
> i want to add data into 2 tables and obviously dont want to put it into
> the 1st table and then have it fail on the second table.
>
> im currently using SendSQL to execute database commands.

Is it possible to do transactions with Bugzilla *code*? Sure.

Is it possible to do transactions with the *database* Bugzilla uses? No.

The solution is to use another database; there are bugs for supporting
PostgreSQL (bug 98304) and Sybase (bug 173130) but both of them are in
different stages of bitrot and completion, and thus are of varying degrees
of use.

You *might* be able to get away with using MySQL 4.x, which has
commit/rollback (MySQL developers think this means they have
"transactions"), and see if you can it working that way.

There's not a real easy solution to your problem, unfortunately.

BTW, SendSQL is deprecated.

Later,
Paul
------------------------------------------------------------------------
J. Paul Reed -- 0xDF8708F8 || preed at sigkill.com || web.sigkill.com/preed
To hold on to sanity too tight is insane.   -- Nick Falzone, Pushing Tin

I use PGP; you should use PGP too... if only to piss off John Ashcroft
-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=mark.ingram@nexsan.com>