Hello folks,
I had always being using Tomcat, and likes it quite much ...
now switching to JBOSS 3.2 simply becuz my boss loves it (and it's name) :( and
here the nightmare begins
We use jboss to provide both EJB and Web service with Axis & MYSQL 4.2.
The Client program might be perl, C++, C#, Java or any other.
All "SELECT" queries is executed perfectly, but all update/insert always having this
or that problem from time to time, Esp. when inserting big BLOB data.
JBossRolledBackException occurrs most frequently,
I'v tried different versions of MysqlJ Connector 3.0 & 3.1 & 2.0,
Mysql server from 3.2 to 4.0, Jboss 3.2 & 4.0. BUT JUST NO USE.
but /var/log/mysqld.log shows everything's fine.
and here's the stack trace: THANKS IN ADVANCE.
15:28:46,371 ERROR [LogInterceptor] TransactionRolledbackException in method: public
abstract void
com.ipanel.dtvserver.appserver.ejb.StockDataFacade.createStockApp(int,java.lang.String,byte[])
throws java.rmi.RemoteException, causedBy:
org.jboss.tm.JBossRollbackException: Unable to commit,
tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=localhost.localdomain/13,
BranchQual=, localId=13] status=STATUS_NO_TRANSACTION; - nested throwable:
(javax.ejb.EJBException: null; CausedByException is:
null)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:344)
at
org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:457)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:325)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:149)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:603)
at org.jboss.ejb.Container.invoke(Container.java:810)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:232)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:643)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
at
org.jboss.proxy.ejb.StatefulSessionInterceptor.invoke(StatefulSessionInterceptor.java:105)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
at $Proxy116.createStockApp(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:376)
at
org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:278)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:290)
at
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:481)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:285)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:623)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:301)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.c