Hello Boris, I guess, it's MySQL problem. I haven't got MySQL handling rollbacks and even don't know whether it's able to do it.
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
