4 Replies Latest reply on May 26, 2003 3:36 AM by johndoekyrgyz

    Cannot Delete Recently Created EJB: Unknown Managed Connecti

    johndoekyrgyz
    johndoekyrgyz May 22, 2003 6:16 AM

      I have a swing client that connects to the session bean CountryManagerEJB to update, create and delete CountryEJBs. The problem is that I cannot delete a CountryEJB that has just been created. I have to restart the client before the delete will work. Here is some code from the CountryManagerEJB that might be helpful.

      public class CountryManagerBean implements SessionBean
      {
      private LocalCountryHome home;
      public void ejbCreate() throws CreateException
      {
      try
      {
      InitialContext naming = new InitialContext();
      home = (LocalCountryHome)naming.lookup("java:comp/env/CountryEJB");
      }
      catch(NamingException e)
      {
      e.printStackTrace();
      throw new CreateException(e.getExplanation());
      }
      }

      ...

      public void deleteCountry(CountryDTO dto)
      {
      try
      {
      home.remove(new Integer(dto.getId()));
      }
      catch(RemoveException e)
      {
      e.printStackTrace();
      throw new EJBException(e);
      }
      catch(EJBException e)
      {
      e.printStackTrace();
      throw new EJBException(e);
      }
      }
      }

      Here is the stack trace of the error being thrown.

      javax.ejb.TransactionRolledbackLocalException: disconnect(ManagedConnection mc: null, Object c: org.jboss.resource.adapter.jdbc.local.LocalConnection@c4fedd) called with unknown managed connection; CausedByException is:
      disconnect(ManagedConnection mc: null, Object c: org.jboss.resource.adapter.jdbc.local.LocalConnection@c4fedd) called with unknown managed connection
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:224)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:493)
      at org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invoke(BaseLocalContainerInvoker.java:301)
      at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:105)
      at $Proxy119.remove(Unknown Source)
      at server.countrymanager.CountryManagerBean.deleteCountry(CountryManagerBean.java:59)
      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.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:660)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
      at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
      at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
      at org.jboss.ejb.Container.invoke(Container.java:712)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382)
      at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source)
      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)
      java.lang.IllegalArgumentException: disconnect(ManagedConnection mc: null, Object c: org.jboss.resource.adapter.jdbc.local.LocalConnection@c4fedd) called with unknown managed connection
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.unregisterAssociation(BaseConnectionManager2.java:661)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.disconnect(BaseConnectionManager2.java:619)
      at org.jboss.resource.connectionmanager.CachedConnectionManager.disconnect(CachedConnectionManager.java:371)
      at org.jboss.resource.connectionmanager.CachedConnectionManager.popMetaAwareObject(CachedConnectionManager.java:160)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:190)
      at org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:90)
      at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:163)
      at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:107)
      at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:69)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:493)
      at org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invoke(BaseLocalContainerInvoker.java:301)
      at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:105)
      at $Proxy119.remove(Unknown Source)
      at server.countrymanager.CountryManagerBean.deleteCountry(CountryManagerBean.java:59)
      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.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:660)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
      at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
      at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
      at org.jboss.ejb.Container.invoke(Container.java:712)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382)
      at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source)
      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)

      • 2752 Views
      • Tags:
        • 1. Re: Cannot Delete Recently Created EJB: Unknown Managed Conn
          johndoekyrgyz
          johndoekyrgyz May 22, 2003 11:47 PM (in response to johndoekyrgyz)

          I have tested this code on several other databases and have found the same problem. I am wondering wether I need to fiddle with the transaction settings. Any help would be appreciated.

          John

            • Actions
          • 2. Re: Cannot Delete Recently Created EJB: Unknown Managed Conn
            juhalindfors May 23, 2003 1:03 PM (in response to johndoekyrgyz)

            where do you call create() on the entity?

              • Actions
            • 3. Re: Cannot Delete Recently Created EJB: Unknown Managed Conn
              johndoekyrgyz
              johndoekyrgyz May 26, 2003 12:08 AM (in response to johndoekyrgyz)

              I call the create method in the same session bean. The save method just persists a CountryDTO.

              public int saveCountry(CountryDTO dto)
              {
              LocalCountry country = null;
              if(dto.getId() == 0) //The DTO is new
              {
              try
              {
              country = home.create(dto.getNameEng(),dto.getLocalLanguageName(),dto.getLocale());
              }
              catch(CreateException e)
              {
              e.printStackTrace();
              throw new EJBException(e);
              }
              }
              else
              {
              try
              {
              country = home.findByPrimaryKey(new Integer(dto.getId()));
              country.setLocale(dto.getLocale());
              country.setLocalLanguageName(dto.getLocalLanguageName());
              country.setNameEng(dto.getNameEng());
              }
              catch(FinderException e)
              {
              e.printStackTrace();
              throw new EJBException(e);
              }
              }
              return country.getID().intValue();
              }

              I would assume that this method would be running in a seperate transaction from the delete method, but I am not 100% sure. In other tests that I have done where entity beans are being created and deleted within the same transaction seem to work fine.

                • Actions
              • 4. Re: Cannot Delete Recently Created EJB: Unknown Managed Conn
                johndoekyrgyz
                johndoekyrgyz May 26, 2003 3:36 AM (in response to johndoekyrgyz)

                Problem fixed.

                I upgraded to JBoss 3.2.1 and got the following stack trace.

                [CachedConnectionManager] Successfully closed a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@1342572

                I checked the create method. It turns out that it was using database connections to generate a primary key and was not closing them properly.

                Everything is working great now.

                John

                  • Actions