5 Replies Latest reply on Oct 21, 2003 4:45 AM by giusalex

    Remote comunication problems with ejbBean

    giusalex

      Hi we are two Jboss newbie and we have remote comunication problems with ejbBean!
      We use:
      - jboss 3.2.1 with jbuilder9
      - mysql
      - 2 Entity EjbBean CMP (A and B)


      Using local comunication (localhost for A and B) it's all OK!

      Our problem is: in bean A when we try to invoke a remote method of bean B (after we have made lookup of B) , jboss gives us the following message:

      javax.ejb.EJBException: Transaction not allowed
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74)
      at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
      at org.jboss.ejb.StatefulSessionContainer.internalInvokeHome(StatefulSessionContainer.java:398)
      at org.jboss.ejb.Container.invoke(Container.java:694)
      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.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
      at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:83)
      at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
      at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
      at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:173)
      at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
      at $Proxy31.create(Unknown Source)
      at tet_1beta.WcsAdminBean.bootstrap(WcsAdminBean.java:89)
      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.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:878)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
      at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:271)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:296)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      at org.jboss.ejb.StatefulSessionContainer.internalInvoke(StatefulSessionContainer.java:410)
      at org.jboss.ejb.Container.invoke(Container.java:674)
      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.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:359)
      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 sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
      at sun.rmi.transport.Transport$1.run(Transport.java:148)
      at java.security.AccessController.doPrivileged(Native Method)
      at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
      at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
      at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
      at java.lang.Thread.run(Thread.java:536)
      10:26:21,245 INFO [STDOUT] RemoteException caught in gtcAdmin = this.gtcadminHome.create() method (ex1)
      10:26:21,246 ERROR [STDERR] java.rmi.ServerException: EJBException:; nested exception is:
      javax.ejb.EJBException: Transaction not allowed
      10:26:21,246 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.handleException(LogInterceptor.java:346)
      10:26:21,246 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:124)
      10:26:21,246 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
      10:26:21,246 ERROR [STDERR] at org.jboss.ejb.StatefulSessionContainer.internalInvokeHome(StatefulSessionContainer.java:398)
      10:26:21,246 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:694)
      10:26:21,247 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      10:26:21,247 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      10:26:21,247 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      10:26:21,247 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      10:26:21,247 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      10:26:21,247 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      10:26:21,247 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
      10:26:21,247 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:83)
      10:26:21,247 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
      10:26:21,247 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
      10:26:21,247 ERROR [STDERR] at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:173)
      10:26:21,247 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
      10:26:21,247 ERROR [STDERR] at $Proxy31.create(Unknown Source)
      10:26:21,247 ERROR [STDERR] at tet_1beta.WcsAdminBean.bootstrap(WcsAdminBean.java:89)
      10:26:21,247 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      10:26:21,247 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      10:26:21,247 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      10:26:21,247 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      10:26:21,248 ERROR [STDERR] at org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:878)
      10:26:21,248 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)
      10:26:21,248 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
      10:26:21,248 ERROR [STDERR] at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:271)
      10:26:21,248 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
      10:26:21,248 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:296)
      10:26:21,248 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)
      10:26:21,248 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      10:26:21,248 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      10:26:21,248 ERROR [STDERR] at org.jboss.ejb.StatefulSessionContainer.internalInvoke(StatefulSessionContainer.java:410)
      10:26:21,248 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:674)
      10:26:21,248 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      10:26:21,248 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      10:26:21,263 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      10:26:21,263 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      10:26:21,263 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      10:26:21,263 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      10:26:21,263 ERROR [STDERR] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:359)
      10:26:21,263 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      10:26:21,263 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      10:26:21,263 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      10:26:21,264 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      10:26:21,264 ERROR [STDERR] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
      10:26:21,264 ERROR [STDERR] at sun.rmi.transport.Transport$1.run(Transport.java:148)
      10:26:21,264 ERROR [STDERR] at java.security.AccessController.doPrivileged(Native Method)
      10:26:21,264 ERROR [STDERR] at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
      10:26:21,264 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
      10:26:21,264 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
      10:26:21,264 ERROR [STDERR] at java.lang.Thread.run(Thread.java:536)
      10:26:21,264 ERROR [STDERR] Caused by: javax.ejb.EJBException: Transaction not allowed
      10:26:21,264 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
      10:26:21,264 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74)
      10:26:21,264 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
      10:26:21,265 ERROR [STDERR] ... 50 more

      Please help us!!

      Thank you in advance for your answers!!

        • 1. Errata Corrige!!
          giusalex

          A and B are two Stateful Session EjbBean!

          • 2. Re: Errata Corrige!!

            You are using transaction attribute NEVER somewhere in your beans ejb-jar.xml descriptor and attempting to invoke that bean with a transaction associated to your thread.

            Per the spec this will throw an exception.

            -- Juha

            • 3. Thank you so much, but ...
              giusalex

              Thank you for yuor help, but we've got some other problems:

              we have setted all the transaction attribute of all method of Bean A and B to REQUIRED and again (when A invoke a remote method of B )the jboss server give us this stack trace:

              13:36:21,380 ERROR [STDERR] java.rmi.MarshalException: error marshalling arguments; nested exception is:
              java.io.NotSerializableException: org.jboss.tm.TransactionImpl

              13:36:21,380 ERROR [STDERR] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:129)

              13:36:21,380 ERROR [STDERR] at org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invoke(Unknown Source)

              13:36:21,380 ERROR [STDERR] at org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.invoke(JRMPInvokerProxy.java:135)

              13:36:21,380 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:87)

              13:36:21,380 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)

              13:36:21,380 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)

              13:36:21,380 ERROR [STDERR] at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:173)

              13:36:21,380 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)

              13:36:21,380 ERROR [STDERR] at $Proxy64.create(Unknown Source)

              13:36:21,380 ERROR [STDERR] at tet_1beta.WcsAdminBean.bootstrap(WcsAdminBean.java:54)

              13:36:21,380 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              13:36:21,380 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              13:36:21,380 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              13:36:21,380 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)

              13:36:21,380 ERROR [STDERR] at org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:878)

              13:36:21,380 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)

              13:36:21,380 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)

              13:36:21,380 ERROR [STDERR] at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:271)

              13:36:21,380 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)

              13:36:21,380 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243)

              13:36:21,380 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)

              13:36:21,380 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)

              13:36:21,380 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)

              13:36:21,380 ERROR [STDERR] at org.jboss.ejb.StatefulSessionContainer.internalInvoke(StatefulSessionContainer.java:410)

              13:36:21,380 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:674)

              13:36:21,380 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              13:36:21,380 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              13:36:21,380 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              13:36:21,380 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)

              13:36:21,380 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

              13:36:21,380 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

              13:36:21,380 ERROR [STDERR] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:359)

              13:36:21,380 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              13:36:21,380 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              13:36:21,380 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              13:36:21,380 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)

              13:36:21,380 ERROR [STDERR] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)

              13:36:21,380 ERROR [STDERR] at sun.rmi.transport.Transport$1.run(Transport.java:148)

              13:36:21,380 ERROR [STDERR] at java.security.AccessController.doPrivileged(Native Method)

              13:36:21,380 ERROR [STDERR] at sun.rmi.transport.Transport.serviceCall(Transport.java:144)

              13:36:21,380 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)

              13:36:21,380 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)

              13:36:21,380 ERROR [STDERR] at java.lang.Thread.run(Thread.java:536)

              13:36:21,380 ERROR [STDERR] Caused by: java.io.NotSerializableException: org.jboss.tm.TransactionImpl

              13:36:21,380 ERROR [STDERR] at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1054)

              13:36:21,380 ERROR [STDERR] at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:278)

              13:36:21,380 ERROR [STDERR] at org.jboss.invocation.MarshalledInvocation.writeExternal(MarshalledInvocation.java:381)

              13:36:21,380 ERROR [STDERR] at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1262)

              13:36:21,380 ERROR [STDERR] at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1243)

              13:36:21,380 ERROR [STDERR] at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1052)

              13:36:21,380 ERROR [STDERR] at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:278)

              13:36:21,380 ERROR [STDERR] at sun.rmi.server.UnicastRef.marshalValue(UnicastRef.java:265)

              13:36:21,380 ERROR [STDERR] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:124)

              13:36:21,380 ERROR [STDERR] ... 42 more


              Please help us!

              Thank you again!!

              • 4. Re: Thank you so much, but ...

                See this thread:
                http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t= to latest 3.2.2 (released yesterday)

                -- Juha

                • 5. Other problem!
                  giusalex

                  We have downloaded and installed jboss 3.2.2 but we have many problems with its configuration:

                  1) when we start jboss 3.2.2 under jbuilder9 (with Voyager JBoss AppServer Open Tool v.2.5) we have this info:

                  11:15:54,592 INFO [Engine] StandardHost[localhost]: MAPPING configuration error for request URI /


                  this message not stop the execution of jboss, but we would know from what kind of settings it depends;

                  2) To use MySql ,we have setted properly these files:
                  - JBOSS_HOME/server/default/deploy/mysql-ds.xml
                  - JBOSS_HOME/server/default/conf/standardjaws.xml
                  - JBOSS_HOME/server/default/conf/standardjbosscmp-jdbc.xml
                  - JBOSS_HOME/server/default/deploy/jms/mysql-jdbc2-service.xml
                  and we have removed:
                  - JBOSS_HOME/server/default/deploy/hsqldb-ds.xml
                  - JBOSS_HOME/server/default/deploy/jms/hsqldb-jdbc2-service.xml

                  And all seems ok! But when we try to write in a table (User) using an Entity EJB (UserEJB) and its client we have this error:

                  java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'User(id, name, surname, address, tel_num, is_sender, pwd, city)"
                  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651)
                  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889)
                  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956)
                  at com.mysql.jdbc.Connection.execSQL(Connection.java:1874)
                  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1700)
                  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1569)
                  at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:321)
                  at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.executeInsert(JDBCAbstractCreateCommand.java:334)
                  at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:295)
                  at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:144)
                  at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:518)
                  at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
                  at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
                  at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:580)
                  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.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1042)
                  at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
                  at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
                  at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
                  at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
                  at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
                  at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
                  at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
                  at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
                  at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
                  at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
                  at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
                  at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
                  at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
                  at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:484)
                  at org.jboss.ejb.Container.invoke(Container.java:720)
                  at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:293)
                  at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
                  at $Proxy45.create(Unknown Source)
                  at tet_1beta.InvAdminBean.parcelInfo(InvAdminBean.java:55)
                  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.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:928)
                  at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
                  at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
                  at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:269)
                  at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
                  at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
                  at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
                  at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
                  at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
                  at org.jboss.ejb.StatefulSessionContainer.internalInvoke(StatefulSessionContainer.java:416)
                  at org.jboss.ejb.Container.invoke(Container.java:700)
                  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.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
                  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
                  at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:367)
                  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 sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
                  at sun.rmi.transport.Transport$1.run(Transport.java:148)
                  at java.security.AccessController.doPrivileged(Native Method)
                  at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
                  at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
                  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
                  at java.lang.Thread.run(Thread.java:536)


                  Is this a problem of mysql? And why this operation work on jboss 3.2.1 and not in jboss3.2.2 ? Is it again a problem of configuration?




                  Please answer us!

                  thank you in advance!