2 Replies Latest reply on Feb 1, 2003 12:41 PM by glm

    findAll() goes off and never returns

    glm Newbie

      I am using JBoss 3.2.0beta2 and MySQL 4.0.6gamma. I am using CMP2. There are two tables (Packing and Boxes) with a relationship of one-to-many although I don't believe this has a bearing on the problem. There are two records in the database for each table and Boxes stores the PackingId as a foreign-key. When I execute the findAll() function the program never returns. I have included the ejb-jar.xml and the jbosscmp-jdbc.xml for reference.

      Thanks,

      Gary

        • 1. Re: findAll() goes off and never returns
          glm Newbie

          I was able to capture the log just before jboss went into the ether.

          2003-01-31 17:50:27,888 DEBUG [org.jboss.system.Registry] lookup -831461800=jboss.j2ee:jndiName=BoxManagerHome,service=EJB
          2003-01-31 17:50:27,888 DEBUG [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding is null in ProxyFactoryFinder
          2003-01-31 17:50:27,888 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindAllQuery.Boxes.findAll] Executing SQL: SELECT id FROM boxes
          2003-01-31 17:50:27,908 DEBUG [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding is null in ProxyFactoryFinder
          2003-01-31 17:50:27,918 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Boxes] Executing SQL: SELECT id,Length, Width, Height, MaxWeight, BoxWeight, Type, PackingThickness, BoxPrice, PackId FROM boxes WHERE (id=?) OR (id=?) OR (id=?) OR (id=?) OR (id=?) OR (id=?) OR (id=?) OR (id=?) OR (id=?) OR (id=?) OR (id=?) OR (id=?)
          2003-01-31 17:50:27,938 DEBUG [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding is null in ProxyFactoryFinder
          2003-01-31 17:50:27,938 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Packing] Executing SQL: SELECT Status, RecordStatus, PackingThickness FROM packing WHERE (id=?)
          2003-01-31 17:50:27,948 DEBUG [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding is null in ProxyFactoryFinder
          2003-01-31 17:50:27,948 DEBUG [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding is null in ProxyFactoryFinder
          2003-01-31 17:50:27,948 DEBUG [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding is null in ProxyFactoryFinder
          2003-01-31 17:50:27,948 DEBUG [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding is null in ProxyFactoryFinder
          2003-01-31 17:50:27,948 DEBUG [org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor] invokerBInding is null in ProxyFactoryFinder


          the "invokerBInding is null in ProxyFatoryFinder" repeats itself into infinity.

          I hope this helps someone understand the problem.

          Gary

          • 2. Re: findAll() goes off and never returns
            glm Newbie

            I discovered the problem. I had created a helper method for getting the last inserted Id in the database which executes the MySQL LAST_INSERT_ID() function. In my test program I executed this method and then test the findAll() method on the Entity Bean. Apparently MySQL function locks something up such that it causes the findAll() method to timeout. Very strange but interesting.

            Gary