I think MySQL uses ISAM tables by default which don't support
transactions (and therefore don't support rollback). If you
use INNODB tables with MySQL you should be able to do transactions
and rollback.
JD
-----Original Message-----
From: Alex Loubyansky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 12:15 AM
To: Boris Tamarkin
Cc: '[EMAIL PROTECTED]'
Subject: Re: [JBoss-user] Rollback failed
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
