Hello,

When I call the findAll() method on a CMP entity bean I've written, I'm
getting a stack trace containing this exception:

java.rmi.ServerException: Store failed; nested exception is:
com.sybase.jdbc2.jdbc.SybSQLException: Too many table names or referential
constraints in the query, maximum allowed table references is '16'.

I don't believe there is any configuration problem mainly because I have a
very similar CMP entity bean in the same JAR, using the same database, that
seems to work fine. On the other hand, this method is automatically provided
by the container, so I don't see how it could be a problem specific to the
bean. According to the deployer, the bean deploys correctly with no
warnings, which suggests that the deployment descriptors aren't broken. I've
gone over them all about six times and I find no problems.

I could get to the bottom of this if I could just see what the container is
doing when the findAll() is triggered. My question is: is there a way to
print or log the SQL SELECT statement that the container has executed on my
entity bean's behalf? If not, can anyone suggest a good way to debug
something like this?

Any help is appreciated. Thanks in advance.
--
Jason Wells
Web Architect
Xsilogy, Inc.
http://www.xsilogy.com/


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to