1 message in com.mysql.lists.javaMySQL transaction problem (Again...)
FromSent OnAttachments
Carfield Yim29 Dec 2000 08:34 
Subject:MySQL transaction problem (Again...)
From:Carfield Yim (carf@desktop.carfield.com.hk)
Date:12/29/2000 08:34:44 AM
List:com.mysql.lists.java

Hi all, I have bulid MySQL from source. From the output of ./configure, I know that MySQL know where is BDB. After table bulid complete, I create the table for testing using following SQL:

create table test (id integer) type = BDB; set autocommit=0; begin; insert into test values (1); rollback;

But table test don't rollback as expected (don't create row with values 1), where do I get wrong? Besides, the table will access with JDBC, if I use JDBC driver mm.mysql.jdbc-1.2c.tar.gz, do I just need to use setAutoCommit(false) is ok?