Brian, I'm not sure about 3.23.x, but on 4.0.x and higher you can start the database with --default-table-type=InnoDB to do what you need.
HTH, Rod -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian McSweeney Sent: Saturday, April 05, 2003 4:09 AM To: [EMAIL PROTECTED] Subject: [JBoss-user] MySql, Transactions and deployment Hi all, I'm using mysql version 3.23.52 I've read that for transactions to be supported you have to use the mysql process mysqld-max and have to have it set up to support transactions by enabling tables of type InnoDB or BDB as opposed to the default of type ISAM. My question is, I want to be able to create tables by dropping an ear into JBoss using CMP, however I think the default CREATE TABLE creates tables as type ISAM, which does not support transaction. Is there a way to include the clause "type=InnoDB" using hot deploy in JBoss to enable transaction support? thanks, Brian ------------------------------------------------------- This SF.net email is sponsored by: ValueWeb: Dedicated Hosting for just $79/mo with 500 GB of bandwidth! No other company gives more support or power for your dedicated server http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user