RE: [JBoss-user] MySql, Transactions and deployment
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
Re: [JBoss-user] MySql, Transactions and deployment
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 -- costinmailto:[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