Re: Transaction Support in mysql13.23.54

[Pål Arne Hoff]

> 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.
> I am connecting to the mysql database thru my java
> web-app.
> thank you in advance.
> regards,
> nirmal
> (23 jan 03)
> 

Go to this page: http://www.innodb.com/howtouse.html and have a look 
under: How to create tables in the InnoDB format.

Basically you will at least have to specify this line in 
C:\WINDOWS\my.ini and restart your mysql-max server:

innodb_data_file_path=ibdata1:30M

All the best,
Pål Arne Hoff