Hi! I am using the same combination (in fact I use MysqlMax 4.0.1x) which have InnoDB by default.
However, I have support for transaction but without any InnoDB option. I can query CMR relations and all that which require transaction. I don`t know how this good this is (I am open for solutions however). So, try to just install mysql-max or whatever and start doing your thing and see how well the database behaves.... BM> Hi all, BM> I'm using mysql version 3.23.52 BM> I've read that for transactions to be supported you have to use the BM> mysql process mysqld-max and have to have it set up to support BM> transactions by enabling tables of type InnoDB or BDB as opposed BM> to the default of type ISAM. BM> My question is, I want to be able to create tables by dropping an BM> ear into JBoss using CMP, however I think the default CREATE TABLE creates BM> tables as type ISAM, which does not support transaction. BM> Is there a way to include the clause "type=InnoDB" using hot deploy BM> in JBoss to enable transaction support? BM> thanks, BM> Brian -- costin mailto:[EMAIL PROTECTED] ------------------------------------------------------- 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
