I had this problem with my new install on windows. In my case in turned out
to be that the tables were not created as innoDB even though I had specified
type=innoDB. I'm not sure why this happened but I fixed the problem by
recreating the tables after I made sure that I have innoDB server running.
I issued
NET STOP MySQL
to shut down the mysql server that was running and started
mysqld-max-nt --console
And then I recreated my tables with type=innoDB option and it worked.
----- Original Message -----
From: "Jayce^" <[EMAIL PROTECTED]>
To: "Nirmal Shah" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 9:44 AM
Subject: Re: Transaction Support in mysql13.23.54
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wednesday 22 January 2003 08:56 pm, Nirmal Shah wrote:
> hi,
> i have installed mysql3.23.54 on windows and have
> followed all instructions as required for using
> mysqld-max to have transaction support.
> i have created a table using TYPE=INNODB, but cannot
> use rollback on it.
> the error i get in my jsp is "transactions not
> supported".
> please advice me on how i can use commit - rollback on
> mysql database tables.
You might check your connection to, I received a similar on a machine
connecting through perl/DBI, and the problem was that the DBI package merely
needed upgrading, mysql had been set up correctly. If your mysql really is
set up right, you could verify this by trying to perform a transaction via
command line. If it works there, it's your connection most likely.
- --
- --Jayce^
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE+MCoIA10/0O8cAHgRAgRWAKC1sZxyOoV+He8dZSe+vHbmTwlyMgCfVqrs
c6+peQEq9/gIBwOxASBfYDk=
=Y/8s
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/doc/ (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
