findAll() goes off and never returns

[garymarsh]

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

[garymarsh]

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

[garymarsh]

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