How to configure MySQL for CMP Transaction

[gmorette]

Hello,

Can someone tell me how to configure MySQL 4 to do CMP transaction ?

I guess i have to use innoDB table and to set autocommit=0 ?

Can someone tell me the steps to configure correctly MySQL ?

[redbeard15]

The "Getting Started with JBoss" guide (Chapter 8) talks about how to use MySQL with JBoss (3.2.x, anyway). I'm using MySQL 4.0 and JBoss 3.2.6 with great success.

[rafcio]

"redBeard15" wrote:
The "Getting Started with JBoss" guide (Chapter 8) talks about how to use MySQL with JBoss (3.2.x, anyway). I'm using MySQL
4.0 and JBoss 3.2.6 with great success.

Is there a possibility to control autocimmit, cause:

"In MySQL 4.0, the query cache works only with autocommit enabled. This restriction is removed in MySQL 4.1.1 and up."