2 Replies Latest reply on Mar 29, 2004 4:24 AM by Alexey Loubyansky

    CMP - repeated sql condition

    Petr Fischer Newbie

      This is from selver.log:
      2004-03-23 17:25:26,205 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.FundPerfPeriodEJB] Executing SQL: SELECT ID, NAME, PERIOD_FOR_VALUE FROM FW_PERIODS WHERE (ID=?) OR (ID=?) OR (ID=?) OR (ID=?) OR (ID=?) OR (ID=?) OR (ID=?) OR (ID=?) OR (ID=?)

      Why the part "(ID = ?)" is repeated many times? No problem in this query, but in another query, "where" sql condition is repeated 3876x and my FireBird server resets connection (too long query).

      I am confused (sorry for my bad English). Thanks for help.
      JBoss 3.2.3, JDK 1.4.2_04, Win2000, FireBird 1.0