Dear Mary,
In MySQL your table must be of type INNOB for transactions to be
supported.
Thanks a lot !
I have change the database type and now the program works properly.
Thanks to all.
Artem.
On 8/22/06, Kevin Carothers <[EMAIL PROTECTED]> wrote:
On 8/22/06, Artem Harutyunyan <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> >
> > BEGIN TRANSACTION
> > write a sales slip
> > write a journal record
> >
> write a check record
>
> > COMMIT
> > END TRANSACTION
> >
>
> But what h
Artem Harutyunyan wrote:
> Hi,
>
> Are you using a table type in mysql that supports transactions?
>>
> Well, I am not sure, how can I check it ?
mysql> show table status like '%transaction%';
The second column (engine) is what you're interested in... needs to be
InnoDB to support transactions.
>Artem Harutyunyan wrote:
Hi,
>
> Consider, please, the following piece of code:
>
___
__
> my $dbh = DBI->connect($dsn, $user, $pass, {RaiseError =>
> 1,PrintError =>1});
>
> $dbh->{'AutoCommit'} = 0
Hi,
Are you using a table type in mysql that supports transactions?
Well, I am not sure, how can I check it ?
Artem.
Artem Harutyunyan wrote:
> Hi,
>
> Consider, please, the following piece of code:
[snip]
>
> It connects to the database, turns AutoCommit off, prepares the
> statement, executes it, waits for 60 seconds and commits the
> statement.
> Although I do not get any errors, it does not work as I expe
On 8/22/06, Artem Harutyunyan <[EMAIL PROTECTED]> wrote:
Hi,
Consider, please, the following piece of code:
{code fragment}
It connects to the database, turns AutoCommit
