Re: conn.setAutoCommit(false) can't work

[Paul DuBois]

At 21:18 -0400 4/17/02, bin cai wrote:
>Hi,
>currently i got a problem which i am afraid to ask
>your help.
>
>I am using javaservlet and mysql 3.23.49 with innoDB
>table type . the code conn.setAutoCommit(false)
>doesn't work giving me error message("can't disable
>auto_commit");
>I am stuck here. anyone can give me some hint i will
>really appreciated
>bin

Check to make sure your table type is *really* InnoDB.
MySQL doesn't necessarily have the transactional table handlers
enabled (for example, if it's not a MySQL-Max binary distribution,
or if you compiled it from source but didn't specify --with-innodb).
In such cases, you can specify TYPE=InnoDB in the CREATE TABLE
statement, but MySQL will silently create the table as MyISAM.

Use SHOW CREATE TABLE tbl_name to see what its type is.


---------------------------------------------------------------------
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