Same for me ...
>Pierre Comtois >Business Acceleration Services, Solutions Consulting >45 O'Connor Street, Suite 500 * Ottawa, Ontario K1P 1A4 >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: [EMAIL PROTECTED] > > -----Original Message----- From: Guy Rouillier [mailto:[EMAIL PROTECTED] Sent: October 7, 2003 9:12 PM To: [EMAIL PROTECTED] Subject: Re: FW: [JBoss-user] Problem integrating MySql with JBOSS Michael Klem wrote: > From MySQL version 4.0, InnoDB is enabled by default. So sql used to > create a db table will default to being an InnoDB table. To explicitly > create a table as InnoDB do this: > CREATE TABLE CUSTOMER (A INT, B CHAR (20), INDEX (A)) TYPE = InnoDB; That has not been my experience. I have MySQL 4 on both Windows 2000 and Linux, and if I don't specify a type, tables end up as MyISAM. -- Guy Rouillier ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user