List:MySQL and Java« Previous MessageNext Message »
From:Jayce^ Date:January 23 2003 5:44pm
Subject:Re: Transaction Support in mysql13.23.54
View as plain text  
-----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-----

Thread
Transaction Support in mysql13.23.54Nirmal Shah23 Jan
  • Re: Transaction Support in mysql13.23.54Pål Arne Hoff23 Jan
  • Re: Transaction Support in mysql13.23.54Robert Tam23 Jan
    • Re: Transaction Support in mysql13.23.54Mark Matthews23 Jan
  • Re: Transaction Support in mysql13.23.54Jayce^23 Jan
  • Re: Transaction Support in mysql13.23.54Leila Lappin23 Jan