RE: [JBoss-user] Rollback failed

2002-05-21 Thread JD Brennan 
Title: RE: [JBoss-user] Rollback failed





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> age

Re[2]: [JBoss-user] Rollback failed

2002-05-21 Thread Alex Loubyansky 

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 PROTE

Re: [JBoss-user] Rollback failed

2002-05-21 Thread Alex Loubyansky 

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

[JBoss-user] Rollback failed

2002-05-20 Thread Boris Tamarkin 
Title: Rollback failed 





Jboss 3.0.0RC3
Database Mysql with jdbc driver mm.mysql-2.0.13-bin.jar (that included in lib directory of jboss)
Session Bean bean1 with transaction type "Required" calls to Entity Bean CMP2 bean2 that has
transaction type "Supports".
Flow happens inside of method:
1. bean1 calls bean2.create(...)
2. x = doSomething
3. bean1 calls bean2.setSomeOtherField(x)


During step2 Application Exception throwed and bean1 throws to client RemoteException with correct message.
However row created in step1 wasn't deleted and following SQL exception throwed(see below)


Question: Is it my problem , or problem with mysql or jboss?
Thanks


--
19:11:03,833 ERROR [STDERR] java.sql.SQLException: General error: Warning:  Some
 non-transactional changed tables couldn't be rolled back
19:11:03,843 ERROR [STDERR] at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown
Source)
19:11:03,843 ERROR [STDERR] at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unkno
wn Source)
19:11:03,854 ERROR [STDERR] at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Sou
rce)
19:11:03,864 ERROR [STDERR] at org.gjt.mm.mysql.Connection.execSQL(Unknown S
ource)
19:11:03,874 ERROR [STDERR] at org.gjt.mm.mysql.Connection.execSQL(Unknown S
ource)
19:11:03,884 ERROR [STDERR] at org.gjt.mm.mysql.Connection.rollback(Unknown
Source)
19:11:03,894 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalMa
nagedConnection.rollback(LocalManagedConnection.java:245)
19:11:03,904 ERROR [STDERR] at org.jboss.resource.connectionmanager.LocalTxC
onnectionManager$LocalConnectionEventListener.rollback(LocalTxConnectionManager.
java:650)
19:11:03,924 ERROR [STDERR] at org.jboss.tm.TxCapsule.rollbackResources(TxCa
psule.java:1721)
19:11:03,934 ERROR [STDERR] at org.jboss.tm.TxCapsule.rollback(TxCapsule.jav
a:437)
19:11:03,944 ERROR [STDERR] at org.jboss.tm.TransactionImpl.rollback(Transac
tionImpl.java:88)
19:11:03,954 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWit
hTransactions(TxInterceptorCMT.java:180)
19:11:03,964 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke
(TxInterceptorCMT.java:61)
19:11:03,974 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.inv
oke(SecurityInterceptor.java:129)
19:11:03,984 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(L
ogInterceptor.java:166)
19:11:03,994 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer.invok
e(StatelessSessionContainer.java:313)
19:11:03,994 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java
:705)
19:11:04,004 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MB
eanServerImpl.java:491)
19:11:04,014 ERROR [STDERR] at org.jboss.invocation.jrmp.server.JRMPInvoker.
invoke(JRMPInvoker.java:364)
19:11:04,024 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor28.invoke(
Unknown Source)
19:11:04,044 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invo
ke(DelegatingMethodAccessorImpl.java:25)
19:11:04,044 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:3
24)
19:11:04,054 ERROR [STDERR] at sun.rmi.server.UnicastServerRef.dispatch(Unic
astServerRef.java:261)
19:11:04,064 ERROR [STDERR] at sun.rmi.transport.Transport$1.run(Transport.j
ava:148)
19:11:04,074 ERROR [STDERR] at java.security.AccessController.doPrivileged(N
ative Method)
19:11:04,084 ERROR [STDERR] at sun.rmi.transport.Transport.serviceCall(Trans
port.java:144)
19:11:04,094 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport.handleMess
ages(TCPTransport.java:460)
19:11:04,104 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport$Connection
Handler.run(TCPTransport.java:701)
19:11:04,114 ERROR [STDERR] at java.lang.Thread.run(Thread.java:536)
--