At 21:18 -0400 4/17/02, bin cai wrote:
>currently i got a problem which i am afraid to ask
>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
>I am stuck here. anyone can give me some hint i will
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.