Hello Alex, This http://www.innodb.com/howtouse.html says it's possible :)
Good luck, alex Tuesday, May 21, 2002, 10:15:02 AM, you wrote: AL> Hello Boris, AL> I guess, it's MySQL problem. I haven't got MySQL handling rollbacks AL> and even don't know whether it's able to do it. AL> Tuesday, May 21, 2002, 5:29:54 AM, you wrote: BT>> Jboss 3.0.0RC3 BT>> Database Mysql with jdbc driver mm.mysql-2.0.13-bin.jar (that included in BT>> lib directory of jboss) BT>> Session Bean bean1 with transaction type "Required" calls to Entity Bean BT>> CMP2 bean2 that has BT>> transaction type "Supports". BT>> Flow happens inside of method: BT>> 1. bean1 calls bean2.create(...) BT>> 2. x = doSomething BT>> 3. bean1 calls bean2.setSomeOtherField(x) BT>> During step2 Application Exception throwed and bean1 throws to client BT>> RemoteException with correct message. BT>> However row created in step1 wasn't deleted and following SQL exception BT>> throwed(see below) BT>> Question: Is it my problem , or problem with mysql or jboss? BT>> Thanks BT>> ---------------------- BT>> 19:11:03,833 ERROR [STDERR] java.sql.SQLException: General error: Warning: BT>> Some BT>> non-transactional changed tables couldn't be rolled back BT>> 19:11:03,843 ERROR [STDERR] at BT>> org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown BT>> Source) BT>> 19:11:03,843 ERROR [STDERR] at BT>> org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unkno BT>> wn Source) BT>> 19:11:03,854 ERROR [STDERR] at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown BT>> Sou BT>> rce) BT>> 19:11:03,864 ERROR [STDERR] at BT>> org.gjt.mm.mysql.Connection.execSQL(Unknown S BT>> ource) BT>> 19:11:03,874 ERROR [STDERR] at BT>> org.gjt.mm.mysql.Connection.execSQL(Unknown S BT>> ource) BT>> 19:11:03,884 ERROR [STDERR] at BT>> org.gjt.mm.mysql.Connection.rollback(Unknown BT>> Source) BT>> 19:11:03,894 ERROR [STDERR] at BT>> org.jboss.resource.adapter.jdbc.local.LocalMa BT>> nagedConnection.rollback(LocalManagedConnection.java:245) BT>> 19:11:03,904 ERROR [STDERR] at BT>> org.jboss.resource.connectionmanager.LocalTxC BT>> onnectionManager$LocalConnectionEventListener.rollback(LocalTxConnectionMana BT>> ger. BT>> java:650) BT>> 19:11:03,924 ERROR [STDERR] at BT>> org.jboss.tm.TxCapsule.rollbackResources(TxCa BT>> psule.java:1721) BT>> 19:11:03,934 ERROR [STDERR] at BT>> org.jboss.tm.TxCapsule.rollback(TxCapsule.jav BT>> a:437) BT>> 19:11:03,944 ERROR [STDERR] at BT>> org.jboss.tm.TransactionImpl.rollback(Transac BT>> tionImpl.java:88) BT>> 19:11:03,954 ERROR [STDERR] at BT>> org.jboss.ejb.plugins.TxInterceptorCMT.runWit BT>> hTransactions(TxInterceptorCMT.java:180) BT>> 19:11:03,964 ERROR [STDERR] at BT>> org.jboss.ejb.plugins.TxInterceptorCMT.invoke BT>> (TxInterceptorCMT.java:61) BT>> 19:11:03,974 ERROR [STDERR] at BT>> org.jboss.ejb.plugins.SecurityInterceptor.inv BT>> oke(SecurityInterceptor.java:129) BT>> 19:11:03,984 ERROR [STDERR] at BT>> org.jboss.ejb.plugins.LogInterceptor.invoke(L BT>> ogInterceptor.java:166) BT>> 19:11:03,994 ERROR [STDERR] at BT>> org.jboss.ejb.StatelessSessionContainer.invok BT>> e(StatelessSessionContainer.java:313) BT>> 19:11:03,994 ERROR [STDERR] at BT>> org.jboss.ejb.Container.invoke(Container.java BT>> :705) BT>> 19:11:04,004 ERROR [STDERR] at BT>> org.jboss.mx.server.MBeanServerImpl.invoke(MB BT>> eanServerImpl.java:491) BT>> 19:11:04,014 ERROR [STDERR] at BT>> org.jboss.invocation.jrmp.server.JRMPInvoker. BT>> invoke(JRMPInvoker.java:364) BT>> 19:11:04,024 ERROR [STDERR] at BT>> sun.reflect.GeneratedMethodAccessor28.invoke( BT>> Unknown Source) BT>> 19:11:04,044 ERROR [STDERR] at BT>> sun.reflect.DelegatingMethodAccessorImpl.invo BT>> ke(DelegatingMethodAccessorImpl.java:25) BT>> 19:11:04,044 ERROR [STDERR] at BT>> java.lang.reflect.Method.invoke(Method.java:3 BT>> 24) BT>> 19:11:04,054 ERROR [STDERR] at BT>> sun.rmi.server.UnicastServerRef.dispatch(Unic BT>> astServerRef.java:261) BT>> 19:11:04,064 ERROR [STDERR] at BT>> sun.rmi.transport.Transport$1.run(Transport.j BT>> ava:148) BT>> 19:11:04,074 ERROR [STDERR] at BT>> java.security.AccessController.doPrivileged(N BT>> ative Method) BT>> 19:11:04,084 ERROR [STDERR] at BT>> sun.rmi.transport.Transport.serviceCall(Trans BT>> port.java:144) BT>> 19:11:04,094 ERROR [STDERR] at BT>> sun.rmi.transport.tcp.TCPTransport.handleMess BT>> ages(TCPTransport.java:460) BT>> 19:11:04,104 ERROR [STDERR] at BT>> sun.rmi.transport.tcp.TCPTransport$Connection BT>> Handler.run(TCPTransport.java:701) BT>> 19:11:04,114 ERROR [STDERR] at java.lang.Thread.run(Thread.java:536) BT>> ------------------ -- Best regards, Alex Loubyansky _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user