Hallo, u can put the line: default-table-type=innodb in the [mysqld] section of ur mysql configuration file. In this way every CREATE TABLE statement creates an InnoDB table by default.
Gio > -----Messaggio originale----- > Da: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] conto di > [EMAIL PROTECTED] > Inviato: marted́ 23 dicembre 2003 8.42 > A: [EMAIL PROTECTED] > Oggetto: [JBoss-user] Tell Jboss to create INNODB tables (was: > Session/Entity Bean Transaction Rollback) > > > Adrian, > > thanks for the link, this was exactly what I needed. > Sometimes you dont need many words to explain something :-) > > One more question: Where can I tell Jboss to > create tables with TYPE=INNODB ? > > btw: I bought the JBoss dokumentation, but this > mailing list is far more helpfull for Jboss users. > Here comes a big "thank you" to all people here helping out > others ! > > Regards, > > Stefan > > >> http://www.mysql.com/doc/en/InnoDB.html > >> > >> Regards, > >> Adrian > >> > >> On Mon, 2003-12-22 at 15:22, [EMAIL PROTECTED] wrote: > >> > Hi, > >> > > >> > I forgot something, > >> > I am not shure if this is important: Im am using mySQL > >> > as RDBMS. The Datasource is configured as follows: > >> > > >> > > >> > <datasources> > >> > <local-tx-datasource> > >> > <jndi-name>mySQL_partnerMgmt</jndi-name> > >> > > <connection-url>jdbc:mysql://localhost/partnerMgmt</connection-url> > >> > <driver-class>org.gjt.mm.mysql.Driver</driver-class> > >> > <user-name>root</user-name> > >> > <password></password> > >> > </local-tx-datasource> > >> > </datasources> > >> > > >> > > >> > > Hi, > >> > > > >> > > I have a sessionbean (stateless), that provides a > >> > > method to create some entitys. If the creation of one > >> > > Entity fails, I want do rollback all creations, there > >> > > should be one or all entitys in the DB. I tried to > >> > > set transaction type="required" on the method and I > >> > > throw EJB Exceptions if something goes wrong, but after > >> > > the method fails, there are still some entitys left. > >> > > > >> > > Is there a way to tell JBoss to delete all entitys > >> > > created in the method if the creation of one fails ? > >> > > > >> > > The method looks like this (not actual code :-) > >> > > > >> > > createXXX(){ > >> > > entityHome.create(1); > >> > > entityHome.create(2); > >> > > entityHome.create(3); > >> > > return; > >> > > } > >> > > > >> > > If create(3) failes, I dont want to have 1 and 2 in my database. > >> > > > >> > > Thanks a lot in advance, > >> > > > >> > > Stefan > >> > > > >> > > > >> > > ------------------------------------------------------- > >> > > This SF.net email is sponsored by: IBM Linux Tutorials. > >> > > Become an expert in LINUX or just sharpen your skills. Sign up for > >> IBM's > >> > > Free Linux Tutorials. Learn everything from the bash shell to sys > >> admin. > >> > > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click > >> > > _______________________________________________ > >> > > JBoss-user mailing list > >> > > [EMAIL PROTECTED] > >> > > https://lists.sourceforge.net/lists/listinfo/jboss-user > >> > > > >> > > >> > > >> > > >> > ------------------------------------------------------- > >> > This SF.net email is sponsored by: IBM Linux Tutorials. > >> > Become an expert in LINUX or just sharpen your skills. Sign up for > >> IBM's > >> > Free Linux Tutorials. Learn everything from the bash shell to sys > >> admin. > >> > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click > >> > _______________________________________________ > >> > JBoss-user mailing list > >> > [EMAIL PROTECTED] > >> > https://lists.sourceforge.net/lists/listinfo/jboss-user > > -- > > xxxxxxxxxxxxxxxxxxxxxxxx > > Adrian Brock > > Director of Support > > Back Office > > JBoss Group, LLC > > xxxxxxxxxxxxxxxxxxxxxxxx > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: IBM Linux Tutorials. > > Become an expert in LINUX or just sharpen your skills. Sign up > for IBM's > > Free Linux Tutorials. Learn everything from the bash shell to > sys admin. > > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click > > _______________________________________________ > > JBoss-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IBM Linux Tutorials. > Become an expert in LINUX or just sharpen your skills. Sign up for IBM's > Free Linux Tutorials. Learn everything from the bash shell to sys admin. > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
