2 Replies Latest reply on Feb 8, 2003 9:21 PM by David Jencks

    DB2 / JBOSS Error

    Chad Lavy Newbie

      Hi,

      When using entity beans to fetch a Collection of data objects, I am getting the following error from DB2:

      The statement is too long or too complex

      The DB2 documentation says that you should increase the DB2 heap size to remedy this. We jacked the heap up quite a bit and still get the error. Alternatively, the documentation says that you should break up your query so that it is not as complex. I have noticed that JBoss seems to create huge SQL statements with a lot of AND's when hitting the database. This occurs despite the fact that the EJBQL describing the statement is pretty simple.

      Has anyone else run into this?

      Is there a way to get JBoss to simplify the queries it issues?

      Thanks In Advance,
      Chad Lavy