Thank you very much, but this didnt solve my problem. I am looking arround at the net, and it seems like a lot of peoploe have the same problem - no answers....
I guess it has to do somthing with my mySQL db. Does anybody know how to configure a mysql as XA Datasource in JBoss ?
<datasources>
<local-tx-datasource>
<jndi-name>OmaDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/oma</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>xxx</user-name>
<password>xxx</password>
<connection-property name="autoReconnect">true</connection-property>
<!--pooling parameters-->
<min-pool-size>5</min-pool-size>
<max-pool-size>50</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
<prepared-statement-cache-size>1000</prepared-statement-cache-size>
</local-tx-datasource>
</datasources>
Thanks again, any help appreciated
Stefan
> At 14:42 22.12.2003, [EMAIL PROTECTED] wrote: >>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(){ > > try this: > > try { > >> entityHome.create(1); >> entityHome.create(2); >> entityHome.create(3); >> return; > > catch (CreateException ce) { > logger.fatal("createXXX() failed", ce); > sessionContext.setRollbackOnly(); > throw ce; > } > > Rafal > >>} >> >>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 >
------------------------------------------------------- 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
