7 Replies Latest reply on Sep 9, 2002 4:24 PM by Dain Sundstrom

    problem with strategies (on-find,on-load)

    Adam Bien Newbie

      I have a problem with a CMP 2.0 and compound key. The SQL-Query for the ejbLoad Method looks very strange. For every row a additional "or" statement will be generated:

      where x and y
      where x and y or x and y
      where x and y or x and y or x and y

      etc.

      I'm using JBoss 3.0.2. The same bean is running perfectly on wls 6.1, wls 7.0 and j2ee 1.3.1 ri.

      Any suggestions? ...I'm using the settings from the Jboss documentation bundle...

        • 1. Re: problem with strategies (on-find,on-load)
          Jochen Cordes Novice

          Hi abien !

          Neither I'm using compound keys (just single valued) nor a strategy, but I also get the SQL statements you reported. I tried it with jboss-3.0.1 and Jboss-4.0.0 alpha (using MySQL). Maybe it's a bug in the JDBCEntityBridge ? Still everything runs fine, but I'm not quite sure how database performance is impacted.

          Hopefully Dain may help us.

          Bye,

          Jochen.

          P.S.: Are you Adam Bien ?

          • 2. Re: problem with strategies (on-find,on-load)
            Adam Bien Newbie

            Yes I'am (adam bien) :) You know me?

            The is no database performance, because it crashes in my case (SQL to complicated) :).


            • 3. Re: problem with strategies (on-find,on-load)
              Jochen Cordes Novice

              Hi Adam !

              Yes, I know you. Just recently read your book about J2EE Patterns (it helped a lot, thanks). After digging in the sourcecode of org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand I think what's going on is this:
              1. a finder method is executed, which retrieves the primary-keys.
              2. Now these primary-keys are used to load the entity, but instead of using multiple sql-statements the primary-keys are appended to the where-clause, "optimizing" the select

              Maybe I'm totally wrong on this.

              Bye,

              Jochen.

              • 4. Re: problem with strategies (on-find,on-load)
                Adam Bien Newbie

                Hi Jochen,

                in case you like my book, then put a comment on amazon.de :-).

                This bug or feature is the real reason for my late production date of www.star-finder.com. Now I rewrite the already existing CMP 2.0 Entity (StarBean) to BMP with DAO. I hope it will work (perhaps tomorrow:-)).

                But... I would like to compare the performance of CMP 2.0 and BMP in my third book "J2EE HotSpots". I guess it will be not possible on JBoss 3.0.2.

                Any suggestions, hacks, solutions???

                I guess it is a *real* bug.

                best regards,

                thx,

                adam

                Just an except from the server.xml...

                Executing SQL: SELECT t0_o.declinationZone, t0_o.numberWithinZone, t0_o.catalogPrefix, t0_o.note, t0_o.zoneSign FROM STARBEAN t0_o WHERE t0_o.declinationDegrees = ? AND t0_o.declinationMinutes = ?
                2002-09-04 07:22:08,036 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.StarBean] Executing SQL: SELECT declinationZone, numberWithinZone, catalogPrefix, note, zoneSign,signOfDeclination, rightAscentionSeconds, rightAscensionHours, magnitude, rightAscensionMinutes, declinationDegrees, declinationMinutes FROM STARBEAN WHERE (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?)
                2002-09-04 07:22:08,056 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.StarBean] Executing SQL: SELECT declinationZone, numberWithinZone, catalogPrefix, note, zoneSign,signOfDeclination, rightAscentionSeconds, rightAscensionHours, magnitude, rightAscensionMinutes, declinationDegrees, declinationMinutes FROM STARBEAN WHERE (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?)
                2002-09-04 07:22:08,086 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.StarBean] Executing SQL: SELECT declinationZone, numberWithinZone, catalogPrefix, note, zoneSign,signOfDeclination, rightAscentionSeconds, rightAscensionHours, magnitude, rightAscensionMinutes, declinationDegrees, declinationMinutes FROM STARBEAN WHERE (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?)
                2002-09-04 07:22:08,106 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.StarBean] Executing SQL: SELECT declinationZone, numberWithinZone, catalogPrefix, note, zoneSign,signOfDeclination, rightAscentionSeconds, rightAscensionHours, magnitude, rightAscensionMinutes, declinationDegrees, declinationMinutes FROM STARBEAN WHERE (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?)
                2002-09-04 07:22:08,126 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.StarBean] Executing SQL: SELECT declinationZone, numberWithinZone, catalogPrefix, note, zoneSign,signOfDeclination, rightAscentionSeconds, rightAscensionHours, magnitude, rightAscensionMinutes, declinationDegrees, declinationMinutes FROM STARBEAN WHERE (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?)
                2002-09-04 07:22:08,147 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.StarBean] Executing SQL: SELECT declinationZone, numberWithinZone, catalogPrefix, note, zoneSign,signOfDeclination, rightAscentionSeconds, rightAscensionHours, magnitude, rightAscensionMinutes, declinationDegrees, declinationMinutes FROM STARBEAN WHERE (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?)
                2002-09-04 07:22:08,157 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.StarBean] Executing SQL: S


                • 5. Re: problem with strategies (on-find,on-load)
                  Dain Sundstrom Master

                  > This bug or feature is the real reason for my late

                  Is is a feature, but it looks like a bug in you case.

                  > production date of www.star-finder.com. Now I rewrite
                  > the already existing CMP 2.0 Entity (StarBean) to BMP
                  > with DAO. I hope it will work (perhaps tomorrow:-)).

                  You should have asked earlier.

                  > But... I would like to compare the performance of CMP
                  > 2.0 and BMP in my third book "J2EE HotSpots". I guess
                  > it will be not possible on JBoss 3.0.2.
                  >
                  > Any suggestions, hacks, solutions???

                  I have two suggestions. Don't use mySQL for preformance tests use PostgreSQL. MySQL prefromace tanks on complex queries. Secondly don't use compond primary keys for preformace tests. The extra key is hard for mySQL to optimize (and some other big databases like Oracle).

                  If you do find HotSpots, send me an email and I'll stomp them out.

                  In the mean time I susggest you reduce the page-size of the optimized loading to something like 50. Also, you may want to read my documentation on optimizing the loading system. Chapter 6 of the JBossCMP documentation available from flashline ($10).

                  • 6. Re: problem with strategies (on-find,on-load)
                    Adam Bien Newbie

                    I'm using SAPDB. Regardless which configuration I set (on-find, on-load, none or without any entries) it does not work. Is there a possibility to set this "feature" off?

                    I have the whole JBoss documentation (subscription).


                    In case I'll find some "HotSpots" I will send it to you.
                    (Just drop me an email on: abien@java-architect.com or www.java-architect.com)
                    I'd like to measure the performance with JProbe 4.0 => in case it works I'll try to bundle the settings for JBoss with JProbe 4.XX (I know the sitraka guys...)

                    best regards,

                    thanks,

                    adam



                    Logs:

                    and Session org.mortbay.jetty.servlet.HashSessionManager$Session@5cc135
                    2002-09-04 07:23:59,807 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.StarBean.findByDeclinationInRange] Executing SQL: SELECT t0_o.declinationZone, t0_o.numberWithinZone, t0_o.catalogPrefix, t0_o.note, t0_o.zoneSign FROM STARBEAN t0_o WHERE t0_o.declinationDegrees BETWEEN ? AND ?
                    2002-09-04 07:25:00,414 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.StarBean] Executing SQL: SELECT declinationZone, numberWithinZone, catalogPrefix, note, zoneSign,signOfDeclination, rightAscentionSeconds, rightAscensionHours, magnitude, rightAscensionMinutes, declinationDegrees, declinationMinutes FROM STARBEAN WHERE (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?) OR (declinationZone=? AND numberWithinZone=? AND catalogPrefix=? AND note=? AND zoneSign=?)
                    2002-09-04 07:25:00,454 ERROR [org.jboss.ejb.plugins.LogInterceptor] EJBException, causedBy:
                    com.sap.dbtech.jdbc.exceptions.DatabaseException: SAP DBTech SQL: [-1105] (at 4087) Too complicated SQL statement (too much data)
                    at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:51)
                    at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:656)
                    at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:338)
                    at com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1278)
                    at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:619)
                    at com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:215)
                    at com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:182)
                    at com.sap.dbtech.jdbc.CallableStatementSapDB.(CallableStatementSapDB.java:59)
                    at com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:549)
                    at org.jboss.resource.adapter.jdbc.local.LocalConnection.prepareStatement(LocalConnection.java:191)
                    at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:106)
                    at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:62)
                    at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:572)
                    at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:410)
                    at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor.java:353)
                    at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:262)
                    at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
                    at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:152)
                    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:203)
                    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.EntityProxy.invoke(EntityProxy.java:38)

                    • 7. Re: problem with strategies (on-find,on-load)
                      Dain Sundstrom Master

                      You can turn it off by setting readahead to none, but it will slow down the server.